Getting value using GET from url

Discussion in 'PHP' started by vivek_master146, Oct 22, 2012.

  1. #1
    I have two php files main.php and student_viewall.php. I am trying to send the value from main.php via a hyperlink
    echo "<td><a href='student_viewall.php?id=$id'><font size='2' face='Arial'>$name</font></a></td></tr>";
    Code (markup):
    . The url is displaying the values correctly but i am unable to extract the value using GET method. Please advice.



    <html>
    <body>
    <table width="100%" border="0" cellspacing="0" cellpadding="2">
      <tr>
        <td align="center"><h1><font color="#0000FF" face="Arial">STUDENT LIST</font></h1></td>
      </tr>
    </table>
    <br><br>
    <table width="100%" border="0" cellspacing="0" cellpadding="2">
      <tr> 
        <td align="right"><font size="1" face="Arial"><a href='student_form.php'>Add Student</a> | <a href='student_edit.php'>Edit Student</a></font></td>
      </tr>
    </table>
    <br><br>
    <?php
    
    	include 'db_connect.php';
    	
    	$sql= "SELECT id, matric, name FROM info ORDER BY matric";
    	$result= mysql_query($sql) or die ("Could not connect to MYSQL");
    	$counter=1;
    	echo "<table width='70%' bordercolor='#666666' border='0' cellspacing='2' cellpadding='2' align='center'>";
    	echo "<tr bgcolor='#CCCCCC'><td align='center'><font size='2' face='Arial'><b>#</b></font></td>";
    	echo "<td><font size='2' face='Arial'><b>Matric Number</b></font></td>";
    	echo "<td><font size='2' face='Arial'><b>Name<b/></font></td></tr>";
    	
    	while ($row= mysql_fetch_array($result)){
    	
    		$id=$row["id"];
    		$matric=$row["matric"];
    		$name=$row["name"];
    		
    	if ($counter % 2 !=0){
    	echo "<tr bgcolor='#E5E5E5'><td align='center'><font size='2' face='Arial'>$counter</font></td>";
    	echo "<td><font size='2' face='Arial'>$matric</font></td>";
    	echo "<td><a href='student_viewall.php?id=$id'><font size='2' face='Arial'>$name</font></a></td></tr>";
    	}
    	else{
    	echo "<tr bgcolor='#CCFFCC'><td align='center'><font size='2' face='Arial'>$counter</font></td>";
    	echo "<td><font size='2' face='Arial'>$matric</font></td>";
    	echo "<td><a href='student_viewall.php?id=$id'><font size='2' face='Arial'>$name</font></a></td></tr>";
    	}
    
    	$counter++;
    	}
    	echo "</table>";
    ?>
    
    </body>
    </html>
    
    PHP:

    
    <html>
    <body>
    <table width="100%" border="0" cellspacing="0" cellpadding="2">
      <tr>
        <td align="center"><h1><font color='#0000FF' face="Arial">STUDENT PROFILE</font></h1></td>
      </tr>
    </table>
    <br><br>
    <table width="100%" border="0" cellspacing="0" cellpadding="2">
      <tr>
        <td align="right"><font size="1" face="Arial"><a href='main.php'>Student List</a></font></td>
      </tr>
    </table>
    <br><br>
    <table width="70%" bordercolor='white' bgcolor='silver' border="1" align="center" cellpadding="2" cellspacing="0">
    <?php
    		include 'db_connect.php';
    $id=$_GET['id'];
    echo $id;
    
    		$sql= "SELECT * FROM info WHERE id=$id;
    		$result = mysql_query($sql);
    			
    		while ($row=mysql_fetch_array($result))
    		{
    			$id=$row["id"];
    			$matric=$row["matric"];
    			$name=$row["name"];
    			$course=$row["course"];
    			$sem=$row["sem"];
    			$sex=$row["sex"];
    			$tel=$row["tel"];
    			$address=$row["address"];
    ?>
      <tr> 
        <td width="30%" rowspan="7" align="center"><img src="student_picture.php?id=$id width="200" height="180"></td>
        <td>&nbsp;</td>
        <td colspan="3" bgcolor="#99FFCC"><font size="3" color='#0000CC' face="Arial"><b>STUDENT</b></font></td>
      </tr>
      <tr> 
        <td width="2%">&nbsp;</td>
        <td width="20%"><font size="2" face="Arial"><b>Matric Number</b></font></td>
        <td width="2%" align="center">:</td>
        <td width="46%"><font size="2" face="Arial"><?php echo"$matric"; ?></font></td>
      </tr>
      <tr> 
        <td>&nbsp;</td>
        <td><font size="2" face="Arial"><b>Name</b></font></td>
        <td align="center">:</td>
        <td><font size="2" face="Arial"><?php echo"$name"; ?></font></td>
      </tr>
      <tr> 
        <td>&nbsp;</td>
        <td><font size="2" face="Arial"><b>Course</b></font></td>
        <td align="center">:</td>
        <td><font size="2" face="Arial"><?php echo"$course"; ?></font></td>
      </tr>
      <tr> 
        <td>&nbsp;</td>
        <td><font size="2" face="Arial"><b>Semester</b></font></td>
        <td align="center">:</td>
        <td><font size="2" face="Arial"><?php echo"$sem"; ?></font></td>
      </tr>
      <tr> 
        <td>&nbsp;</td>
        <td><font size="2" face="Arial"><b>Sex</b></font></td>
        <td align="center">:</td>
        <td><font size="2" face="Arial"><?php echo"$sex"; ?></font></td>
      </tr>
      <tr> 
        <td>&nbsp;</td>
        <td><font size="2" face="Arial"><b>Contact Number</b></font></td>
        <td align="center">:</td>
        <td><font size="2" face="Arial"><?php echo"$tel"; ?></font></td>
      </tr>
      <tr> 
        <td align="right"><font size="2" face="Arial"><b>Address</b></font></td>
        <td align="center">:</td>
        <td colspan="3"><font size="2" face="Arial"><?php echo"$address"; ?></font></td>
      </tr>
      </table>
    
    
    
    </body>
    </html>
    
    
    PHP:

     
    vivek_master146, Oct 22, 2012 IP
  2. Codexer

    Codexer Greenhorn

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #2
    Does it show up in the URL in the browser window? Or is it not existent there?
     
    Codexer, Oct 23, 2012 IP
  3. scottlpool2003

    scottlpool2003 Well-Known Member

    Messages:
    1,708
    Likes Received:
    49
    Best Answers:
    9
    Trophy Points:
    150
    #3
    Try moving it up above your dbconnect.php and see if there's any change...
     
    scottlpool2003, Oct 23, 2012 IP
  4. Ajayu1992

    Ajayu1992 Active Member

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    73
    #4
    echo "<td><a href='student_viewall.php?id=$id'><font size='2' face='Arial'>$name</font></a></td></tr>";

    Isnt that
    echo "<td><a href='student_viewall.php?id=$id'><font size='2' face='Arial'>{$name}</font></a></td></tr>";
    I think you have to do this for everything.

    Sorry if i am wrong.
     
    Ajayu1992, Oct 23, 2012 IP
  5. scottlpool2003

    scottlpool2003 Well-Known Member

    Messages:
    1,708
    Likes Received:
    49
    Best Answers:
    9
    Trophy Points:
    150
    #5
    He wants to get the 'ID' value from the URL where did $name come into your reply?
     
    scottlpool2003, Oct 24, 2012 IP
  6. Ajayu1992

    Ajayu1992 Active Member

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    73
    #6
    You need to use $_GET[] so that you can get values from url. Right ?
     
    Last edited: Oct 24, 2012
    Ajayu1992, Oct 24, 2012 IP
  7. pixelator

    pixelator Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Try to do some testing like printing all the $_GET values.

    in your target page do this to show the GET array.

    <? print_r($_GET); ?>
     
    pixelator, Oct 24, 2012 IP