No database selected error php mysql

Question

i have created a database in phpmyadmin. When I submit the form, the script is supposed to insert data in the database. However, i get the error "No database selected". Could you please look at my code and see if you can find where I went wrong. Thank you

    $dbc = mysqli_connect('localhost','aliendatabase') or die('Error connecting to MySQL      server.');
    $query = "INSERT INTO aliens_abduction (first_name, last_name, when_it_happened, how_long, ".
   "how_many, alien_description, what_they_did, fang_spotted, other, email) " .
   "VALUES ('$first_name', '$last_name', '$when_it_happened', '$how_long', '$how_many', " .
   "'$alien_description', '$what_they_did', '$fang_spotted', '$other', '$email')";


   $result = mysqli_query($dbc, $query)
   or die(mysqli_error($dbc));

   mysqli_close($dbc);

Community · Accepted Answer · 2023-11-17 19:53:52Z

2

Correct Syntax is

mysqli_connect('host','username', 'password', 'database_name');

Read manual :- https://www.php.net/manual/en/function.mysqli-connect.php

For localhost without password

mysqli_connect('localhost','root', '', 'database_name');

edited Nov 17, 2023 at 19:53

CommunityBot

11 silver badge

answered Oct 2, 2014 at 11:47

Rakesh Sharma

13.7k5 gold badges41 silver badges44 bronze badges

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

1 Comment

Rakesh Sharma Over a year ago

mysqli_connect('localhost','root', '', 'database_name'); keep password blank

Edd · Accepted Answer · 2014-10-02 11:47:32Z

0

You have to select your database after mysqli_connect using mysqli_select_db('your_database_name');

answered Oct 2, 2014 at 11:47

Edd

6832 gold badges13 silver badges23 bronze badges

1 Comment

user3602426 Over a year ago

mysqli_select_db(connection,dbname); I tried mysqli_select_db($dbc, 'aliendatabase'); but it still says no database selected

Collectives™ on Stack Overflow

No database selected error php mysql

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related