Who programming in PHP? - Web Hosting Forums Web Discussions on Hosting Webmaster forums Web Hosting Forums Domain Name Forums Web Hosting

dima · 09-17-2005, 04:26 PM

I want to create my own CMS. I know PHP language but I don't know how to work with MySQL. May you help me? Please, excuse me for bad English...

gate2vn · 09-17-2005, 04:57 PM

download PHP manual, and you can see how to connect with mySQL DB

Can you design mySQL DB? Designing and Optimizing.

btw, take a look at Mambo, it's a very good CMS. You can learn many things from there

skamfroj · 09-24-2005, 12:43 PM

explain the problem or what you wanted in detail(specific). so that if some know / can help.. might post a solution.

as gate2vn stated. look into php manual and sample or tutorials.

a sample mysql connection :

Quote:

$db = mysql_connect("localhost", "myusername", "mypassword");
mysql_select_db("school_database", $db);

$getFile=mysql_query("SELECT * FROM student_table WHERE category = 1 ORDER BY id,title",$db);
if ($fileInfo=mysql_fetch_array($getFile)) {
do {
echo $fileinfo[name] . "<br/>"
} while($fileInfo=mysql_fetch_array($getFile));
}

Momo · 10-10-2005, 12:53 PM

I think it would be better if you use an existing script for CMS at first, then play around with it and learn how it works and connects with MySQL. Then when you're comfortable with it, you can code your own.