search page

uaeustudent · May 28, 2007

Hi all;

I am working in php cade. I have page to insert information, and other page include button linked to that page. But it should contain the information which was inserted.

This is my code " they are all in the same page"

PHP Code:

<?php

$host = "localhost";

$user = "";

$password = "";

$db = "job seeker";

$table = "personalinformation";

mysql_connect($host,$user,$password) or die("Failed to connect");

mysql_select_db($db) or die("Falied to select database");

$sql = "SELECT * FROM $table ORDER BY id ASC;";

$result = mysql_query($sql);

$id = $_GET["id"];

$sql = "SELECT * FROM $table WHERE id='$id'";

?>

HTML Code:

<html>

<head>

</script>

<title>Job Preference form</title>

</head>

<tr>

<td>

<p align="left"><b><font size="5">Personal Information form</font><span style="font-size: 12.0pt; font-family: Verdana; color: black">

</span></b></td>

</tr>

<tr>

<td>

<input type="text" name="Address" size="20" value="$myrow[Address]">Address </td>

</tr>

<tr>

<td>

</tr>

<tr>

<td>

<p align="left"><input type="text" name="PhoneNumber" size="20" value="$myrow[PhoneNumber]">PhoneNumber </td>

</tr>

<tr>

<td>

</tr>

<tr>

<td>

<p align="left"><b><font size="5">Job Preference form</font></b></td>

</tr>

<tr>

<td>

<p align="left"><input type="text" name="Fax" size="20" value="$myrow[specialization]">Specialization </td>

</tr>

<tr>

<td>

<p align="left"><input type="text" name="Fax" size="20" value="$myrow[TargetSalary]">TargetSalary </td>

</tr>

<tr>

<td>

<p align="left"><input type="text" name="Fax" size="20" value="$myrow[JobType]">JobType </td>

</tr>

<tr>

<td>

<input type="radio" value="$myrow[WillingToRelocate]" name="WillingToRelocate"> Willing to Relocate

</span></td>

</tr>

</table>

</form>

</body>

</head>

gabeg · May 28, 2007

A couple of things...

1. Your second $sql variable overwrites your first, and you should only have one query to make this call

"SELECT * FROM $table WHERE id=$id LIMIT 1"

2. You never run the query to the database..do

<?php
$query = "SELECT * FROM $table WHERE id=$id LIMIT 1";
$result = mysql_query($query) or die("problem with query: ".$query);
$row = mysql_fetch_array($result);
?>

3. You make calls to php variables inside your html. If you want do that, use this format <?=$row['address'];?>

MadTechie · May 28, 2007

i agree on all except the <?=

personally i use <?php echo $row['address']; ?>

personal preference i guess

gabeg · May 28, 2007

i agree on all except the <?=

personally i use <?php echo $row['address']; ?>

personal preference i guess

Is one more efficient than the other, or is there really no difference?

MadTechie · May 28, 2007

no differents really i just try not to use short_open_tag as it can be turned off and then the code fails to parser

php.ini short_open_tag

short_open_tag boolean

Tells whether the short form (<? ?>) of PHP's open tag should be allowed. If you want to use PHP in combination with XML, you can disable this option in order to use <?xml ?> inline. Otherwise, you can print it with PHP, for example: <?php echo '<?xml version="1.0"'; ?>. Also if disabled, you must use the long form of the PHP open tag (<?php ?>).

Note: This directive also affects the shorthand <?=, which is identical to <? echo. Use of this shortcut requires short_open_tag to be on.

uaeustudent · May 28, 2007

Thanks all for your help, but I have tow comand

First when I change the php code I have this result :

problem with query: SELECT * FROM WHERE id= LIMIT 1

Secondly, where I should put this code

<?=$row['address'];?>

MadTechie · May 28, 2007

1st open the page with pagename.php?id=id

pagename being the file name and id being the id number

2nd replace

$row[address];

with

<?=$row['address'];?>

in the HTML Code: section

NB: use the same idea as address for City

ie

$myrow[City]

to

<?=$row['City'];?>

uaeustudent · May 28, 2007

Sorry but I change the code but it doesnt work

The code

<head>

<title>Job Preference form</title>

</head>

<?php

$host = "localhost";

$user = "";

$password = "";

$db = "job seeker";

$table = "personalinformation";

?>

<tr>

<td>

</tr>

<tr>

<td>

<p align="left"><b><font size="5">Personal Information form</font><span style="font-size: 12.0pt; font-family: Verdana; color: black">

</span></b></td>

</tr>

<tr>

<td>

<input type="text" name="Address" size = "20">Addres </td>

</tr>

<tr>

<td>

</tr>

<tr>

<td>

</tr>

<tr>

<td>

<p align="left"><b><font size="5">Job Preference form</font></b></td>

</tr>

<tr>

<td>

select-------------------------------------------------------

</option>

<option value="Network engineering">Network engineering</option>

<option value="Software engineering">Software engineering</option>

<option value="Information">Information</option>

<option value="E-commerce">E-commerce</option>

<option value="Computer Secience">Computer Secience</option>

<option value="Computer System Engineering.">Computer System Engineering.</option>

<option value="Computer Security">Computer Security</option>

</select> Specialization

</td>

</tr>

<tr>

<td>

<option>Select------------------------------------------------------

</option>

</select>Target salary </td>

</tr>

<tr>

<td>

<option>Select-----------------------------------------------------

</option>

<option value="Permanent">Permanent</option>

<option value="Current">Current</option>

<option value="Internship">Internship</option>

</select>Job Type </span></td>

</tr>

<tr>

<td>

<p align="left"><span dir="LTR">Yes, any where</span><span style="font-size: 12.0pt; font-family: Times New Roman"><input type="radio" value="YES" name="WillingToRelocate">No

<input type="radio" value="No" name="WillingToRelocate" checked> Willing to Relocate

</span></td>

</tr>

</table>

</form>

<?php

mysql_connect($host,$user,$password) or die("Failed to connect");

mysql_select_db($db) or die("Falied to select database");

$sql = "SELECT * FROM $table ORDER BY id ASC;";

$result = mysql_query($sql);

if ($result){

while ($myrow = mysql_fetch_array($result)){

//echo "<tr><td>$myrow[id]<td>$myrow[Address]<td> $myrow[City]<td>$myrow[Fax]<td>$myrow[specialization]<td>$myrow[TargetSalary]<td>$myrow[JobType]<td>$myrow[WillingToRelocate]";

echo "<tr><td>$myrow[id]></td></tr>";

"<tr><td>$myrow[Address]</td></tr>";

"<tr><td>$myrow[City]</td></tr>";

"<tr><td>$myrow[Fax]</td></tr>";

"<tr><td>$myrow[specialization]</td></tr>";

"<tr><td>$myrow[TargetSalary]</td></tr>";

"<tr><td>$myrow[JobType]</td></tr>";

"<tr><td>$myrow[WillingToRelocate]</td></tr>";

}}

else

{

echo "mysql Error: " . mysql_error();

}

?>

</body>

</html>

MadTechie · May 28, 2007

move

<?php

     mysql_connect($host,$user,$password) or die("Failed to connect");
     mysql_select_db($db) or die("Falied to select database");

     $sql = "SELECT * FROM $table ORDER BY id ASC;";
     $result = mysql_query($sql);

     if ($result){

         while ($myrow = mysql_fetch_array($result)){
               //echo "<tr><td>$myrow[id]<td>$myrow[Address]<td> $myrow[City]<td>$myrow[Fax]<td>$myrow[specialization]<td>$myrow[TargetSalary]<td>$myrow[JobType]<td>$myrow[WillingToRelocate]";
                 echo "<tr><td>$myrow[id]></td></tr>";
                      "<tr><td>$myrow[Address]</td></tr>";
                      "<tr><td>$myrow[City]</td></tr>";
                      "<tr><td>$myrow[Fax]</td></tr>";
                      "<tr><td>$myrow[specialization]</td></tr>";
                      "<tr><td>$myrow[TargetSalary]</td></tr>";
                      "<tr><td>$myrow[JobType]</td></tr>";
                      "<tr><td>$myrow[WillingToRelocate]</td></tr>";


}}

     else
     {
         echo "mysql Error: " . mysql_error();
     }

?>

to the top..

Sign In

search page

Recommended Posts

uaeustudent

Link to comment

Share on other sites

gabeg

Link to comment

Share on other sites

MadTechie

Link to comment

Share on other sites

gabeg

Link to comment

Share on other sites

MadTechie

Link to comment

Share on other sites

uaeustudent

Link to comment

Share on other sites

MadTechie

Link to comment

Share on other sites

uaeustudent

Link to comment

Share on other sites

MadTechie

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information