cant connect php to database

sigridish · 01-31-2013, 03:08 AM

Hi all! I would like to ask for help. i have a code that i got from youtube. my problem is i cant connect to my database and i dont know why. i dont think that i have a problem in my code. i have 2 php file. reg.php for the connection and demo-form.php for adding the record.

demo-form.php

PHP Code:


			
<form action="reg.php" method="post" />

<p>First Name: <input type="text" name="fname" /> </p>

<p>Middle Name: <input type="text" name="mname" /> </p>

<p>Last Name: <input type="text" name="lname" /> </p>

<p>Home address: <input type="text" name="homeadd" /> </p>

<p>Email address: <input type="text" name="emailadd" /> </p>

<p>Office/project number: <input type="text" name="ofcnum" /> </p>

<p>Mobile number: <input type="text" name="mobilenum" /> </p>

<p>Home number: <input type="text" name="homenum" /> </p>

<p>Position: 

<select name="position">

  <option value ="">Select</option>

  <option value ="Project Manager">Project Manager</option>

  <option value ="Practice Lead">Project Manager</option>

  <option value ="Team Leader">Team Leader</option>

  <option value ="Team Member">Team Member</option>

</select>

<p>Practice: 

<select name="position">

  <option value ="">Select</option>

  <option value ="Solutions">Solutions</option>

  <option value ="Outsourcing">Outsourcing</option>

 </select>

<p>Project Name: <input type="text" name="projname" /> </p>

<p>Project Manager: <input type="text" name="projmgr" /> </p>

<p>Team Leader: <input type="text" name="teamlead" /> </p>



<input type="submit" value="Submit" />

<body bgcolor="cccccc">

</form>

reg.php

PHP Code:


			
<?php[/b]





[b]define ('DB_NAME', 'emp');

define ('DB_USER', 'root');

define ('DB_PASSWORD', '');

define ('DB_HOST', 'localhost');[/b]





[b]$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);[/b]





[b]if (!$link) {

die('Could not connect: ' . mysql_error());

}[/b]





[b]$db_selected = mysql_select_db(DB_NAME, $link);[/b]





[b]if (!$db_selected) {

die('Can\'t use ' . DB_NAME . ': ' . mysql_error());

}[/b]





[b]$value1 = $_POST["fname"];

$value2 = $_POST["mname"];

$value3 = $_POST["lname"];

$value4 = $_POST["homeadd"];

$value5 = $_POST["emailadd"];

$value6 = $_POST["ofcnum"];

$value7 = $_POST["mobilenum"];

$value8 = $_POST["homenum"];

$value9 = $_POST["position"];

$value10 = $_POST["practice"];

$value11 = $_POST["projname"];

$value12 = $_POST["projmgr"];

$value13 = $_POST["teamlead"];[/b]





[b]$sql = "INSERT INTO employee (fname, mname, lname, homeadd, emailadd, ofcnum, mobilenum, homenum, position, projname, projmgr, teamlead) 

  VALUES ('$value1', '$value2', '$value3', '$value4', '$value5', '$value6', '$value7', '$value8', '$value9', '$value10', '$value11', '$value12')";

 

if (!mysql_query($sql)) {

die('Error: ' . mysql_error());

}[/b]





[b]mysql_close();[/b]





[b]?>

abduraooft · 01-31-2013, 07:43 AM

Have your got any errors?

needsomehelp · 01-31-2013, 07:56 AM

Here's my 2pence worth...

try changing the inset line to this...

Code:

$sql = "INSERT INTO `employee` (`fname`, `mname`, `lname`, `homeadd`, `emailadd`, `ofcnum`, `mobilenum`, `homenum`, `position`, `projname`, `projmgr`, `teamlead`) 
  VALUES ('$value1', '$value2', '$value3', '$value4', '$value5', '$value6', '$value7', '$value8', '$value9', '$value10', '$value11', '$value12')";