Jump to content

INSERT INTO


Deftone

Recommended Posts

Hallo,

I'm new here and also in PHP world.
Few daysago I go from php4 en mysql4 to php5 and mysql5 but now I can not insert info into the database.
Can someone tell me where i did wrong?
[code]

<?php
include ('_mySQL.php');
if ($toevoegen == "ja");
if ($pwd == "$pass");
if($_POST['submit']){
//Toevoegen
//Connect
$database_server = mysql_connect("$host","$user","$pass");
mysql_select_db("$database", $database_server);
if ($plaats == "1"){
$plaats = "  1";
}
else {
}
if ($plaats == "2"){
$plaats = "  2";
}
else {
}
if ($plaats == "3"){
$plaats = "  3";
}
else {
}
if ($plaats == "4"){
$plaats = "  4";
}
else {
}
if ($plaats == "5"){
$plaats = "  5";
}
else {
}
if ($plaats == "6"){
$plaats = "  6";
}
else {
}
if ($plaats == "7"){
$plaats = "  7";
}
else {
}
if ($plaats == "8"){
$plaats = "  8";
}
else {
}
if ($plaats == "9"){
$plaats = "  9";
}
else {
}

//Data insert
mysql_query("INSERT INTO 'race' VALUES ('" . $_POST["plaats"] . "', '" . $_POST["coureur"] . "', '" . $_POST["team"] . "', '" . $_POST["tijd"] . "', '" . $_POST["finish"] . "', '" . $_POST["race"] . "', '" . $_POST["jaar"] . "')");
//Geef weer dat het is gelukt
echo "Gegevens toegevoegd!";
echo "
<html>
<head>
<title>Race-uitslag toevoegen</title>
</head>
<body>
<font face=\"Arial\" size=\"2\">
<form action=\"race.php\" enctype=multipart/form-data>
<input type=\"hidden\" name=\"toevoegen\" value=\"ja\">
Wachtwoord:<br>
<input type=\"password\" size=\"30\" name=\"pwd\"><br>
Circuit:<br>
<input type=\"text\" size=\"30\" name=\"race\" value=\"$race\"><br>
Jaar:<br>
<input type=\"text\" size=\"30\" name=\"jaar\" value=\"$jaar\"><br>
Plaats:<br>
<input type=\"text\" size=\"30\" name=\"plaats\"><br>
Coureur:<br>
<input type=\"text\" size=\"30\" name=\"coureur\"><br>
Team:<br>
<input type=\"text\" size=\"30\" name=\"team\"><br>
Tijd / reden uitval:<br>
<input type=\"text\" size=\"30\" name=\"tijd\"><br>
Gefinished: <b>ja / nee</b><br>
<input type=\"text\" size=\"30\" name=\"finish\" value=\"$finish\"><br>
<input type=\"submit\" value=\"Verzenden\">
<input type=\"reset\" value=\"Invoer wissen\">
</form>
</body>
</html>
";
}

else {
?>

[/code]

When I submit the news the info is not going to the database.
When I did that in php4 and mysql4 I got no problems
Link to comment
Share on other sites

what errors are you displaying in PHP.ini?  is mysql reporting an error?

u should always allow for error checking.  in a production environment, change your error checking to something ambiguous but in testing, just report the mysql_error upon failure like so:
[code]mysql_query("INSERT INTO 'race' VALUES ('" . $_POST["plaats"] . "', '" . $_POST["coureur"] . "', '" . $_POST["team"] . "', '" . $_POST["tijd"] . "', '" . $_POST["finish"] . "', '" . $_POST["race"] . "', '" . $_POST["jaar"] . "')") or die(mysql_error());[/code]

there were a number of changes in mysql from 4-5 for syntax so you may be getting an error and not knowing it.
Link to comment
Share on other sites

Hi,

Thanks for your reply. I just changed the webhost. They are using php5 and mysql5
I had to make some chnges on my site and the only thing that's not working is to put info into the database.
I can get the info from the db on my frontpage but not into the db.
I don't get eny error. When I fill my form the fields go blanc and there isno insert in to the db
Link to comment
Share on other sites

I did what you both say but I not getting any error mysql error.
The fields only goes blank and that's it.
[code]mysql_query("INSERT INTO race VALUES ('" . $_POST["plaats"] . "', '" . $_POST["coureur"] . "', '" . $_POST["team"] . "', '" . $_POST["tijd"] . "', '" . $_POST["finish"] . "', '" . $_POST["race"] . "', '" . $_POST["jaar"] . "')") or die(mysql_error());[/code]
When I look into the DB there is no new info  :'(
Link to comment
Share on other sites

Add the "or die(mysql_error());" statements to your mysql_connect() and mysql_select_db().  i would assume he's not even getting to the mysql_query because it should not let him even run a query where he's trying to input blank values if the $_POST superglobal is not being propgated with information.
Link to comment
Share on other sites

Again no mysql error's
Only fields that turns blanc by hpushing the submit button.
I have to tel you that I changed the script becouse of the problem.
First my script looked like that

[code]


<?php
include ('_mySQL.php');
if ($toevoegen == "ja"){
if ($pwd == "$pass") {
//Toevoegen
//Verbinding maken
$database_server = mysql_connect("$host","$user","$pass");
mysql_select_db("$database", $database_server);
if ($plaats == "1"){
$plaats = "  1";
}
else {
}
if ($plaats == "2"){
$plaats = "  2";
}
else {
}
if ($plaats == "3"){
$plaats = "  3";
}
else {
}
if ($plaats == "4"){
$plaats = "  4";
}
else {
}
if ($plaats == "5"){
$plaats = "  5";
}
else {
}
if ($plaats == "6"){
$plaats = "  6";
}
else {
}
if ($plaats == "7"){
$plaats = "  7";
}
else {
}
if ($plaats == "8"){
$plaats = "  8";
}
else {
}
if ($plaats == "9"){
$plaats = "  9";
}
else {
}

//Gegevens invoeren
mysql_query("INSERT INTO race (plaats, coureur, team, tijd, finish, race, jaar) VALUES ('$plaats', '$coureur', '$team', '$tijd', '$finish', '$race', '$jaar')");
//Geef weer dat het is gelukt
echo "Gegevens toegevoegd!";
echo "
<html>
<head>
<title>Race-uitslag toevoegen</title>
</head>
<body>
<font face=\"Arial\" size=\"2\">
<form action=\"race.php\" enctype=multipart/form-data>
<input type=\"hidden\" name=\"toevoegen\" value=\"ja\">
Wachtwoord:<br>
<input type=\"password\" size=\"30\" name=\"pwd\"><br>
Circuit:<br>
<input type=\"text\" size=\"30\" name=\"race\" value=\"$race\"><br>
Jaar:<br>
<input type=\"text\" size=\"30\" name=\"jaar\" value=\"$jaar\"><br>
Plaats:<br>
<input type=\"text\" size=\"30\" name=\"plaats\"><br>
Coureur:<br>
<input type=\"text\" size=\"30\" name=\"coureur\"><br>
Team:<br>
<input type=\"text\" size=\"30\" name=\"team\"><br>
Tijd / reden uitval:<br>
<input type=\"text\" size=\"30\" name=\"tijd\"><br>
Gefinished: <b>ja / nee</b><br>
<input type=\"text\" size=\"30\" name=\"finish\" value=\"$finish\"><br>
<input type=\"submit\" value=\"Verzenden\">
<input type=\"reset\" value=\"Invoer wissen\">
</form>
</body>
</html>
";
}
}
else {
?>

[/code]
Link to comment
Share on other sites

Here you go
[code]

<?php
include ('_mySQL.php');
if ($toevoegen == "ja");
if ($pwd == "$pass");
if($_POST['submit']){
//Toevoegen
//Connect
$database_server = mysql_connect("$host","$user","$pass") or die(mysql_error());
mysql_select_db("$database", $database_server) or die(mysql_error());
if ($plaats == "1"){
$plaats = "  1";
}
else {
}
if ($plaats == "2"){
$plaats = "  2";
}
else {
}
if ($plaats == "3"){
$plaats = "  3";
}
else {
}
if ($plaats == "4"){
$plaats = "  4";
}
else {
}
if ($plaats == "5"){
$plaats = "  5";
}
else {
}
if ($plaats == "6"){
$plaats = "  6";
}
else {
}
if ($plaats == "7"){
$plaats = "  7";
}
else {
}
if ($plaats == "8"){
$plaats = "  8";
}
else {
}
if ($plaats == "9"){
$plaats = "  9";
}
else {
}

//Data insert
mysql_query("INSERT INTO race VALUES ('" . $_POST["plaats"] . "', '" . $_POST["coureur"] . "', '" . $_POST["team"] . "', '" . $_POST["tijd"] . "', '" . $_POST["finish"] . "', '" . $_POST["race"] . "', '" . $_POST["jaar"] . "')");
echo( mysql_error() );
//Geef weer dat het is gelukt
echo "Gegevens toegevoegd!";
echo "
<html>
<head>
<title>Race-uitslag toevoegen</title>
</head>
<body>
<font face=\"Arial\" size=\"2\">
<form action=\"race.php\" enctype=multipart/form-data>
<input type=\"hidden\" name=\"toevoegen\" value=\"ja\">
Wachtwoord:<br>
<input type=\"password\" size=\"30\" name=\"pwd\"><br>
Circuit:<br>
<input type=\"text\" size=\"30\" name=\"race\" value=\"$race\"><br>
Jaar:<br>
<input type=\"text\" size=\"30\" name=\"jaar\" value=\"$jaar\"><br>
Plaats:<br>
<input type=\"text\" size=\"30\" name=\"plaats\"><br>
Coureur:<br>
<input type=\"text\" size=\"30\" name=\"coureur\"><br>
Team:<br>
<input type=\"text\" size=\"30\" name=\"team\"><br>
Tijd / reden uitval:<br>
<input type=\"text\" size=\"30\" name=\"tijd\"><br>
Gefinished: <b>ja / nee</b><br>
<input type=\"text\" size=\"30\" name=\"finish\" value=\"$finish\"><br>
<input type=\"post\" value=\"Verzenden\">
<input type=\"reset\" value=\"Invoer wissen\">
</form>
</body>
</html>
";
}

else {
?>

<html>
<head>
<title>Race-uitslag toevoegen</title>
</head>
<body>
<font face="Arial" size="2">
<form action="race.php">
<input type="hidden" name="toevoegen" value="ja">
Wachtwoord:<br>
<input type="password" size="30" name="pwd"><br>
Circuit:<br>
<input type="text" size="30" name="race"><br>
Jaar:<br>
<input type="text" size="30" name="jaar"><br>
Plaats:<br>
<input type="text" size="30" name="plaats"><br>
Coureur:<br>
<input type="text" size="30" name="coureur"><br>
Team:<br>
<input type="text" size="30" name="team"><br>
Tijd / reden uitval:<br>
<input type="text" size="30" name="tijd"><br>
Gefinished: <b>ja / nee</b><br>
<input type="text" size="30" name="finish"><br>
<input type="submit" value="Verzenden">
<input type="reset" value="Invoer wissen">
</form>
</body>
</html>
<?php
}
?>

[/code]
Link to comment
Share on other sites

Ok I did that but stil nothing get into the DB
The only thing i get above the page is

[code]Array ( [toevoegen] => ja [pwd] => ***** [race] => Duitsland [jaar] => 2006 [plaats] => 1 [coureur] => T.Test [team] => Renault [tijd] => 1:22:22:234 [finish] => ja )[/code]
Link to comment
Share on other sites




is this your form wheres post

<form action=\"race.php\" enctype=multipart/form-data>
<input type=\"hidden\" name=\"toevoegen\" value=\"ja\">
Wachtwoord:<br>
<input type=\"password\" size=\"30\" name=\"pwd\"><br>
Circuit:<br>
<input type=\"text\" size=\"30\" name=\"race\" value=\"$race\"><br>
Jaar:<br>
<input type=\"text\" size=\"30\" name=\"jaar\" value=\"$jaar\"><br>
Plaats:<br>
<input type=\"text\" size=\"30\" name=\"plaats\"><br>
Coureur:<br>
<input type=\"text\" size=\"30\" name=\"coureur\"><br>
Team:<br>
<input type=\"text\" size=\"30\" name=\"team\"><br>
Tijd / reden uitval:<br>
<input type=\"text\" size=\"30\" name=\"tijd\"><br>
Gefinished: <b>ja / nee</b><br>
<input type=\"text\" size=\"30\" name=\"finish\" value=\"$finish\"><br>
<input type=\"submit\" value=\"Verzenden\">
<input type=\"reset\" value=\"Invoer wissen\">
</form>
Link to comment
Share on other sites

Yes.
I use this two

[code]<html>
<head>
<title>Race-uitslag toevoegen</title>
</head>
<body>
<font face=\"Arial\" size=\"2\">
<form action=\"race.php\" enctype=multipart/form-data>
<input type=\"hidden\" name=\"toevoegen\" value=\"ja\">
Wachtwoord:<br>
<input type=\"password\" size=\"30\" name=\"pwd\"><br>
Circuit:<br>
<input type=\"text\" size=\"30\" name=\"race\" value=\"$race\"><br>
Jaar:<br>
<input type=\"text\" size=\"30\" name=\"jaar\" value=\"$jaar\"><br>
Plaats:<br>
<input type=\"text\" size=\"30\" name=\"plaats\"><br>
Coureur:<br>
<input type=\"text\" size=\"30\" name=\"coureur\"><br>
Team:<br>
<input type=\"text\" size=\"30\" name=\"team\"><br>
Tijd / reden uitval:<br>
<input type=\"text\" size=\"30\" name=\"tijd\"><br>
Gefinished: <b>ja / nee</b><br>
<input type=\"text\" size=\"30\" name=\"finish\" value=\"$finish\"><br>
<input type=\"submit\" value=\"Verzenden\">
<input type=\"reset\" value=\"Invoer wissen\">
</form>
</body>
</html>
";
}

else {
?>

<html>
<head>
<title>Race-uitslag toevoegen</title>
</head>
<body>
<font face="Arial" size="2">
<form action="race.php" method="post">
<input type="hidden" name="toevoegen" value="ja">
Wachtwoord:<br>
<input type="password" size="30" name="pwd"><br>
Circuit:<br>
<input type="text" size="30" name="race"><br>
Jaar:<br>
<input type="text" size="30" name="jaar"><br>
Plaats:<br>
<input type="text" size="30" name="plaats"><br>
Coureur:<br>
<input type="text" size="30" name="coureur"><br>
Team:<br>
<input type="text" size="30" name="team"><br>
Tijd / reden uitval:<br>
<input type="text" size="30" name="tijd"><br>
Gefinished: <b>ja / nee</b><br>
<input type="text" size="30" name="finish"><br>
<input type="submit" value="Verzenden">
<input type="reset" value="Invoer wissen">
</form>
</body>
</html>[/code]
Link to comment
Share on other sites

gotto use post ok on all forms. method=" "

<form action=\"race.php\" enctype=multipart/form-data method="post">

also name the submit button  on all forms name=" "
<input name="submit" type="submit" value="Verzenden">

then where the insert is put this ok.

the post submit comes from the form name submit get me!

if($_POST['submit']) {

}

good luck.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.