GET and POST

Language: PHP
echo "<a href=edit.php?book_id=$book_id&update=yes>Edit</a>";

Language: PHP
$book_id=$_GET[';book_id';];

Language: HTML
http://osprey.unisa.ac.za/phorum/read.php?564,155263

Language: PHP
$car_id = $_GET[';car_id';];
echo "car_id = $car_id";
 
$sql = "SELECT car_name, model, year, price FROM cars WHERE car_id = ';$car_id';";
$result = mysql_query($sql)
$num_rows=mysql_num_rows($sql);
 
echo "$num_rows"; //shows how many rows were found
 
// while loop
{
//form
}

Language: PHP
<td>Manufacturer</td><td><input name="manufacturer" type="text" value="<?php echo ';$manufacturer';;?>"> </input></td

Language: PHP
<?php
$car_id= $_GET[';car_id';];
$manufacturer = $_GET[';manufacturer';];
$make = $_GET[';make';];
$year = $_GET[';year';];
$price = $_GET[';price';];
$sql = "SELECT manufacturer, make, year, price FROM cars WHERE car_id = ';$car_id';";
$result = mysql_query($sql)
 
?>
// then i have my form
<form Method="POST" ACTION="edit.php">
<table border="2" align="center">
<tr>
<td>Manufacturer</td><td><input name="manufacturer" type="text" value="<?php echo ';$manufacturer';;?>"> </input></td>
</tr>

Language: PHP
$manufacturer = "BMW"; 
value="<?php echo ';$manufacturer';;?>"> //will print $manufacturer
value="<?php echo "$manufacturer";?>"> //will print BMW. String are in double quotes

Language: PHP
$value=';21';; //or $value="21"; or $value=21; // numeric value
value="<?php echo "$value";?>"> //will print the 21
value="<?php echo ';$value';; ?>"> //will print $value

Language: PHP
$car_id= $_GET[';car_id';]; //this is OK
$manufacturer = $_GET[';manufacturer';]; //you did not pass this so why put it here?
$make = $_GET[';make';]; //you did not pass this so why put it here?
$year = $_GET[';year';]; //you did not pass this so why put it here?
$price = $_GET[';price';]; //you did not pass this so why put it here?
 
$sql = "SELECT manufacturer, make, year, price FROM cars WHERE car_id = ';$car_id';"; //you only passed the car_id, and use that to get the rest of the information from the db.
$result = mysql_query($sql)
//here you get the values of manufacturer, make, etc.

Language: PHP
$car_id= $_GET[';car_id';];
 
$query = "SELECT manufacturer, make, year, price FROM cars WHERE car_id = ';$car_id';";
$result = mysql_query($query);
 
	while($row = mysql_fetch_array(result)){
		$manufacturer = $row[';manufacturer';];
		$make = $row[';make';];
                $year = $row[';year';];
                $price = $row[';price';];
	}
//I tried putting an echo statement here to test the variable, eg the $manufacturer but it prints nothing

Language: PHP
//Then I have my form
<input name="manufacturer" type="text" value="<?php echo "$manufacturer";?>"></input>

Language: PHP
$car_id= $_GET[';car_id';];
//does the URL show the id e.g. edit.php?car_id=12
// if so, echo "$car_id"; to see if it is caught. 
// is the connection to the db working?  The "or die..." part will tell you if there is a problem
 
mysql_connect("localhost", "admin", "1admin") or die(mysql_error()); 
mysql_select_db("test") or die(mysql_error()); 
 
$query = "SELECT manufacturer, make, year, price FROM cars WHERE car_id = ';$car_id';";
$result = mysql_query($query) or die mysql_error()); 
// another or die test
 
	while($row = mysql_fetch_array(result)){
		$manufacturer = $row[';manufacturer';];
		$make = $row[';make';];
                $year = $row[';year';];
                $price = $row[';price';];
//and so on

Language: PHP
$connection = mysql_connect ("localhost","root","")
		or die ("Couldn';t connect to server");
 
	$db = mysql_select_db("carsales", $connection)
		or die ("Couldn';t select database");

Language: PHP
while($row = mysql_fetch_array(result)){
		$manufacturer = $row[';manufacturer';];
		$make = $row[';make';];
                $year = $row[';year';];
                $price = $row[';price';];
//I tried putting and echo here for $manufacturer but it does not print anything.

Language: PHP
 $car_id = $_GET[';car_id';];
 
if(isset($_REQUEST["update"])){ 
 
 
 
  $sql = "UPDATE cars SET car_name=';$car_name';, model=';$model';, year=';$year';, price=';$price'; WHERE car_id=';$car_id';";
   $results = mysql_query($sql);
 }
 
// select query display fine	
 
 //while loop{
 
}
} 
?>
 <form method="GET" action="edit.php"><center> 
  Car name : <input type= "text" >
  Model    : <input type= "text" >
  Year     : <input type= "text" >
  Price    : <input type= "text">
 <input type="submit" name="update" value="Update"> </form>

Language: PHP
//is the form method set to POST or GET?
//assuming it is GET, include a hidden form element  to pass the id
//catch the id
$car_id = $_GET[';car_id';];
//do an for yourself echo to see it is caught 
echo "car id = $car_id";

Language: PHP
//get the id
 
//select frm the database using the id
 
//while loop
{
 
//get the fields using id
}
 
if (isset($_GET[';id';])== "Yes"){
 
//put the delete code
}

Language: PHP
the link is send e.g. ?id=$id&delete=yes
 
if delete ==yes {
do you want to delete? <a href=... ?delete=absolutely&id=$id>Yes <a href=...list.php>No</a>
}elseif delete==absolutely {
delete
}

Language: PHP
 

Language: PHP
 elseif($_submit[code="php"]
 
=$_GET[';update';]) // IF THE FORM WAS SUBMITTED WITH UPDATED INFORMATION, THEN UPDATE THE DB
{
  $SQL="UPDATE my_discs  SET category=';$category'; WHERE disc_id=';$disc_id';" ;
  $result=mysql_query($SQL)or die("query failed:" .mysql_error());
 
 
}

Language: PHP
if($_submit[code="php"] 
=$_GET[';update';])

Language: PHP
if(isset($_GET[';disc_id';])){
       $disc_id =$_GET[';disc_id';]; 
 
       if (delete=="yes") {
           $error="do you want to delete? <a href=';delete.php';>Yes </a><a href=';list.php';>No</a></p>";
       }elseif (delete=="absolutely") {
 
        $sql= "SELECT * FROM my_discs WHERE disc_id=';$disc_id';";
        $sql="DELETE FROM my_discs WHERE disc_id=';$disc_id';";//delete all from the table named my_discs
        $result = mysql_query($sql)or die("query failed:" .mysql_error());
 
 
       }

Language: PHP
if (delete=="yes") { //this is not valid find the mistake