I am trying to insert username, password, and email into one database's table, and insert the same username but instead of password and email, set 1 (to notifications row). Here's my code:
<?php
**$con= new mysqli("localhost","root","","users");
$con2 = new mysqli("localhost","root","","notification");**
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$hpassword = hash( 'sha512', $_POST['password'] );
$eusername = mysqli_real_escape_string( $con, $_POST['username'] );
$eemail = mysqli_real_escape_string( $con, $_POST['email'] );
$fusername = str_replace(' ', '', $eusername);
$check = "SELECT * FROM users WHERE username='$fusername'";
$result = mysqli_query($con, $check);
$data = mysqli_fetch_array($result, MYSQLI_NUM);
if($data[0] > 1) {
echo "User Already in Exists<br/>";
}
else
{
**$con->query="INSERT INTO users (username, password, email) VALUES ('$fusername','$hpassword','$eemail')";
$con2->query="INSERT INTO notification (username, notifications) VALUES ('$fusername','1')";**
if (mysqli_query($con,$con->query))
{
if (mysqli_query($con,$con2->query))
{
}
else
{
}
sleep(2);
header("location:login.php");
}
else
{
echo "Error: Username already exists.<br/>";
}
}
mysqli_close($con);
?>
Right now, it only submits data into the users database. Not the notification database.
In your second mysqli_query call, you use the same connection $con as in your first. Instead use $con2.
if (mysqli_query($con,$con->query))
{
if (mysqli_query($con2,$con2->query)) // <--- used $con2 here
{
}