Connecting to MySql Database

• • Reply

  11 years ago

  by donpucket

  Don Puckett

  prince frederick, United States

  Joined 11 years ago

  I have just went through and got the code to be able to create a database in mysql. I'm very very new at this, but how to you connect to a database and to view your data on a simple row and colum format. Thank you so much for your time!

  Don

  Report abuse
• • Reply

  10 years ago

  by karthicktc

  karthick T C

  bangalore, India

  Joined 10 years ago

  Please try this steps thus we create the database connect("localhost","username","password"); if (!$con) { die('Could not connect: ' . mysqlerror()); }

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

  mysql_close($con); ?>

  connecting the database

  $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="databasename"; // Database name

  // Connect to server and select databse. mysqlconnect($host, $username, $password)or die("cannot connect"); mysqlselectdb($dbname)or die("cannot select DB")

  Regards, Karthick

  [URL="http:// www.module-node.com/"] Drupal Web Developers | | Drupal Theme Developers | Drupal Development [/URL]

  Report abuse