DimitriDV Posted December 17, 2008 Share Posted December 17, 2008 This form does not insert its values in my database, does anyone know why? <form action="results.php" name="survey" method="post"> <table cellspacing="0" cellpadding="3" class="tbl_survey"> <tr> <td>Naam:</td> <td><input type="text" name="naam" id="naam" /></td> </tr> <tr> <td>Voornaam:</td> <td><input type="text" name="voornaam" id="voornaam" /></td> </tr> <tr> <td>Email:</td> <td><input type="text" name="email" id="email" /></td> </tr> <tr> <td colspan="2"><input type="submit" value="submit" id="toevoegen" name="toevoegen" /></td> </tr> </table> </form> <?php $naam_ = $_POST['naam']; $voornaam_ = $_POST['voornaam']; $email_ = $_POST['email']; if( $_POST['toevoegen'] ){ include('connect_db.php'); $query="INSERT INTO db_members(naam, voornaam, email) VALUES ($naam_,$voornaam_,$email_)"; $result = mysql_query($query, $DBC) or die("Cannot connect: " . mysql_error()); } ?> Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/ Share on other sites More sharing options...
keyurshah Posted December 17, 2008 Share Posted December 17, 2008 Change: $query="INSERT INTO db_members(naam, voornaam, email) VALUES ($naam_,$voornaam_,$email_)"; To: $query="INSERT INTO db_members(naam, voornaam, email) VALUES ('$naam_','$voornaam_','$email_')"; and then try... Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717521 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 nope, does not work ??? record with name, first name and email is NOT added Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717527 Share on other sites More sharing options...
[email protected] Posted December 17, 2008 Share Posted December 17, 2008 Add to the end of the script... print_r($_POST); And tell us what's the output. Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717529 Share on other sites More sharing options...
keyurshah Posted December 17, 2008 Share Posted December 17, 2008 <?php include('connect_db.php'); if( $_POST['toevoegen'] ){ $naam_ = $_POST['naam']; $voornaam_ = $_POST['voornaam']; $email_ = $_POST['email']; $query="INSERT INTO db_members(naam, voornaam, email) VALUES ('$naam_','$voornaam_','$email_')"; $result = mysql_query($query, $DBC) or die("Cannot connect: " . mysql_error()); } ?> <form action="results.php" name="survey" method="post"> <table cellspacing="0" cellpadding="3" class="tbl_survey"> <tr> <td>Naam:</td> <td><input type="text" name="naam" id="naam" /></td> </tr> <tr> <td>Voornaam:</td> <td><input type="text" name="voornaam" id="voornaam" /></td> </tr> <tr> <td>Email:</td> <td><input type="text" name="email" id="email" /></td> </tr> <tr> <td colspan="2"><input type="submit" value="submit" id="toevoegen" name="toevoegen" /></td> </tr> </table> </form> Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717530 Share on other sites More sharing options...
redarrow Posted December 17, 2008 Share Posted December 17, 2008 Add more validation please looks terrible. <?php if(isset($_POST['toevoegen'] )){ } ?> <?php $naam_ =mysql_real_escape_string($_POST['naam']); $voornaam_ =mysql_real_escape_string($_POST['voornaam']); $email_ = mysql-real_escape_string($_POST['email']); ?> Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717533 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 Add to the end of the script... print_r($_POST); And tell us what's the output. Array ( [naam] => name [voornaam] => firstname => email [toevoegen] => toevoegen ) like I entered in the input fields.... Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717534 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 <?php include('connect_db.php'); if( $_POST['toevoegen'] ){ $naam_ = $_POST['naam']; $voornaam_ = $_POST['voornaam']; $email_ = $_POST['email']; $query="INSERT INTO db_members(naam, voornaam, email) VALUES ('$naam_','$voornaam_','$email_')"; $result = mysql_query($query, $DBC) or die("Cannot connect: " . mysql_error()); } ?> <form action="results.php" name="survey" method="post"> <table cellspacing="0" cellpadding="3" class="tbl_survey"> <tr> <td>Naam:</td> <td><input type="text" name="naam" id="naam" /></td> </tr> <tr> <td>Voornaam:</td> <td><input type="text" name="voornaam" id="voornaam" /></td> </tr> <tr> <td>Email:</td> <td><input type="text" name="email" id="email" /></td> </tr> <tr> <td colspan="2"><input type="submit" value="submit" id="toevoegen" name="toevoegen" /></td> </tr> </table> </form> code upside down, like you suggested, does not add the values entered in the input fields to my database Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717536 Share on other sites More sharing options...
redarrow Posted December 17, 2008 Share Posted December 17, 2008 you was posting incorrect varables.. corrected <?php $naam = $_POST['naam']; $voornaam = $_POST['voornaam']; $email = $_POST['email']; ?> Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717537 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 what do you mean ??? Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717539 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 wtf? I can't use _ in variables? this works if I change $email_ to $email Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717540 Share on other sites More sharing options...
redarrow Posted December 17, 2008 Share Posted December 17, 2008 copy and past what the browser see's please.. DONT USE UNDERSCORE AT THE END OF THE VARIABLES OK M8. <?php include('connect_db.php'); if(isset($_POST['toevoegen'])){ $naam =mysql_real_escape_string($_POST['naam']); $voornaam = mysql_real_escape_string($_POST['voornaam']); $email = mysql_real_escape_string($_POST['email']); $query="INSERT INTO db_members(naam, voornaam, email) VALUES ('$naam','$voornaam','$email')"; $result = mysql_query($query, $DBC) or die("Cannot connect: " . mysql_error()); echo $query; } ?> <form action="results.php" name="survey" method="post"> <table cellspacing="0" cellpadding="3" class="tbl_survey"> <tr> <td>Naam:</td> <td><input type="text" name="naam" id="naam" /></td> </tr> <tr> <td>Voornaam:</td> <td><input type="text" name="voornaam" id="voornaam" /></td> </tr> <tr> <td>Email:</td> <td><input type="text" name="email" id="email" /></td> </tr> <tr> <td colspan="2"><input type="submit" value="submit" id="toevoegen" name="toevoegen" /></td> </tr> </table> </form> Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717541 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 this is my ADD button, what is the SQL code for deleting a record? $query="DELETE FROM db_members WHERE naam = '$naam' and voornaam = '$voornaam' and email = '$email'"; because this does not work also :-\ Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717543 Share on other sites More sharing options...
redarrow Posted December 17, 2008 Share Posted December 17, 2008 $query="DELETE FROM db_members WHERE email = '$email'"; Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717545 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 sorry record was not deleted $query="DELETE FROM ClubLeden WHERE email = '$email'"; Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717547 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 okay, now nothing works anymore <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link href="http://www.tcbeukenhof.be/tcbeukenhof.css" type="text/css" rel="stylesheet" /> </head> <body> <div class="header"><h1>Admin sectie</h1></div> <?php include('database_clubleden.php'); if(isset($_POST['toevoegen'])){ $naam =mysql_real_escape_string($_POST['naam']); $voornaam = mysql_real_escape_string($_POST['voornaam']); $email = mysql_real_escape_string($_POST['email']); $query="INSERT INTO ClubLeden(naam, voornaam, email) VALUES ('$naam','$voornaam','$email')"; $result = mysql_query($query, $DBC) or die("Cannot connect: " . mysql_error()); }elseif(isset($_POST['verwijderen'])){ $query="DELETE FROM ClubLeden WHERE email = '$email'"; $result = mysql_query($query, $DBC) or die("Cannot connect: " . mysql_error()); } ?> <form action="results.php" name="survey" method="post"> <table cellspacing="0" cellpadding="3" class="tbl_survey"> <tr> <td>Naam:</td> <td><input type="text" name="naam" id="naam" /></td> </tr> <tr> <td>Voornaam:</td> <td><input type="text" name="voornaam" id="voornaam" /></td> </tr> <tr> <td>Email:</td> <td><input type="text" name="email" id="email" /></td> </tr> <tr> <td><input type="submit" value="toevoegen" id="toevoegen" name="toevoegen" /></td> <td><input type="submit" value="verwijderen" id="verwijderen" name="verwijderen" /></td> </tr> </table> </form> </body> </html> Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717553 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 please help Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717558 Share on other sites More sharing options...
redarrow Posted December 17, 2008 Share Posted December 17, 2008 <?php session_start(); include('connect_db.php'); $naam =mysql_real_escape_string($_POST['naam']); $voornaam = mysql_real_escape_string($_POST['voornaam']); $email = mysql_real_escape_string($_POST['email']); $query="SELECT * FROM db_members"; $result = mysql_query($query, $DBC) or die("Cannot connect: " . mysql_error()); while($data=mysql_fetch_assoc($result)){ $_SESSION['email_address']=$data['email']; echo "$naam <br> $voornaam <br> $email <br><br> <a href='".$_SERVER['PHP_SELF']."?cmd=del'>DELETE ENTRY</a> <br><br>"; } if($_GET['cmd']=="del"){ $query="DELETE FROM db_members WHERE email = '".$_SESSION['email_address']."'"; $res=mysql_query($query)or die(mysql_error()); if(mysql_affected_rows($res)){ echo " Entry deleted!"; }else{ echo "Entry not deleted!"; } } ?> Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717559 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 now I get an output like this: <a href='newsletters.php?cmd=del'>DELETE ENTRY</a> <br><br> <br> <br> <br><br> and this 300 times ;D Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717563 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 we have to go back one step guys! <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link href="http://www.tcbeukenhof.be/tcbeukenhof.css" type="text/css" rel="stylesheet" /> </head> <body> <div class="header"><h1>Admin sectie</h1></div> <?php include('database_clubleden.php'); if(isset($_POST['toevoegen'])){ $naam = mysql_real_escape_string($_POST['naam']); $voornaam = mysql_real_escape_string($_POST['voornaam']); $email = mysql_real_escape_string($_POST['email']); $query="INSERT INTO ClubLeden(naam, voornaam, email) VALUES ('$naam','$voornaam','$email')"; $result = mysql_query($query, $DBC) or die("Cannot connect: " . mysql_error()); } ?> <form action="results.php" name="survey" method="post"> <table cellspacing="0" cellpadding="3" class="tbl_survey"> <tr> <td>Naam:</td> <td><input type="text" name="naam" id="naam" /></td> </tr> <tr> <td>Voornaam:</td> <td><input type="text" name="voornaam" id="voornaam" /></td> </tr> <tr> <td>Email:</td> <td><input type="text" name="email" id="email" /></td> </tr> <tr> <td><input type="submit" value="toevoegen" id="toevoegen" name="toevoegen" /></td> <td><input type="submit" value="verwijderen" id="verwijderen" name="verwijderen" /></td> </tr> </table> </form> </body> </html> I cannot add a record anymore > Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717565 Share on other sites More sharing options...
redarrow Posted December 17, 2008 Share Posted December 17, 2008 this is to show all members from the database and delete the member you want to delete...... <?php session_start(); include('connect_db.php'); $naam =mysql_real_escape_string($_POST['naam']); $voornaam = mysql_real_escape_string($_POST['voornaam']); $email = mysql_real_escape_string($_POST['email']); $query="SELECT * FROM db_members"; $result = mysql_query($query, $DBC) or die("Cannot connect: " . mysql_error()); while($data=mysql_fetch_assoc($result)){ $_SESSION['email_address']=$data['email']; echo "$naam <br> $voornaam <br> $email <br><br> <a href='".$_SERVER['PHP_SELF']."?cmd=del&email=".md5($_SESSION['email_address'])."'>DELETE ENTRY</a> <br><br>"; } if($_GET['cmd']=="del"){ $query="DELETE FROM db_members WHERE email = '".md5($_GET['email'])."'"; $res=mysql_query($query)or die(mysql_error()); if(mysql_affected_rows($res)){ echo " Entry deleted!"; }else{ echo "Entry not deleted!"; } } ?> Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717567 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 dude, you"re screwing me up can you provide me the whole html php page, because now NOTHING works anymore this is what I have right now, please adapt because I cannot ADD a record, nor can I delete one... <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> </head> <body> <div class="header"><h1>Admin sectie</h1></div> <?php include('database_clubleden.php'); if($_POST['toevoegen']){ $naam2 = mysql_real_escape_string($_POST['naam']); $voornaam2 = mysql_real_escape_string($_POST['voornaam']); $email2 = mysql_real_escape_string($_POST['email']); $query="INSERT INTO ClubLeden(naam, voornaam, email) VALUES ('$naam2','$voornaam2','$email2')"; $result = mysql_query($query, $DBC) or die("Cannot connect: " . mysql_error()); } elseif($_POST['verwijderen']){ session_start(); include('database_clubleden.php'); $naam =mysql_real_escape_string($_POST['naam']); $voornaam = mysql_real_escape_string($_POST['voornaam']); $email = mysql_real_escape_string($_POST['email']); $query="SELECT * FROM ClubLeden"; $result = mysql_query($query, $DBC) or die("Cannot connect: " . mysql_error()); while($data=mysql_fetch_assoc($result)){ $_SESSION['email_address']=$data['email']; echo "$naam <br> $voornaam <br> $email <br><br> <a href='".$_SERVER['PHP_SELF']."?cmd=cmd&email=".md5($_SESSION['email_address'])."'>DELETE ENTRY</a> <br><br>"; } if($_GET['cmd']=="del"){ $query="DELETE FROM db_members WHERE email = '".md5($_GET['email'])."'"; $res=mysql_query($query)or die(mysql_error()); if(mysql_affected_rows($res)){ echo " Entry deleted!"; }else{ echo "Entry not deleted!"; } } } ?> <form action="results.php" name="survey" method="post"> <table cellspacing="0" cellpadding="3" class="tbl_survey"> <tr> <td>Naam:</td> <td><input type="text" name="naam" id="naam" /></td> </tr> <tr> <td>Voornaam:</td> <td><input type="text" name="voornaam" id="voornaam" /></td> </tr> <tr> <td>Email:</td> <td><input type="text" name="email" id="email" /></td> </tr> <tr> <td><input type="submit" value="toevoegen" id="toevoegen" name="toevoegen" /></td> <td><input type="submit" value="verwijderen" id="verwijderen" name="verwijderen" /></td> </tr> </table> </form> </body> </html> Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717572 Share on other sites More sharing options...
redarrow Posted December 17, 2008 Share Posted December 17, 2008 The code i provided was for a single page dude..... To delete users via there email address... What wrong with your insert you got the database set up correctly...... Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717578 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 okay, we have to go back to my first questions, because you f*cked me up with your code here we go again how can I add records to my database via a form it's input fields? <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> </head> <body> <div class="header"><h1>Admin sectie</h1></div> <?php include('database_clubleden.php'); if(isset($_POST['toevoegen'])){ $naam =mysql_real_escape_string($_POST['naam']); $voornaam = mysql_real_escape_string($_POST['voornaam']); $email = mysql_real_escape_string($_POST['email']); $query="INSERT INTO ClubLeden(naam, voornaam, email) VALUES ('$naam','$voornaam','$email')"; $result = mysql_query($query, $DBC) or die("Cannot connect: " . mysql_error()); } ?> <form action="results.php" name="survey" method="post"> <table cellspacing="0" cellpadding="3" class="tbl_survey"> <tr> <td>Naam:</td> <td><input type="text" name="naam" id="naam" /></td> </tr> <tr> <td>Voornaam:</td> <td><input type="text" name="voornaam" id="voornaam" /></td> </tr> <tr> <td>Email:</td> <td><input type="text" name="email" id="email" /></td> </tr> <tr> <td colspan="2"><input type="submit" value="submit" id="toevoegen" name="toevoegen" /></td> </tr> </table> </form> </body> </html> this does not work for the record: the sql command INSERT INTO ClubLeden(naam, voornaam, email) VALUES ('d','d','d') in my SQL client WORKS! Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717582 Share on other sites More sharing options...
DimitriDV Posted December 17, 2008 Author Share Posted December 17, 2008 nevermind, problem solved! form action="results.php" so I did all my php actions in THAT file, and now everything works Link to comment https://forums.phpfreaks.com/topic/137332-insert-form-values-into-database/#findComment-717599 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.