Php code to insert data in sql

Chrysanthus

hi i need help with php code to connect two my local db and then insert some values in the data base

Sql db: Flameline

Tabel info

table_name ( id INT(11) default NULL auto_increment, fornamn char(60) default NULL, efternamn char(60) default NULL, epost char(60) default NULL,PRIMARY KEY (id)

exampel

php code before entering this sql code..

insert into tabel_name values
('4', 'Bosse', 'Karlsson', 'Bosse.Karlsson@test1');

some ides

Christian_B_

insert into tabel_name (fornamn,efternamn,epost) values
('Bosse', 'Karlsson', 'Bosse.Karlsson@test1');

Since id is auto-increment, you don't have to insert it
explicitly:

Christian

Chrysanthus

And haw do a php skript look that inserts a value into the sql from a form.

Exampel

Please enter Your Firstname:___ Last Name: _
Please enter Your E-mail: _____

insert into tabel_name (fornamn,efternamn,epost) values
('Firstname, 'lastname', 'e@mail');

😕

zurron

<html>
<body>
<?php
if ($submit && strlen(trim($firstname)) > 0 && strlen(trim($lastname)) && strlen(trim($email)) > 0 ) {
  // process form
 $con=mysql_connect("localhost","username","password") or die ("not connected");
  mysql_select_db("Flameline",$con); 
  $query="INSERT INTO table_name(fornamn,efternamn,epost) values ('$firstname', '$lastname', '$email')";
$result = mysql_query($query);
}
else{ 

  // display form 
  ?> 
  <form method="post" action="<?php echo $PHP_SELF?>"> 
  First name    :<input type="Text" name="firstname"><br> 
  Last name :<input type="Text" name="lastname"><br> 
  e-mail  :<input type="Text" name="email"><br><br><br><br> 
  <input type="Submit" name="submit" value="Enter"> 
  </form> 
  <?php 

} // end if
?>
</body>
</html>

Chrysanthus

<html>
<body>
<?php
if ($submit && strlen(trim($firstname)) > 0 && strlen(trim($lastname)) && strlen(trim($email)) > 0 ) {
// process form
$con=mysql_connect("localhost","LHA","") or die ("not connected");
mysql_select_db("Flameline",$con);
$query="INSERT INTO table_name(fornamn,efternamn,epost) values ('$firstname', '$lastname', '$email')";
$result = mysql_query($query);
}
else{

// display form
?>
<form method="post" action="<?php echo $PHP_SELF?>">
<B>First name :</B><FONT COLOR='white'></FONT><input type="Text" name="firstname"><br>
<B>Last name :</B><FONT COLOR='white'></FONT><input type="Text" name="lastname">
<br><BR>
<B>e-mail :</B><FONT COLOR='white'>_______</FONT><input type="Text" name="email"><br>
<br>
<input type="Submit" name="submit" value="Enter">
</form>
<?php

} // end if
?>
</body>
</html>

zurron

it would be nice if you say the error

Chrysanthus

Notice: Undefined variable: submit in C:\Inetpub\wwwrootphp\test.php on line 4

zurron

ok, you are working in windows and i am not sure if this will work, i hope it will

<html>
<body>
<?php
$submit=$_POST['submit'];
$firstname=$_POST['firstname'];
$lastname=$_POST['lastname']; 
$email= $_POST['email']; 
if ($submit){           

        // process form 
        $con=mysql_connect("localhost","LHA","") or die ("not connected");   

      mysql_select_db("Flameline",$con);   

        $query="INSERT INTO table_name(fornamn,efternamn,epost) values ('$firstname', '$lastname', '$email')"; 
      $result = mysql_query($query);   

        echo "First name: $firstname Last name:$lastname e-mail:$email";

 }

else{ 

// display form 
?> 
<form method="post" action="<?php echo $PHP_SELF?>"> 
<B>First name :</B><FONT COLOR='white'>___</FONT><input type="Text" name="firstname"><br> 
<B>Last name :</B><FONT COLOR='white'>___</FONT><input type="Text" name="lastname"> 
<br><BR> 
<B>e-mail :</B><FONT COLOR='white'>_______</FONT><input type="Text" name="email"><br> 
<br>  

<input type="Submit" name="submit" value="Enter">
</form>
<?php

} // end if 
?>  

</body> 
</html>

Chrysanthus

yeah iam but only beacuse im not so high on unix(linx any more it was like 2-3 years ago sins i last did a processe a commad line in unix...

i test the php code se if it works ¤¤ Thanks ¤¤

Chrysanthus

Notice: Undefined index: submit in c:\inetpub\wwwroot\test.php on line 4

Notice: Undefined index: firstname in c:\inetpub\wwwroot\test.php on line 5

Notice: Undefined index: lastname in c:\inetpub\wwwroot\test.php on line 6

Notice: Undefined index: email in c:\inetpub\wwwroot\test.php on line 7

First name :
Last name :

e-mail :_______

zurron

well, as you can see I don't know how php works in windows..
and maybe I will not be able to help you... but maybe someone else can..

I have only 2 questions and 2 last advises.

what http server are you running in your machine?
have you test other php scripts in you machine?

and my last thing that I can say to you

<html>
<body>
<?php
if ($_POST['submit']){           

        // process form 
        $con=mysql_connect("localhost","LHA","") or die ("not connected");   

      mysql_select_db("Flameline",$con);   

        $query="INSERT INTO table_name(fornamn,efternamn,epost) values ('$_POST['firstname']', '$_POST['lastname']', '$_POST['email']')"; 
      $result = mysql_query($query);   

        echo "First name: $firstname Last name:$lastname e-mail:$email";

 }

else{ 

// display form 
?> 
<form method="post" action="<?php echo $PHP_SELF?>"> 
<B>First name :</B><FONT COLOR='white'>___</FONT><input type="Text" name="firstname"><br> 
<B>Last name :</B><FONT COLOR='white'>___</FONT><input type="Text" name="lastname"> 
<br><BR> 
<B>e-mail :</B><FONT COLOR='white'>_______</FONT><input type="Text" name="email"><br> 
<br>  

<input type="Submit" name="submit" value="Enter">
</form>
<?php

} // end if 
?>  

</body> 
</html>

Ask someone who has worked with php in windows before..for sure they will help you.... sorry I just know a little bit on linux

Chrysanthus

I did run IIS but dident work so fine so i change into Apache/1.3.27 and now it works with miner problems...

when i submit the form i get this response

Forbidden
You don't have permission to access /< on this server.

--------------------------------------------------------------------------------

Apache/1.3.27 Server at quizqpdc1.Quizq.net Port 80

I Have typet in the right User and Password but it dosent work any ides.

<html>
<B>
<BODY BGCOLOR="#50538D" TOPMARGIN=0 LEFTMARGIN=0 link=black>
<FONT COLOR='black'>Welcome to members registration</FONT></B>
<body>
<?php
$submit=$POST['submit'];
$firstname=$POST['firstname'];
$lastname=$POST['lastname'];
$email= $POST['email'];
if ($submit){

// process form
$con=mysql_connect("localhost","LHA","razor") or die ("not connected");

mysql_select_db("Flameline",$con);

$query="INSERT INTO table_name(fornamn,efternamn,epost) values ('$firstname', '$lastname', '$email')";
$result = mysql_query($query);

echo "First name: $firstname Last name:$lastname e-mail:$email";

}

else{

// display form
?>
<form method="post" action="<?php echo $PHP_SELF?>">
<B>First name :</B><FONT COLOR='#50538D'></FONT><input type="Text" name="firstname"><br>
<B>Last name :</B><FONT COLOR='#50538D'>¨.</FONT><input type="Text" name="lastname">
<br><BR>
<B>E-mail :</B><FONT COLOR='#50538D'>_____.</FONT><input type="Text" name="email">

<FONT COLOR='#50538D'>___</FONT><input type="Submit" name="submit" value="Submit Registration">
</form>
<?php

} // end if
?>

</body>
</html>