Insert data ke table

Sabtu, 24 Agustus 20130 komentar

Sangat mudah sekali membuat kode insert ke table mysql .

gunakan struktur ini

INSERT INTO table_name
VALUES (value1, value2, value3,...)

atau bisa juga dengan
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)


Contoh kode yang saya punya
saya mempunyai table "Person" dan database "my_db"

<?php
$con=mysqli_connect("example.com","peter","abc123","my_db");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

mysqli_query($con,"INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Peter', 'Griffin',35)");

mysqli_query($con,"INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Glenn', 'Quagmire',33)");

mysqli_close($con);
?> 





Share this article :

Posting Komentar

 
Template Created by Creating Website Published by W3skul
Proudly powered by Blogger