homepage Welcome to WebmasterWorld Guest from 54.166.105.24
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
How can i create a database using PHP and MySQL?
digital signage



 
Msg#: 4391234 posted 7:39 am on Nov 26, 2011 (gmt 0)

please send me these questions answar.theae are very important for me.

How can i create a database using PHP and MySQL?

 

vivalasvegas

5+ Year Member



 
Msg#: 4391234 posted 8:17 am on Nov 26, 2011 (gmt 0)

You create a database in your hosting control panel. Then you can access the database also from your hosting panel to add fields and data. Using PHP you make the database work on your website. This is not something you can learn by reading a q&a doc. Maybe hiring a programmer would be a good idea.

httpwebwitch

WebmasterWorld Administrator httpwebwitch us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4391234 posted 9:23 pm on Nov 26, 2011 (gmt 0)

it's true, typically you won't create a database using PHP. You'll create the database via direct access to MySQL, either with a control panel or directly from a command line interface.

Actually it's unusual to manipulate tables in PHP too; typically you'll define your table schema during app development, and in PHP you'll only be selecting, inserting, deleting and updating rows.

the command to create a database - when you're connected to it via command line or control panel - is "CREATE DATABASE ..."

Here's the syntax:
[dev.mysql.com...]

viva is correct - if you're working on a mission-critical app with a deadline, then you'll want to get an experienced programmer to do it right. SQL is a very *deep* topic with lots of little gotchas. But say you're doing this as a student to learn how it's done, then there are lots of great tutorials all over the www and excellent books you can read.

Good luck!

rocknbil

WebmasterWorld Senior Member rocknbil us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4391234 posted 5:30 pm on Nov 28, 2011 (gmt 0)

In **most** systems, creating a database requires you do so as the root user of the domain (or a user with create database permissions, such as the "cpanel user") - which is a very dangerous thing to put in a script. This is why most open source CMS's, shopping carts, whatever, that connect to a database ask you to enter the user, password, and database name as the first step of installing their software.

nelsonm

5+ Year Member



 
Msg#: 4391234 posted 8:52 pm on Nov 28, 2011 (gmt 0)

go to [wampserver.com...] and download and install their wamp server. It contains PhpMyAdmin. You can also go to [phpmyadmin.net...] , it's the offical site for PhpMyAdmin. Once installed onto your developement server, you can create your database from there or... if you have an account with a hosting service, you can use their PhpMyAdmin to create your database.

PhpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

digital signage



 
Msg#: 4391234 posted 9:08 am on Dec 1, 2011 (gmt 0)

Thank's to all for Give me a better solutions.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved