I am trying to link my php form and my sql but having difficulties

Posted by user1912599 on Stack Overflow See other posts from Stack Overflow or by user1912599
Published on 2012-12-18T11:01:32Z Indexed on 2012/12/18 11:02 UTC
Read the original article Hit count: 1224

Filed under:
|

I am not sure what I am doing wrong as far as my php goes but I can't get my form to link with my sql. Here are the codes for my form and php code for my link to sql

<?php
echo displayform();


function displayForm() {

$r = '';
//build it
$r .='<form action="database.php" method="post">';

//table
$r .=displayNiceFormBegin();
$r .=displayRow('FirstName:', '<input type="text" name="fname" id="fname"/>');
$r .=displayRow('LastName:', '<input type="text" name="lname" id="lname"/>');                           
$r .=displayRow('Address:', '<input type="text" name="address" id ="address"/>');   
$r .=displayRow('Phone:', '<input type="text" name="phone" id ="phone"/>');
$r .=displayRow('Deparment:', '<input type="text" name="department"id="department"/>');

$r .=displayRow('', '<input type="submit" value="Submit Registration" />');


$r .=displayNiceFormEnd();















$r .='</form>';


return $r;

}

function displayRow($left, $right) {

$r .= '';

//build it
$r .='<tr>';
$r .= '<td>' . $left . '</td>';
$r .= '<td>' . $right . '</td>';
$r .='</tr>';

return $r;

}


function displayNiceFormBegin(){


$r .='';


//build it
$r .= '<table style="background-color: beige; border: 1px dashed #999"><tr><td>';

$r .='<table style="margin:10px">'; 


return $r;

}

function displayNiceFormENd() {

$r .='';

//build it
$r .='</table>';
$r .='</td></tr><table>';

return $r;

}


?>






<?php

$host="localhost"; // Host name 
$username="695788_ogems"; // Mysql username 
$password="opd69715"; // Mysql password 
$db_name="ottawaglandorfems_zzl_ogems"; // Database name 
$tbl_name=".*"; // Table name 

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");     
mysql_select_db("$db_name")or die("cannot select DB");

// Get values from form 
$fname=$_POST['fname'];
$lname=$_POST['lname'];
$address=$_POST['address'];
$phone=$_POST['phone'];
$department=$_POST['deparment'];

// Insert data into mysql 

$sql="INSERT INTO     $tbl_name(FirstName,LastName,Address,Phone,Department)VALUES('$fname', '$lname',         '$address','$phone','$deparment')";
$result=mysql_query($sql);

// if successfully insert data into database, displays message "Successful". 
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='ottawa-glandorfems.org/form3.php'>Back to main page</a>";
}

else {
echo "ERROR";
}
?> 

<?php 
// close connection 
mysql_close();
?>

I keep getting an error. Thank you!!!!

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql