this is my code...
Code: Select all
<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("Marketing") or die(mysql_error());
// Create a MySQL table in the selected database
mysql_query("CREATE TABLE Marketingemployeetable(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
Employeeid varchar(15), Date date,Sector varchar(30),Place varchar(40),Contactpersonname varchar(30),contactaddress varchar(30),Mobileno varchar(12))")
or die(mysql_error());
echo "Table Created!";
?>
Code: Select all
<?php
$con = mysql_connect("localhost","root", "");
if (!$con)
{die('Could not connect to DB: ' . mysql_error() );}
mysql_select_db ("Marketing", $con);
$date = $_POST['month'].$_POST['dt'].$_POST['year'] ;
$myusername=$_POST['myusername'];
$sql="INSERT INTO Marketingemployeetable (Employeeid, Date,Sector,Place,Contactpersonname,Contactaddress,Mobileno)VALUES ('$myusername','$date','$_POST[project]','$_POST[place]','$_POST[Contactpersonname]','$_POST[Contactaddress]','$_POST[Mobileno]')";
if (!mysql_query($sql,$con))
{die ('Error: ' . mysql_error());}
echo "Record added";
mysql_close($con)?>scottayy wrote:Please use the syntax tags when posting code