Forum Moderators: open
SQL Manager for MYSQL was the nearest I could find to Enterprise Manager. There are probably free ones out there that are similar, but this was the most user-friendly for me that I tested.
If you learned how to make a website, you can learn the basics of building a dynamic website. In a matter of a month, I went from building static sites to building database-driven ones with PHP and MySQL. How? Four key ingredients:
1) A wonderful book by Kevin Yank called "Build Your Own Database Driven Website Using PHP and MySQL". I can't recommend it enough.
2) Search/ask here for answers.
3) Search google for more answers.
4) A great article on webmonkey called "your first database". It'll really get you familiar with the theory behind database design - definitely good to know before you start creating a data-driven site.
If you're interested, first, in PHPmyAdmin, just play around with it, create some tables, add some content, edit some content, delete some content, and watch the queries that run (PHPmyAdmin will show the query it ran to do what the GUI let you do without knowing SQL) and then try to create some of your own in the SQL window.
Good luck!
After a month or two you won't need Dreamweaver any more and you'll be well on your way.
learning how to deal with databases is up to you. it's a big field, and important to learn if you're going to want to use databases effectively.
I tend to be a visual learner
Have fun!
I'm like you--scared off by all the MySQL syntax and the difficulty of picking it up via manuals. However, I have looked at alot of PHP code generators also, including PHPrunner. I settled on dbqwiksite. It's extremely powerful, blows many others away. Takes some work to get familiar with it, but worth it if you want all the flexibility to develop database-driven web pages for MySQL.
<?php
//Sample Database Connection Syntax for PHP and MySQL.
//Connect To Database
$hostname="mysql.#*$!xxx.net";
$username="thisishard";
$password="bollux";
$dbname="loadofswill";
$usertable="pigswill";
$yourfield = "your_field";
mysql_connect($hostname,$username, $password) OR DIE (" ");
mysql_select_db($dbname);
# Check If Record Exists
$query = "SELECT * FROM $usertable";
$result = mysql_query($query);
if($result)
{
while($row = mysql_fetch_array($result))
{
$name = $row["$yourfield"];
echo "Name: ".$name."
";
}
}
?>
Also this will scale so much better if you find yourself with hundreds of thousands of records. I have 100 of sites in production in our office using it, it is all we use and have never needed more, even with clients who have massive massive data requirments.
of course as is you will have unformatted pieces of info
but it is a beginning
although
the querry could be built diferently
but got to go!
good luck
remember to have fun :)
The "your_field" refers to a column in your database table. You just need to change it in the one place where it's written with an underscore to match something in your db table. The other places where it's written "yourfield" are referring to the PHP variable, so you don't have to rename those, although usually I keep things consistently named so I don't get confused.
You can post it here or sticky me.
