Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/pest/pu

newtophpndesign

Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/pest/public_html/insert-data.php on line 10
error inserting new record

I am trying to insert data to a db I have created and this is the error I get when I try to submit data. Please help 😕

bradgrafelman

What are you passing as parameter 1, and why is it NULL?

newtophpndesign

i am very sorry i do not understand i am very new and i have made this script:

<?php

if (isset($_POST['submitted']))  {

include('mysql_connect.php');
$email = $_Post['email'];
$sqlinsert = "INSERT INTO Pest (email)  	VALUES ('$email')";

if (!mysqli_query($mysql_connect, $sqlinsert)) {
	die('error inserting new record');

}// end of my nested statment

$newrecord = "1 record added to the database";



} //end of the main if statement



?>
<html>
<head>
<title>Post Your Problem</title>
</head>
<body>

<hi>Post it!</h1>

<form method="post" action="insert-data.php">
<input type="hidden" name="submitted" value="true" />
<fieldset>
	<legend>Track</legend>
    <label>Email: <input type="text" nanme="email" /></label>
    <label>Date of Discovery: <input type="text" name="Date_you_discovered_pests"/></label>
    <label>Post Your Problem: <input type="text" name="Post_your_pest_problem"/></label>
    <label>Address Input: <input type="text" name="Address"/></label>
</fieldset>
<br />
<input type="submit" value="Post Your Problem" />

</form>
<?php
echo $newrecord

?>

</body>
</html>

bradgrafelman

When posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and ananlyze.

Okay, so you call [man]mysqli_query/man here:

mysqli_query($mysql_connect, $sqlinsert)

so where is $mysql_connect ever defined? See the manual page for [man]mysqli_query/man to learn what this parameter is expected to be.