Making a new database in PHP

unknowngiver · 02-22-2007, 10:59 PM

Hey
is there a way to make a new Database in PHP? in a php script...i cant figure it outt...Thanks

Barrucadu · 02-23-2007, 01:09 AM

I'm not sure, but I believe the command to use is create database

PHP Code:

  <?php

// Possibly something like this:

mysql_connect('blah', 'blah', 'blah);

mysql_query('create database blah');

mysql_close();

?>

shockie · 02-23-2007, 01:55 AM

uh... i don't think that will work. when you make a database you need to specify the type(s) of data you are feeding into it... if you can anticipate this then just make a blank database.

Slewey · 02-23-2007, 02:30 AM

the types of data are specified in the tables;

you can create a database with

PHP Code:

  $query  = "CREATE DATABASE test_database";

$result = mysql_query($query);

or

PHP Code:

  mysql_create_db('test_database');

After that you can select that database and create tables in it

PHP Code:

  mysql_select_db('test_database') or die('Cannot select database');

????: NamePros.com http://www.namepros.com/programming/297626-making-a-new-database-in-php.html
 
$query = 'CREATE TABLE users( '.

         'id INT NOT NULL AUTO_INCREMENT, '.

         'name VARCHAR(20) NOT NULL, '.

         'email VARCHAR(50) NOT NULL, '.

         'message TEXT NOT NULL, '.

         'PRIMARY KEY(id))';

 
$result = mysql_query($query); 

????: NamePros.com http://www.namepros.com/showthread.php?t=297626

Peter · 02-23-2007, 06:45 AM

as Slewey states you can use the mysql_create_db function but the user you connect with must have permissions to create a database.

unknowngiver · 02-23-2007, 12:48 PM

well i can make databases through cpanel..but i cant seem to do it using PHP...in the user thing..do i put my username and password for Cpanel/

Barrucadu · 02-23-2007, 12:53 PM

Originally Posted by unknowngiver

well i can make databases through cpanel..but i cant seem to do it using PHP...in the user thing..do i put my username and password for Cpanel/

No, in cPanel you must make a user with the ability to make a database. Then you use those user's details when conencting via php.

unknowngiver · 02-23-2007, 01:00 PM

Access denied for user 'funny_dbmaker'@'%' to database 'funny_blah'

in cpanel there is no way of setting a user to make databases i think? u can only assign a user to specific databases 2 perform stuff on them..

Peter · 02-24-2007, 02:51 AM

Originally Posted by unknowngiver

well i can make databases through cpanel..but i cant seem to do it using PHP...in the user thing..do i put my username and password for Cpanel/

cPanel uses the adminitrator account if I remember correctly to create a database. Just had a look at the mysql user creation page as well and it seems that cPanel does not give the ability to let an account create a database 9only tables hence the create privaleges)

unknowngiver · 02-24-2007, 07:48 PM

So theres no way of making databases in PHP?

btw i remember seeing a site [some1 posted it on namepros] once where u typed in your cpanel information 2 make newdatabses throuigh that site..so it should be possible i guess?

Peter · 02-25-2007, 03:00 AM

Originally Posted by unknowngiver

So theres no way of making databases in PHP?

Only if the user you are connecting with has the privileges to create a database and cpanel does not allow you to give that right.

Originally Posted by unknowngiver

btw i remember seeing a site [some1 posted it on namepros] once where u typed in your cpanel information 2 make newdatabses throuigh that site..so it should be possible i guess?

They most likely used cURL which would simulate someone doing it manually.

EDIT
----

Just had a look and the following seems to be the sort of script you mean http://www.zubrag.com/scripts/cpanel...se-creator.php
????: NamePros.com http://www.namepros.com/showthread.php?t=297626

Quote:

cPanel does not allow you to create databases directly from MySQL/PhpMyAdmin on cPanel webhosting. You would have to login to cPanel and use its interface to create database each time you need a new one.
cPanel Database Creator will make this process much easier. In order to create a database on your hosting server you just need to run this script from browser, shell, or cron job, passing database name as parameter.

If you look on the site you will see the system requirements are that cURL is installed. This will basically log into cPanel and basically act as if you were creating it yourself.

unknowngiver · 02-25-2007, 07:31 PM

hm pretty gud

buh how would u add a user now?

02-22-2007, 10:59 PM	THREAD STARTER #1 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 3,088	Making a new database in PHP Hey is there a way to make a new Database in PHP? in a php script...i cant figure it outt...Thanks __________________ Simplifying Engineering \|\| $$ Currency Converter $$ Julsh - Community/Dating Website \|\| Free Image hosting Fresh Proxies \|\| Random Proxy \|\| Troll Board

02-23-2007, 01:09 AM	#2 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	I'm not sure, but I believe the command to use is create database PHP Code: `<?php // Possibly something like this: mysql_connect('blah', 'blah', 'blah); mysql_query('create database blah'); mysql_close(); ?>` __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

02-23-2007, 01:55 AM	#3 (permalink)
shockie Senior Member Join Date: Dec 2006 Posts: 4,702	uh... i don't think that will work. when you make a database you need to specify the type(s) of data you are feeding into it... if you can anticipate this then just make a blank database. __________________ - shockie

02-23-2007, 02:30 AM	#4 (permalink)
Slewey NamePros Regular Join Date: Apr 2004 Location: NL Posts: 808	the types of data are specified in the tables; you can create a database with PHP Code: `$query = "CREATE DATABASE test_database"; $result = mysql_query($query);` or PHP Code: `mysql_create_db('test_database');` After that you can select that database and create tables in it PHP Code: mysql_select_db('test_database') or die('Cannot select database'); ????: NamePros.com http://www.namepros.com/programming/297626-making-a-new-database-in-php.html $query = 'CREATE TABLE users( '. 'id INT NOT NULL AUTO_INCREMENT, '. 'name VARCHAR(20) NOT NULL, '. 'email VARCHAR(50) NOT NULL, '. 'message TEXT NOT NULL, '. 'PRIMARY KEY(id))'; $result = mysql_query($query); ????: NamePros.com http://www.namepros.com/showthread.php?t=297626

02-23-2007, 12:48 PM	THREAD STARTER #6 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 3,088	well i can make databases through cpanel..but i cant seem to do it using PHP...in the user thing..do i put my username and password for Cpanel/ __________________ Simplifying Engineering \|\| $$ Currency Converter $$ Julsh - Community/Dating Website \|\| Free Image hosting Fresh Proxies \|\| Random Proxy \|\| Troll Board

02-23-2007, 06:45 AM	#5 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,069	as Slewey states you can use the mysql_create_db function but the user you connect with must have permissions to create a database.

02-23-2007, 01:00 PM	THREAD STARTER #8 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 3,088	Access denied for user 'funny_dbmaker'@'%' to database 'funny_blah' in cpanel there is no way of setting a user to make databases i think? u can only assign a user to specific databases 2 perform stuff on them.. __________________ Simplifying Engineering \|\| $$ Currency Converter $$ Julsh - Community/Dating Website \|\| Free Image hosting Fresh Proxies \|\| Random Proxy \|\| Troll Board

02-24-2007, 07:48 PM	THREAD STARTER #10 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 3,088	So theres no way of making databases in PHP? btw i remember seeing a site [some1 posted it on namepros] once where u typed in your cpanel information 2 make newdatabses throuigh that site..so it should be possible i guess? __________________ Simplifying Engineering \|\| $$ Currency Converter $$ Julsh - Community/Dating Website \|\| Free Image hosting Fresh Proxies \|\| Random Proxy \|\| Troll Board

02-25-2007, 07:31 PM	THREAD STARTER #12 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 3,088	hm pretty gud buh how would u add a user now? __________________ Simplifying Engineering \|\| $$ Currency Converter $$ Julsh - Community/Dating Website \|\| Free Image hosting Fresh Proxies \|\| Random Proxy \|\| Troll Board

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)