How To Use MySql Databases

Hey guys,

I know quite a bit about HTML coding and have made some simple websites but never used databases or had an admins panel. Can all of you help on giving me the basis of how to make an admin panel and being able to add and delete things from the database and have the things in the database to be put into a template I made and be put on the web.

Basicall a very simple CMS that can add and delete articles so I can learn from it and make websites for other people!

Thanks if you help!!

 

Here are 20 video tutorials, about 5 minutes each on how to do specific tasks like;

Registering a domain
Setting up an affiliate program
Setting up an autoresponder
Setting up a buy button for your website
Making your website look pretty
The important elements you need to have on your sales page
How to track your traffic and visitors

and so on..

Here's the link;

http://www.teach-me-how.com/how-to-make-money-on-the-internet


Regards, Marta

 

are you using cpanel and phpmyadmin?

 

Thanks marta, will look at the link.

PatMcCrackit, yep, I have both, I have 3 websites rightn ow all of them have it but two of them are run by scripts so I did none of the database coding but some of the template. So yes, I have cpanel and phpmyadmin on all of them and when I learn enough and make some for people I will make sure I use cpanel and phpmyadmin

*Edit*
Just looked at link and none of the videos really explain anything about using the databases and learning php (if I need to) or any HTML, thanks for the link though.

 

Download some free scripts from http://www.hotscripts.com study the php code and try making some simple scripts. This way you will have some knowledge about writing code. Also visit php.net and mysql.org for detailed info and tutorials on php and mysql respectively.

Also since you have cpanel hosting you can use fantastico (if available) to install scripts without learning to code.

 

http://www.amazon.com/MySQL-Visual-QuickStart-Guide-Ullman/dp/0321127315

Buy the book. First class


http://www.dmcinsights.com/mysql2/

Download the scripts / look at



Let me know how you get on

 

If you are new to database development then read the links above. After a while you can move on to a framework in whichever language you choose.

Definitely check the video tutorials.

 

) everyone is is asking to buy something. What kind of scripts r u using? and what u wanna do with the database? if u have 3 websites maybe i think 1 may be paid hosting/domain. Just dont bother if u have paid one. I've the solution. Just pm me.

 

http://www.php-mysql-tutorial.com/mysql-tutorial/index.php
best tutorial for mysql beginners

 

Thanks guys! Will look at all your links, but I am not so desperate to buy something, so will look a t the tutorials and so on.