One MySQL Database & Multiple Table

Question

How to connect to a certain table in MySQL database?

I have tried :

mysql_select_db("baybeestore",$connection);

but it gives me an error :-

"Error : Table 'baybeestore.form' doesn't exist"

But I've created a table named as order. Are there any PHP codes to connect to my table order in the same database that have multiple databases?

Is it wise enough to create multiple database & one table for one website or multiple table with one database?

FULL CODE :

$connection = mysql_connect("localhost","user","1234");
    if(!$connection)
    {
        die('Failed to connect to MySQL :' . mysql_error());
    }
    mysql_select_db("baybeestore",$connection)
    $sql = "INSERT INTO
    form(name, address, email, handphone, item, payment)

    VALUES
    ('$strname', '$straddress', '$stremail', '$strhandphone', '$stritem', '$strpayment')";

    if(!mysql_query($sql, $connection))
    {
        die('Error : ' . mysql_error());
    }
    echo "Data have been saved.";
    mysql_close($connection);

The usual way is one database per application (or application domain) with multiple tables. — Joachim Isaksson
– Joachim Isaksson, Commented Dec 13, 2013 at 16:08
Don't use mysql_* use either PDO or mysqli. It's deprecated. — Michael Villeneuve
– Michael Villeneuve, Commented Dec 13, 2013 at 16:09
You should have a look at this youtube series youtube.com/watch?v=BEbKji_pSZM . Hope this helps! :) — Rwd
– Rwd, Commented Dec 13, 2013 at 16:13
As per your edit/added code. You're using two different tables for your queries. Result: ERROR You have SELECT * FROM order and INSERT INTO form 2 different animals altogether. If anything, that should be INSERT INTO order or SELECT * FROM form yet... ORDER is a reserved word and should be enclosed with backticks. dev.mysql.com/doc/refman/5.5/en/reserved-words.html — Funk Forty Niner
– Funk Forty Niner, Commented Dec 13, 2013 at 16:28
I suggest you read this article on INSERT along with everything else listed on that website, and/or find tutorials on mysqli_ and PDO. Stop using mysql_ functions also. I myself studied Database syntax for 6 months, and spent 3 months testing and building from tutorials before I felt I was good and ready. If you have the time to do so, you will have much better success with your code, believe me ;-) — Funk Forty Niner
– Funk Forty Niner, Commented Dec 13, 2013 at 16:44

Community · Accepted Answer · 2017-05-23 12:24:21Z

4

As per your edit/added code. Your originally posted code

You're using two different tables for your queries. Result: ERROR

You have SELECT * FROM order and INSERT INTO form 2 different animals altogether.

If anything, that should be INSERT INTO order or SELECT * FROM form yet... ORDER is a reserved word and should be enclosed with backticks.

I.e.:

INSERT INTO `order`

http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Dec 13, 2013 at 16:48

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

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

Comments

elixenide · Accepted Answer · 2013-12-13 16:08:46Z

4

This is a very confusing question. mysql_select_db("baybeestore",$connection); has nothing to do with table names, so your error must be coming from somewhere else. Also, the error refers to the table form, but you say you have created a table named order.

To answer your questions:

You don't connect to tables; you connect to databases and run queries against tables. Connect to my_database or whatever, then run queries like SELECT * FROM my_table.
One database, multiple tables -- definitely not multiple databases, which is much more complicated, generates a ton of overhead, and doesn't help in any way.

answered Dec 13, 2013 at 16:08

elixenide

44.9k16 gold badges79 silver badges103 bronze badges

Comments

David · Accepted Answer · 2013-12-13 16:08:19Z

1

Maybe you are confusing things. You are supposed to connect to a database and then run queries against one or multiple tables in that database.

So if you have database My_Database and tables table1, table2 you could run

mysqli_select_db($connection, "My_Database");

and then run queries like

$result = mysqli_query("SELECT * FROM table1 WHERE 1 LIMIT 1");

please note that I have changed the function names to mysqli_* because mysql_* functions are deprecated and should not be used anymore

answered Dec 13, 2013 at 16:08

David

1,9182 gold badges15 silver badges33 bronze badges

1 Comment

Funk Forty Niner Over a year ago

Side note: The mysqli_ api method, mysqli_query() requires a database connection as the first argument. Example from the manual if (mysqli_query($link, "CREATE TEMPORARY TABLE myCity LIKE City") === TRUE) {.

raygo · Accepted Answer · 2013-12-13 16:17:42Z

1

Now that you are learning, I recommend you to start learning the correct way. Don't use mysql_ functions. Try learning PDO. Also, use one database per application.

To connect you can try:

    try {
    $conn = new PDO('mysql:host=localhost;dbname=myDatabase', $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}

You can learn more about PDO through this link

answered Dec 13, 2013 at 16:17

raygo

1,4285 gold badges19 silver badges42 bronze badges

Collectives™ on Stack Overflow

One MySQL Database & Multiple Table

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related