extracting database created in mysql using php

Question

0.00/5 (No votes)

See more:

hi..
i have created database in mysql and i am trying to insert data in a table by using php.connection gets created but database doesn't gets detected(not able to select).I have tried to do this in two methods.

1)

C#

define ("DB_HOST", "localhost"); // set database host
define ("DB_USER", "root"); // set database user
define ("DB_PASS",""); // set database password
define ("DB_NAME","test_db"); // set database name
$link = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Couldn't make connection.");
$db = mysql_select_db(DB_NAME, $link) or die("Couldn't select database");

----
--?>

2)

C#

$con = mysql_connect("localhost","","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

if (mysql_query("CREATE DATABASE customer",$con))
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }
mysql_select_db("customer", $con);

mysql_close($con);
?>

please help me out.
thanx in advance..

Posted 27-Jul-12 4:51am

saeel chary

Updated 27-Jul-12 5:29am

Kenneth Haugland

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Diana Weiss · Answer 1 · 2012-10-16T11:41:00

Hi there :)

First I wanted to inquire if your DB is local or in the cloud (like this cloud database or AWS’ MySQL solution)? (you cannot be sure today ;))

If you are using one of the managed solutions, try looking in their guides or support sections. If you are managing your own local DB, then my recommendation is checking using CREATE database DDL with an [IF NOT EXISTS] argument. So when trying to detect your DB, you should try running the following query:

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
    [create_specification] ...

Using this script in your query should create a DB in case one does not exist and if a DB exists it should return no error. In such a case, try reconnecting to your DB (after re-checking you got all details right, oh how many times hours of trying to figure out what’s wrong with some script to find it was all due to a typo).

Hope this helped some, Diana

Kislay Raj · Answer 2 · 2012-08-07T00:38:00

Solution 19

use query

SQL

"SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'DBName'"

to detect Database before creating database if database is EXISTS then why create that database every time you will visit or open that page. I would like to snuggest to use function

Posted 7-Aug-12 0:38am

Kislay Raj