Mysql Question posted in
The official MySQL documentation can be found here.

Mysql – I created a database for a login system but my friend had difficulty connecting to it

I’m a foundation student. My assignment is to create a database for a login system for an html form. I had no problem connecting to it, as well as putting data into the DB. But when I ask my friend to run the form and submit it, it shows this. unknown database alert

Is there some way for my friend to put her data into my DB? This is my code for the DB.

<?php
/* Database credentials. Assuming you are running MySQL server with default setting (user 'root' with no password) */
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_NAME', 'membership');
 
/* Attempt to connect to MySQL database */
$link = mysqli_connect("localhost", "root", "", "membership");
 
// Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}
?>

I would really appreciate it if someone could help me solve this problem.

I tried putting ‘CREATE DATABASE’ and ‘CREATE TABLE IF NOT EXISTS’ into my codes and the result is still the same.

Tags:

2

Answers


  1. 0

    The issue here is you and your friend have different machines each with a different localhost, the first error that you mentioned is related to the database connectivity issues, it can be resolved by properly configuring the right database credentials of her machine, if everything is right and she is still unable to connect to the database, ask her to create the database named membership manually by going to her localhost server (most probably MyPHPAdmin). You are using mysqli_connect() to connect to your database, it only makes a successful connection if in case the membership database already exists. To run DB queries (even if CREATE DATABASE), you need a successful DB connection upfront (this is why the automatic database creation is not possible and shows Could not connect error).

    If both of you need to connect to a single database and make changes from different machines, you’ll need a hosting provider to host your database. Ensure you configure the live database credentials in your mysqli_connect() function. Numerous hosting providers offer affordable services (e.g., Namecheap, A2hosting, SiteGround). If cost is a concern, some providers also offer free database hosting.

    An additional tip, you can also consider taking a backup of your local database and restoring it on the live database or the localhost of her machine. This way, you can populate the live/her database with the necessary data that you already have in your local database.

    Login or Signup to reply.
  2. 0

    You have to ensure that database "membership" exists on your friend’s computer. If you want her to connect to your machine then try replacing "localhost" to the Local IP Address of your computer (if you know enough about networks). Last, if you want to create a database using PHP then in your mysqli_connect don’t mention the database name.

    $link = mysqli_connect("localhost", "root", "");

    Then use this link to execute the CREATE DATABASE query.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search