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
https://forums.phpfreaks.com/topic/15616-insert-into/
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
https://forums.phpfreaks.com/topic/15616-insert-into/#findComment-63563
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
https://forums.phpfreaks.com/topic/15616-insert-into/#findComment-63564
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
https://forums.phpfreaks.com/topic/15616-insert-into/#findComment-63572
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
https://forums.phpfreaks.com/topic/15616-insert-into/#findComment-63584
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
https://forums.phpfreaks.com/topic/15616-insert-into/#findComment-63589
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
https://forums.phpfreaks.com/topic/15616-insert-into/#findComment-63619
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
https://forums.phpfreaks.com/topic/15616-insert-into/#findComment-63851
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
https://forums.phpfreaks.com/topic/15616-insert-into/#findComment-63874
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
https://forums.phpfreaks.com/topic/15616-insert-into/#findComment-63878
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.