Making a new database in PHP

unknowngiver · 02-22-2007, 09: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, 12: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, 12: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, 01: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');

 
$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);

Peter · 02-23-2007, 05: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, 11:48 AM

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, 11:53 AM

Quote:

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, 12: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, 01:51 AM

Quote:

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, 06: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, 02:00 AM

Quote:

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.

Quote:

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

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, 06:31 PM

hm pretty gud

buh how would u add a user now?

02-22-2007, 09:59 PM	#1 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 2,928 1,675.13 NP$ (Donate)	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 __________________ B3Z.NET Proxy \|\| B5Y.NET Proxy \|\| B7J.NET Proxy \|\| B5J.NET Proxy \|\| B5L.NET Proxy cPanelHosting.com-cPanel Experts For 8 Years Hosting From $4.99 And 2 Months Free

02-23-2007, 12:09 AM	#2 (permalink)
Barrucadu Barru. Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,731 78.50 NP$ (Donate)	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 \| Uzbl (my branch) 9thSeptember2009.com

02-23-2007, 12:55 AM	#3 (permalink)
shockie Senior Member Join Date: Dec 2006 Posts: 4,478 1,025.10 NP$ (Donate)	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 Linux VPS Hosting From $9.95 With A FREE Control Panel & DOUBLE Burst RAM! Monopoly Companies Binary Addition Coffee Makers & Grinders How to Wash Your Hands 5 Ways To Make Money Blogging Do You Want To Make Money Online?

02-23-2007, 01:30 AM	#4 (permalink)
Slewey NamePros Regular Join Date: Apr 2004 Location: NL Posts: 827 316.85 NP$ (Donate)	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'); $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);` __________________ xmpv.com \| nuwp.com \| frot.info \|

02-23-2007, 11:48 AM	#6 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 2,928 1,675.13 NP$ (Donate)	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/ __________________ B3Z.NET Proxy \|\| B5Y.NET Proxy \|\| B7J.NET Proxy \|\| B5J.NET Proxy \|\| B5L.NET Proxy cPanelHosting.com-cPanel Experts For 8 Years Hosting From $4.99 And 2 Months Free

02-23-2007, 05:45 AM	#5 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	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, 12:00 PM	#8 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 2,928 1,675.13 NP$ (Donate)	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.. __________________ B3Z.NET Proxy \|\| B5Y.NET Proxy \|\| B7J.NET Proxy \|\| B5J.NET Proxy \|\| B5L.NET Proxy cPanelHosting.com-cPanel Experts For 8 Years Hosting From $4.99 And 2 Months Free

02-24-2007, 06:48 PM	#10 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 2,928 1,675.13 NP$ (Donate)	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? __________________ B3Z.NET Proxy \|\| B5Y.NET Proxy \|\| B7J.NET Proxy \|\| B5J.NET Proxy \|\| B5L.NET Proxy cPanelHosting.com-cPanel Experts For 8 Years Hosting From $4.99 And 2 Months Free

02-25-2007, 06:31 PM	#12 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 2,928 1,675.13 NP$ (Donate)	hm pretty gud buh how would u add a user now? __________________ B3Z.NET Proxy \|\| B5Y.NET Proxy \|\| B7J.NET Proxy \|\| B5J.NET Proxy \|\| B5L.NET Proxy cPanelHosting.com-cPanel Experts For 8 Years Hosting From $4.99 And 2 Months Free

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