Table data insert : Database Insert « MySQL Database « PHP

PHP
1. Chart
2. Class
3. Components
4. Cookie Session
5. Data Structure
6. Design Patterns
7. Development
8. Email
9. File Directory
10. Form
11. Functions
12. Graphics Image
13. HTML
14. Language Basics
15. Login Authentication
16. Math
17. MySQL Database
18. Network
19. String
20. Web Services SOAP WSDL
21. XML
Microsoft Office Word 2007 Tutorial
Java
Java Tutorial
Java Source Code / Java Documentation
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
C# / C Sharp
C# / CSharp Tutorial
ASP.Net
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Python
SQL Server / T-SQL
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
PHP » MySQL Database » Database Insert 
Table data insert

<?php
   mysql_connect("mysql153.secureserver.net","java2s","password");
   mysql_select_db("java2s");

      $id = "12";
      $name = "Joe";

      $query = "INSERT INTO Employee SET id='$id', name='$name'";
      $result = mysql_query($query);

      // Display an appropriate message
      if ($result
         echo "<p>Product successfully inserted!</p>";
      else 
         echo "<p>There was a problem inserting the Employee!</p>";

      mysql_close();
?>


           
       
Related examples in the same category
1. Use form to add data to database
2. Adding a Row to a Table
w_ww___.__ja_v__a___2__s___.___c__o___m___ | Contact Us
Copyright 2003 - 08 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.