PHP MYSQL ADVICE EKAK ONE DANNA KENEK KIYANA PULUWANDA

[praveendpa]

MATA DANAGANNA ONE ADD BUTTON EKA CLICK KARAMA TABLE 2KAKATA DATA YAWANA WIDIYA. MATA W3SCHOOL EKEN CODE EKAK LEBUNA. ETH EKE TIBBE, EKAMA TABLE EKATA SQL STATEMENT KEEPAYAKIN DATA DANA WIDIYA. MAMA EKA WENAS KARA, DANNA KENEK KIYANAWADA EKA HARIDA KIYALA.

CODE EKA MENNA
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', '[email protected]');";
$sql .= "INSERT INTO ABC (ADDRESS)
VALUES ( 'KALUTHARA');";
$sql .= "INSERT INTO XYZ (GRADE)
VALUES ('PASS')";

if ($conn->multi_query($sql) === TRUE) {
echo "New records created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

 

[ftthushara]

BUMP

 

[mAjIc hAt]

Bump​

​

 

[[email protected]]

http://www.w3schools.com/php/func_mysqli_multi_query.asp