1 April 2012 49 Comments

[MySql] How To Insert Record In Php MySql Table

Hi Friends,
Let we know how to insert record in Php MySql table.After creation of Php MySql table
we can insert the record in table.Whenever we want to develop dynamic system in Php
at that time we need database.

Let we see syntax.

 
    INSERT INTO table_name (col1, col2, col3,...)
    VALUES (val1, val2, val3,...);

As per above syntax we can insert record in Php MySql.
Now we see example with table ‘student’ which is created earlier.

 
   $sql="INSERT INTO table_name (roll_no, name, mobile_no)
    VALUES ('', 'Php Freelancers',1234567890)";
 
   mysql_query($sql);

Using mysql_query() function we we can execute MySql code in Php.

Thanks..!!

Tags:

49 Responses to “[MySql] How To Insert Record In Php MySql Table”

  1. bondage 1 April 2012 at 11:47 am #

    I would like to thnkx for the efforts you’ve put in writing this web site. I’m hoping the same high-grade site post from you in the upcoming as well. In fact your creative writing abilities has encouraged me to get my own web site now. Actually the blogging is spreading its wings quickly. Your write up is a great example of it.

  2. plombier paris 3 1 April 2012 at 3:08 pm #

    I agree with you. This type of projects should be encouraged and I think that these type of projects are the projects for the future

  3. Pamala Kapp 1 April 2012 at 10:09 pm #

    Found your website on Yahoo and just want to say that I liked it.

  4. Patrice Daurizio 1 April 2012 at 10:09 pm #

    Thanks,
    Will come back soon …

  5. James Doil 1 April 2012 at 10:21 pm #

    Found your website on Google and just want to say that I liked it.

  6. Arica Torry 1 April 2012 at 10:22 pm #

    Found your website on Google and just want to say that I liked it.

  7. Dominga Wheeling 1 April 2012 at 10:23 pm #

    Thanks,
    Will come back soon …

  8. Princess Joor 1 April 2012 at 10:27 pm #

    Thanks,
    Will come back soon …

  9. Bao Maldenado 1 April 2012 at 10:28 pm #

    Thanks,
    Will come back soon …

  10. Clifford Hagmaier 1 April 2012 at 10:37 pm #

    Found your website on Google and just want to say that I liked it.

  11. Jule Defranco 2 April 2012 at 12:28 pm #

    Can you tell us more about this? I’d love to find out some additional information.

  12. DesignserviceCanada 2 April 2012 at 3:20 pm #

    Hello There. I discovered your weblog the use of msn. This is a very smartly written article. I will be sure to bookmark it and come back to read more of your useful information. Thank you for the post. I will certainly return.

  13. Bryant Weydert 6 April 2012 at 8:50 pm #

    I appreciate your wordpress theme, where do you down load it through?

  14. Lenora Amari 7 April 2012 at 3:55 am #

    For a nice and surfing online greater than 3 hrs today, yet I never discovered any interesting write-up like yours. Its pretty worth personally. I think, if all webmasters and bloggers produced great content because you did, the net will probably be significantly much more helpful than any other time.

  15. Jim 9 April 2012 at 12:56 pm #

    Hi! I work for a long time in web, games, web development and if you need any help or have any questions shoot me a message: welcome at lezgro.com. Ask for Jim. Glad to help.

  16. Edmundo Dapas 11 April 2012 at 6:03 pm #

    Thanks for the writeup. I definitely agree with what you are saying. I have been talking about this subject a lot lately with my mother so hopefully this will get him to see my point of view. Fingers crossed!

  17. Kieth Perish 11 April 2012 at 9:28 pm #

    Once I initially commented I clicked the -Notify me when new feedback are added- checkbox and now each time a comment is added I get 4 emails with the same comment. Is there any manner you may take away me from that service? Thanks!

  18. Giuseppina Echoles 11 April 2012 at 9:51 pm #

    Many thanks for creating the effort to discuss this, I feel strongly about this and like learning a great deal more on this matter. If feasible, as you gain knowledge, would you mind updating your weblog with a great deal more information? It’s extremely beneficial for me.

  19. Corey Lothspeich 13 April 2012 at 12:49 am #

    Nice site

  20. Joie Tuppen 13 April 2012 at 12:31 pm #

    I could not concur any more! Superb blog post, have a nice day, Regards.

  21. Jenny 14 April 2012 at 1:05 am #

    You made some respectable points there. I regarded on the web for the difficulty and located most individuals will go along with with your website.

  22. Luigi Ashbacher 14 April 2012 at 1:51 am #

    I just want to tell you that I am just beginner to blogging and truly liked you’re website. More than likely I’m planning to bookmark your blog . You surely have fabulous writings. Bless you for sharing your web-site.

  23. beats headphones 14 April 2012 at 10:11 am #

    your baby can read

  24. beats by dr dre 14 April 2012 at 11:10 am #

    I’ve found your homework is well done this time.

  25. Patrica Chaplen 15 April 2012 at 11:12 am #

    The subsequent time I read a blog, I hope that it doesnt disappoint me as much as this one. I imply, I do know it was my option to learn, however I truly thought youd have something interesting to say. All I hear is a bunch of whining about one thing that you might repair in the event you werent too busy in search of attention.

  26. Lucy 15 April 2012 at 11:30 pm #

    Spot on with this write-up, I truly assume this website wants way more consideration. I’ll most likely be once more to read way more, thanks for that info.


Trackbacks/Pingbacks.

  1. Homepage - 04. Apr, 2012

    … [Trackback]…

    [...] Read More: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  2. smslaen - 08. Apr, 2012

    … [Trackback]…

    [...] Read More Infos here: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  3. poly plantation shutters - 09. Apr, 2012

    … [Trackback]…

    [...] Informations on that Topic: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  4. whiplash compensation - 09. Apr, 2012

    … [Trackback]…

    [...] Read More here: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  5. how to detox your body - 09. Apr, 2012

    … [Trackback]…

    [...] There you will find 79823 more Infos: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  6. pikalaina - 09. Apr, 2012

    … [Trackback]…

    [...] Read More: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  7. dating disasters - 09. Apr, 2012

    … [Trackback]…

    [...] Read More here: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  8. SEO Newcastle Australia - 10. Apr, 2012

    … [Trackback]…

    [...] There you will find 66629 more Infos: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  9. visit - 11. Apr, 2012

    … [Trackback]…

    [...] There you will find 72013 more Infos: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  10. bingo cards - 11. Apr, 2012

    … [Trackback]…

    [...] Informations on that Topic: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  11. bingo card maker - 11. Apr, 2012

    … [Trackback]…

    [...] Read More here: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  12. Website - 11. Apr, 2012

    … [Trackback]…

    [...] Read More Infos here: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  13. youth group scavenger hunt - 12. Apr, 2012

    … [Trackback]…

    [...] There you will find 79583 more Infos: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  14. social media marketing - 12. Apr, 2012

    … [Trackback]…

    [...] Find More Informations here: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  15. social media for restaurants - 12. Apr, 2012

    … [Trackback]…

    [...] Read More: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  16. social media small business - 13. Apr, 2012

    … [Trackback]…

    [...] Read More: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  17. plazma burst 2 - 13. Apr, 2012

    … [Trackback]…

    [...] Read More: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  18. leadership - 13. Apr, 2012

    … [Trackback]…

    [...] Read More here: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  19. laina - 13. Apr, 2012

    … [Trackback]…

    [...] Read More here: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  20. routing number, aba routing, bank routing number, aba routing number, routing transit number - 13. Apr, 2012

    … [Trackback]…

    [...] There you will find 66688 more Infos: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  21. Vertaa lennot - 13. Apr, 2012

    … [Trackback]…

    [...] Read More: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  22. abdominoplastia - 15. Apr, 2012

    … [Trackback]…

    [...] There you will find 64106 more Infos: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

  23. jeux nintendo ds - 15. Apr, 2012

    … [Trackback]…

    [...] Informations on that Topic: phpfreelancerszone.com/mysql-how-to-insert-record-in-php-mysql-table-35644/ [...]…

Leave a Reply

*