How to insert data via php to multiple mysql databases?

Question

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.

I meant to bold the (**) areas, but I guess bold doesn't work in code. — Trevor Zucker
– Trevor Zucker, Commented Jul 24, 2013 at 2:04

prograhammer · Accepted Answer · 2013-07-24 02:06:40Z

1

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
{
}

answered Jul 24, 2013 at 2:06

prograhammer

20.7k13 gold badges95 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert data via php to multiple mysql databases?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related