Tag: PHP

PHP Lesson: MySQL

 MySQL adalah sistem database yang digunakan dengan PHP.

Create Table.

<?php
 $servername = "localhost";
 $username = "username";
 $password = "password";
 $dbname = "myDB";
 $conn = new mysqli($servername, $username, $password, $dbname);

 $sql = "CREATE TABLE Table1(PersonName varchar(255),City varchar(255),Phone varchar(255));";
 if(mysqli_query($conn, $sql) == TRUE) echo "Table1 is created";
 else echo "Error: " . $sql . mysqli_error($conn);
 mysqli_close($conn);

Read More