Problem PHP form

santille

Hi,
Just a question of neophyte : could you tell me what's wrong with these codes?
I'm able to delete but not to update nor to add.
Thanks?

formulaire.php :

<?
if ($_GET["action"] == "update") {
$hote = "localhost";
$username = "root";
$password = "";

$connexion = mysql_connect($hote,$username,$password);

//echo $connexion;

$nomdelabase = "labase";

mysql_select_db($nomdelabase,$connexion);

$requete = "SELECT * FROM latable WHERE numero = $_GET[num]";

$resultat = mysql_query($requete,$connexion);
$test = mysql_fetch_row($resultat);
list($numero,$nom,$informations,$categorie) = $test;
}
?>

<form name="leformulaire" action="execute.php

<?

/*if ($_GET[action] == "update") 
{echo "?action=update&num=$_GET[num]"; }
elseif ($_GET[action] == "insert")
{echo "?action=insert";}*/

switch($_GET["action"]) {
	case "update":
	echo "?action=update&num=$_GET[num]";
	break;
	case "insert":
	echo "?action=insert";
	break;	
}
?>

" method="post">au repos
Nom :<br>
<input name="nom" type=text length=30 value=

<?if ($_GET[action] == "update") {echo "'$nom'";}?>

><br>
Informations :<br>
<textarea name="informations" cols=35 rows=6 value=

<?if ($_GET[action] == "update") {echo $informations;}?>

></textarea><br>
Catégorie :<br>
<input type=radio name="categorie" value="news"

<?if ($categorie == "news") {echo "CHECKED";}?>

>
News<br>
<input type=radio name="categorie" value="infos"

<?if ($categorie == "infos") {echo "CHECKED";}?>

>
Infos<br>
<input type=radio name="categorie" value="photos"

<?if ($categorie == "photos") {echo "CHECKED";}?>

>
Photos<br>
<input type=submit value="Vazy Envoie !">
</form>
</body>
</html>

execute.php:

<?
echo $_POST["nom"]."<br>";
echo nl2br(stripslashes($_POST["informations"]))."<br>";
echo $_POST["categorie"];

$hote = "localhost";
$username = "root";
$password = "";

$connexion = mysql_connect($hote,$username,$password);

//echo $connexion;

$nomdelabase = "labase";

mysql_select_db($nomdelabase,$connexion);

if($_GET["action"] == "suppr") {

   $requetespace = "DELETE FROM latable WHERE numero = $_GET[num]";
   mysql_query($requetespace,$connexion);
   } elseif ($_GET[action] == "update") {
	$requetespace = "UPDATE latable SET numero='$_Get[num], nom='$_POST[nom], informations='$_POST[informations], categorie='$_POST[categorie] WHERE numero='$_GET[num]'";
	mysql_query($requetespace,$connexion);}
	elseif ($_GET[action] == "insert") {
	$requetespace = "INSERT latable SET numero='', nom='$_POST[nom], informations='$_POST[informations], categorie='$_POST[categorie]";
	mysql_query($requetespace,$connexion);
	}

$requete = "SELECT * FROM latable";


echo $requete;

$resultat = mysql_query($requete,$connexion);
echo $resultat;
?>

<?
while ($test = mysql_fetch_row($resultat)) {

//print_r($test);


list($numero,$nom,$informations,$categorie) = $test;
echo '<tr><td>';
echo $nom;
echo '</td><td>';
echo "<a href = 'execute.php?num=$numero&action=suppr'><img src = 'images/supprimer.gif'></a>";
echo '</td><td>';
echo "<a href = 'formulaire.php?num=$numero&action=update'><img src = 'images/modifier.gif'></a>";
echo '</td></tr>';
}
?>

igorlopez

I don't know what's wrong with these codes but I know that your post will not draw much attention.

The start is OK where you state

I'm able to delete but not to update nor to add.

but the rest is just unstructured information.

I did put some time into it just to see if I could find anything but since I have no clue to how your layout is with respect to your forms methods and actions and so forth I can't say that what I found is wrong but definitely strange.

This area (which could be what you are having a problem with)

if($_GET["action"] == "suppr") {   

   $requetespace = "DELETE FROM latable WHERE numero = $_GET[num]";
   mysql_query($requetespace,$connexion);
} elseif ($_GET[action] == "update") {
    $requetespace = "UPDATE latable SET numero='$_Get[num], nom='$_POST[nom], informations='$_POST[informations], categorie='$_POST[categorie] WHERE numero='$_GET[num]'";
    mysql_query($requetespace,$connexion);}
elseif ($_GET[action] == "insert") {
    $requetespace = "INSERT latable SET numero='', nom='$_POST[nom], informations='$_POST[informations], categorie='$_POST[categorie]";
    mysql_query($requetespace,$connexion);
}

If you echo out the $requetespace variable for the different cases the DELETE case looks OK but not the UPDATE nor the INSERT.
Check out your usage of ' inside the "......" strings, it does not look right. Also you can't use $Get[num] and hope that you will get $GET[num]

One recommendation I can give you is try to be as short and precise as possible.
You should also include the types of error you are getting and how far you have come in your own trouble shooting.