memasukan data ke mysql

Syntax

"INSERT INTO table_name(column_name1, column_name2)VALUES('value1, 'value2')" ;

Overview In this tutorial create 2 files 1. insert.php 2. insert_ac.php Step 1. Create table "test_mysql" in database "test". 2. Create file insert.php. 3. Create file insert_ac.php. If you don't know how to create database and table click here to learn

Create table "test_mysql" CREATE TABLE `test_mysql` ( `id` int(4) NOT NULL auto_increment, `name` varchar(65) NOT NULL default '', `lastname` varchar(65) NOT NULL default '', `email` varchar(65) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=0 ;

Create file insert.php View In Browser ############### Code Insert Data Into mySQL Database Name : Lastname : Email :

	Create file insert_ac.php
Diagram ############### Code $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="test_mysql"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // Get values from form $name=$_POST['name']; $lastname=$_POST['lastname']; $email=$_POST['email']; // Insert data into mysql $sql="INSERT INTO $tbl_name(name, lastname, email)VALUES('$name', '$lastname', '$email')"; $result=mysql_query($sql); // if successfully insert data into database, displays message "Successful". if($result){ echo "Successful"; echo " "; echo "Back to main page"; } else { echo "ERROR"; } // close connection mysql_close(); ?> syntax for www.phpeasystep.com

Read More →