Jump to content

insert form values into database

DimitriDV

By DimitriDV
in PHP Coding Help

 Share

Recommended Posts

DimitriDV Newbie

DimitriDV

Posted
Posted

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
Share on other sites
keyurshah Newbie

keyurshah

Posted
Posted 
<?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
Share on other sites
redarrow Advanced Member

redarrow

Posted
Posted

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
Share on other sites
DimitriDV Newbie

DimitriDV

Posted
  • Author
Posted 

<?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
Share on other sites
redarrow Advanced Member

redarrow

Posted
Posted

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
Share on other sites
DimitriDV Newbie

DimitriDV

Posted
  • Author
Posted

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
Share on other sites
redarrow Advanced Member

redarrow

Posted
Posted 
<?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
Share on other sites
DimitriDV Newbie

DimitriDV

Posted
  • Author
Posted

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
Share on other sites
redarrow Advanced Member

redarrow

Posted
Posted

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
Share on other sites
DimitriDV Newbie

DimitriDV

Posted
  • Author
Posted

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
Share on other sites
DimitriDV Newbie

DimitriDV

Posted
  • Author
Posted

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

×
 Share
Go to topic listing
×
×
  • 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.