w3school sql

<?php
// Provide login information
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
  if ($conn->connect_error) {
      die("Connection failed: " . $conn->connect_error);
  } else {
      echo "Connected successfully";
  }

?>

SELECT  'test1' AS [@class]
    , ( SELECT  'test2' as [@class]
        , (SELECT 'Name' FOR XML PATH(''))
        FOR XML PATH('td'), type)
    ,(SELECT  'test3' as [@class]
        , (SELECT 'Value' FOR XML PATH(''))
        FOR XML PATH('td'), type) 
FOR XML PATH('tr'), type

<?php
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = new mysqli($servername, $username, $password);

 // Check connection

 if ($conn->connect_error) {

  die("Connection failed: " . $conn->connect_error);
}


 
// Create database

 $sql = "CREATE DATABASE myDB";
if ($conn->query($sql) === TRUE) {
  echo "Database created successfully";
} else {
  echo "Error creating database: " . $conn->error;
}

$conn->close();

?>
 

CREATE TABLE friends (
   id INTEGER,
   name TEXT,
   birthday DATE
);

INSERT INTO friends (id, name, birthday) 
VALUES (1, 'Jane Doe', '1990-05-30');


INSERT INTO friends(id , name , birthday)
VALUES(2 , 'APOORV' , '2000-2-2');



UPDATE friends
SET name = 'Jane Srivastava'
WHERE id = 1;

ALTER TABLE friends 
ADD COLUMN email TEXT; 


UPDATE friends 
SET email =  '203029@klsafjls'
where id  = 1; 

UPDATE friends 
SET email =  '203029@klsafjls'
where id  = 2;

DELETE FROM friends 
WHERE id = 1;


SELECT * 
FROM friends;

class ClassName {

   constructor() { ... }

}
 

<?php
$servername = "localhost";
$username = "username";

 $password = "password";

try {
  $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);

    // set the PDO error mode to exception
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    echo "Connected successfully";
 
} catch(PDOException $e) {
  echo "Connection failed: " . $e->getMessage();
}

?>
 

MDN vs W3S: Civil War!