Why can't i connect to my sql database?
Please i have tried severally to connect to a my sql database on cpanel
I used this codes
The form code is
<form action= "insert.php" method="post">
First name: <input type="text" name="fname" id="fname"/><br><br>
Last name: <input type="text" name="lname"id="lname" /><br><br>
Gender:<input type="text" name="Gender" id="Gender"/><br><br>
<p><label>Select State:</label><select name="State"
id="State">
<option value="-"selected="selected">-</option>
<option value="Abia">Abia</option>
<option value="Adamawa">Adamawa</option>
<option value="Akwaibom">Akwaibom</option>
<option value="Anambra">Anambra</option>
</select></label></p>
Lga: <input type="text" name="Lga" id="Lga"/><br><br>
<input type="submit" name="s1"id="s1"value="Submit" />
</form>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</form>
The php script in cgi folder is insert.php
<?php
$host="localhost",
$user_name="admin",
$pwd="^^^^^^",
$database_name="Data",
$db = mysql_connect("$localhost,$lamsanng_admin ,$^^^^^^);
if (!$db)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db($lamsanng_Data ", $db);
$Id=$_POST["Id"];,
$fname = $_POST["fname"];,
$fname= $_POST["fname"];
$Gender= $_POST["Gender"];
$Lga= $_POST["Lga"];
$State= $_POST["State"];
$submitdate=date("Ymd");
$query="INSERT INTO 'tbl_Jobs'";
( 'Id', 'Firstname', 'Lastname','Gender','State','Lga','submit_date')VALUES { ( '$First_name',$'Last_name,'$Gender','$State,'$Lga,'$submit_date');
$result=mysql_query($query);
if (!mysql_query($sql,$db))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($db)
?>
The code to retrieve the stored data to my webpage is
<?php
// create short variable names
$searchtype=$_POST['searchtype'];
$searchterm=trim($_POST['searchterm']);
if (!$searchtype || !$searchterm) {
echo 'You have not entered search details. Please go back and try again.';
exit;
}
if (!get_magic_quotes_gpc()){
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
}
@ $db = new mysqli('localhost', 'lamsanng_admin', '^^^^^^', 'lamsanng_Data');
if (mysqli_connect_errno()) {
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$query = "select * from 'tbl_Jobs' where ".$searchtype." like '%".$searchterm."%'";
$result = $db->query($query);
$num_results = $result->num_rows;
echo "<p>records found: ".$num_results."</p>";
for ($i=0; $i <$num_results; $i++) {
$row = $result->fetch_assoc();
echo "<p><strong>".($i+1).". Fname: ";
echo htmlspecialchars(stripslashes($row['Fname']));
echo "</strong><br />Lname: ";
echo stripslashes($row['Id']);
echo "</p>";
}
$result->free();
$db->close();
?>
Please what is wrong with the scripts.
Thank you.^^^^^^^
is hidden password