CGI & PHP Enhance your site with CGi, PHP and ASP scripts

  Subscribe via RSS

  Follow @XavierMedia

PHP and MYSQL – Connecting to a Database and Adding Data

November 19th, 2011 by CGI & PHP.com


Whats coverd: -What is MYSQL -phpmyadmin -getting data from a database with php -displaying that data on a page -insert data using a form –source code comming soon!

Popularity: 2% [?]


Subscribe to new posts from this blog
You may also be interested in...
PHP Tutorials: MySQL (Part 2)
PHP Tutorial – 24 – Connecting to MySQL Database
PHP Tutorial – 23 – Adding Tables to MySQL Database
Use PHP to Retrieve MySQL Data
MySQL Database Usage & Administration
Beginning MySQL Database Design and Optimization: From Novice to Professional

25 Responses to “PHP and MYSQL – Connecting to a Database and Adding Data”

  1. praveshb13 Says:

    Hello buddy! I wud lyk 2 thank u, 4 ur video tutorial was of gr8 help 2 me. I did not know how to program using php – mysql, ur video was a gr8 introductive step! :)

  2. santstudios Says:

    free scripts like onebip gateway at w.w.w santstudio(do)com

  3. Jabberwock156 Says:

    Thanks for the tutorial man. I would just suggesting making the letter size bigger because it's a little hard to read. Oh, and for some strange reason my code only worked after I deleted the quotation marks from (ID, Name, Description) in Create.php.

  4. phgh1520 Says:

    i like this tutorial!!!!

  5. Rightwingful Says:

    After two days of errors. I have to differ mysql_query("INSERT INTO people
    (Name, Description) VALUES. without the single quotation mark and use header("Location: index.php) one time. After I did this slight midification it work 100%
    Thank you very much for this useful tutorial.

  6. ShaneNL69 Says:

    I am trying to connect to my dbhost but i can't figure out what to do. It's on another server and the index.html is on again a different server. So how can i find out what the dbhost is?

  7. ShaneNL69 Says:

    @vpklotar The 'notepad' this user is using is called 'Aptana studio Professional'
    But I use notepad++ and Adobe DW CS5. But I am going to test this one out

  8. facebookprogrammer Says:

    Curious around 23:00 how will the user see the message USE HAS BEEN ADDED if there is a server-side re-direct immediately after?

  9. manasume Says:

    i installed xampp but when i start it, apache is not running, only my sql is running, do you know what can i do about that?

  10. tharaclassic Says:

    @easyvideoseries

  11. MusiqOfAmani Says:

    Where is the source code? Also thanks a lot I'm using this on my Final Project at Un

  12. CALAVIDEOS2013 Says:

    @vpklotar looks like aptana 3.0 studio.

  13. aneesmug Says:

    Grate jooooooooooooooooooob Boooooss
    it is tooo much goooooooooooooooooooood
    Thanks.

  14. carloseztorres Says:

    Thanks!!!!!!

  15. TheLegend1245 Says:

    I'm so confused:(

  16. TheLegend1245 Says:

    Is it the same as creating a Mysql table and a PHP form to connect?

  17. frabbasi1 Says:

    Thanks for the great knowledge and specially for the web site

  18. easyvideoseries Says:

    ITS AWESOME….love d video….best tutorial i have seen

  19. easyvideoseries Says:

    ITS AWESOME….love d video….best tutorial i have seen !

  20. mrwaeta1 Says:

    @zainshah120 he is using aptana studio google it ,, try netbeans its awsome

  21. ktajpuri Says:

    this wallpaper comes with windows 7 noob

  22. zainshah120 Says:

    can any one tell me please the software he is using…please…

  23. zainshah120 Says:

    @pbj746 i had downloaded the latest version of notepad but these options are not present there

  24. JSnooza88 Says:

    im getting this error when I add data: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "ID', 'Name', 'Description') VALUES (NULL, 'marvin','is awsome')' at line 1

  25. rykitz Says:

    Extremely helpful! Thank you so much! :) Keep up the great work!

Leave a Reply

Powered by WP Status.net plugin.


Fantastic web hosting at cheap prices
© Copyright 1996-2012 Xavier Media®. All rights reserved.
Contact us | Support/help | Privacy Policy | About Xavier Media
The World According to Xavier | Powered by Yahoo! Answers