Jump to content


Photo

Manually Creating Databases.


  • Please log in to reply
2 replies to this topic

#1 fruzzgle

fruzzgle
  • Members
  • PipPip
  • Member
  • 17 posts
  • LocationKS City :]

Posted 03 June 2006 - 11:17 PM

I know there is this thing you can download and in most hosting plans they have a php admin. With the php admin you can create new databases, tables, quaries, and all kinds of stuff. But the php Admin really confuses me and I think It would be a lot easyer If I did it all manually. Lets say I want to create a users database, how would I do this-

-What code is used to create new database (somthing like mysql_create_database or somthing).
-And how do I run the code and create it. Do I make a new page for it and visit the page once- creating a new database?

Thanks in Advanced.

#2 stephenk

stephenk
  • Members
  • PipPipPip
  • Advanced Member
  • 62 posts

Posted 04 June 2006 - 12:01 PM

Some hosts won't allow you to create databases through a script. I know with mine anyway, they require you to use their control panel to create the databases, then I use PHPMyAdmin to control them.

Stephen

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 04 June 2006 - 05:00 PM

You should be able to write a PHP script do issue whatever DB statements you want, provided that you have a DB user with the appropriate credentials.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users