提取使用php在mysql中创建的数据库 [英] extracting database created in mysql using php

问题描述

hi ..
我已经在mysql中创建了数据库，并且尝试使用php将数据插入表中.创建了连接但未检测到数据库(无法选择).我尝试了两种方法.

1)

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)

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)

----
--?>

2)

$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..

推荐答案

link = mysql_connect(DB_HOST，DB_USER，DB_PASS)或die(" 无法建立连接.");

link = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Couldn't make connection.");

db = mysql_select_db(DB_NAME，

db = mysql_select_db(DB_NAME,

link)或die(" );

link) or die("Couldn't select database");

----
-?>

2)

----
--?>

2)

这篇关于提取使用php在mysql中创建的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！