Membuat Database dan Tabel php
Membuat
Database
CREATE DATABASE database_name
|
Program24-1.php
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
mysql_close($con);
?>
|
Membuat
Tabel
CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
....... )
|
Program24-2.php
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
// Create database
if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
// Create table in my_db database
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE Person
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";
mysql_query($sql,$con);
mysql_close($con);
?>
|
Tipe
Data di MySQL
|
Numeric Data Types
|
Description
|
|
int(size)
smallint(size) tinyint(size) mediumint(size) bigint(size) |
Hold integers only. The maximum number
of digits can be specified in the size parameter
|
|
decimal(size,d)
double(size,d) float(size,d) |
Hold numbers with fractions. The maximum
number of digits can be specified in the size parameter. The maximum number
of digits to the right of the decimal is specified in the d parameter
|
|
Textual Data Types
|
Description
|
|
char(size)
|
Holds a fixed length string (can contain
letters, numbers, and special characters). The fixed size is specified in
parenthesis
|
|
varchar(size)
|
Holds a variable length string (can
contain letters, numbers, and special characters). The maximum size is
specified in parenthesis
|
|
tinytext
|
Holds a variable string with a maximum
length of 255 characters
|
|
text
blob |
Holds a variable string with a maximum
length of 65535 characters
|
|
mediumtext
mediumblob |
Holds a variable string with a maximum
length of 16777215 characters
|
|
longtext
longblob |
Holds a variable string with a maximum
length of 4294967295 characters
|
|
Date Data Types
|
Description
|
|
date(yyyy-mm-dd)
datetime(yyyy-mm-dd hh:mm:ss) timestamp(yyyymmddhhmmss) time(hh:mm:ss) |
Holds date and/or time
|
|
Misc. Data Types
|
Description
|
|
enum(value1,value2,ect)
|
ENUM is short for ENUMERATED list. Can
store one of up to 65535 values listed within the ( ) brackets. If a value is
inserted that is not in the list, a blank value will be inserted
|
|
set
|
SET is similar to ENUM. However, SET can
have up to 64 list items and can store more than one choice
|
Primary
Keys dan Auto Increment Fields
$sql = "CREATE TABLE Person
(
personID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(personID),
FirstName varchar(15),
LastName varchar(15),
Age int
)";
mysql_query($sql,$con);
|
0 komentar:
Post a Comment