1

mysql_connect(host name, user name, password)

01

<?

02

//the example of MySQL database connection

03

//connect.php

04

$continued = mysql_connect("localhost","root","admin");

05

if ($continued) {

06

    echo ("Connection is succeed")

07

} else {

08

    echo ("Connection is fail")

09

}

10

?>

1

mysql_create_db("database")

01

<?

02

//the example of making MySQL database

03

//create.php

04

$continued = mysql_connect("localhost","root","admin");

05

if($continued){

06

    echo("Connection is succeed");

07

}else{

08

    echo("Connection is fail");

09

}

10

$make = mysql_create_db("data_root");

11

if($make){

12

    echo("<br><br>Database data_root succeeds in making");

13

}else{

14

    echo("<br><br>Database data_root fails in making");

15

}

16

?>

01

<?

02

//the example of making MySQL database table

03

//create_table.php

04

$continued = mysql_connect("localhost","root","admin");

05

if($continued){

06

    echo("Connection is succeed");

07

}else{

08

    echo("Connection is fail");

09

}

10

$make = mysql_create_db("employees");

11

if($make){

12

    echo("<br><br>Employees database succeeds in making");

13

}else{

14

    echo("<br><br>Employees database fails in making");

15

}

16

$order1 = "CREATE TABLE data_employees

17

    (

18

        employees_number int(10)AUTO_INCREMENT PRIMARY KEY,

19

        name char(100),

20

        address varchar(255)

21

    )";

22

$make_table = mysql_db_query("employees",$order1);

23

if($make_table){

24

    echo("<br><br>Table data_employees succeeds in making");

25

}else{

26

    echo("<br><br>Table data_employees fails in making");

27

}

28

?>

نوع داده

Gyration assess

TINYINT

(-128) - 127 or 0 - 255

SMALLINT

(-32768) - 32767 or 0 - 65535

MEDIUMINT

(-8388608) - 8388607 or 0 - 16777215

INT

(-2147683648) - 2147683647 or 0 - 4294967295

BIGINT

(-9223372036854775808) - 9223372036854775807 or 0 - 18446744073709551615

FLOAT(X)

(-3.402823466E+38) - (-1.175494351E-38), 0, and 1.175494351E-38 - 3.402823466E+38.

FLOAT

The same as above

DOUBLE

(-1.7976931348623157E+308) - (-2.2250738585072014E-308), 0, and 2.2250738585072014E-308 - 1.7976931348623157E+308

نوع داده

حافظه مورد نیاز

TINYINT

1 byte

SMALLINT

2 bytes

MEDIUMINT

3 bytes

INT

4 bytes

INTEGER

4 bytes

BIGINT

8 bytes

FLOAT(X)

4 ifX <=24 or 8 if 25 <=X <=53

FLOAT

4 bytes

DOUBLE

8 bytes

DOUBLE PRECISION

8 bytes

REAL

8 bytes

DECIMAL(M,D)

M+2 bytes if D>0, M+1 bytes if D=0(D+2, if M<d)< td=""></d)<>

NUMERIC(M,D)

M+2 bytes if D>0, M+1 bytes if D=0(D+2, if M<d)< td=""></d)<>

نوع داده

Gyration assess

CHAR

1-255 character

VARCHAR

1-255 character

TINYLOB, TINYTEXT

1-255 character

BLOB, TEXT

1-65535 character

MEDIUMLOB, MEDIUMTEXT

1-16777215 character

LONGLOB, LONGTEXT

1-4294967295 character

ENUM('element1','element2',...)

Maximal 65535 character

SET('element1','element2',...)

Maximal 64 element

نوع داده

حافظه مورد نیاز

CHAR(M)

M bytes, 1 <=M <=255

VARCHAR(M)

L+1 bytes, L <=M and 1 <=M <=255

TINYLOB, TINYTEXT

L+1 bytes, L <2^8

BLOB, TEXT

L+2 bytes, L<2^16

MEDIUMLOB, MEDIUMTEXT

L+3 bytes, L<2^24

LONGBLOB, LONGTEXT

L+4 bytes, L<2^32

ENUM('element1','element2',...)

1 or 2 bytes, depend to the number of element

SET('element1','element2',...)

1, 2, 3, 4 or 8 bytes, depend to the number of element

نوع داده

Gyration assess

DATETIME

'1000-01-01 00:00:00' to '9999-12-31 23:59:59'

DATE

'1000-01-01' to '9999-12-31'

TIMESTAMP

'1970-01-01 00:00:00' - 2037

TIME

'-838:59:59' to '838:59:59'

YEAR

1901 - 2155

نوع داده

حافظه مورد نیاز

DATE

3 bytes

DATETIME

8 bytes

TIMESTAMP

4 bytes

TIME

3 bytes

YEAR

1 bytes

01

<?

02

//the example of inserting data

03

//data_insert.php

04

mysql_connect("localhost","root","admin");//database connection

05

mysql_select_db("employees");

06

$order = "INSERT INTO data_employees

07

            (name, address)

08

            VALUES

09

            ('H.R. Dian',

10

            'Jl. Raya Baru KOTABARU')";

11

//inserting data order

12

13

//declare in the order variable

14

$result = mysql_query($order);

15

if($result){

16

    echo("<br>Input data is succeed");

17

}else{

18

    echo("<br>Input data is fail");

19

}

20

?>

1

UPDATE name_table SET field1=new_value, field2=new_value, ...

2

WHERE condition1,condition2, ...

01

<?

02

//the example of changing MySQL database field table

03

//change_field.php

04

05

//database connection

06

mysql_connect("localhost","root","admin");

07

mysql_select_db("employees");

08

09

$order1 = "ALTER TABLE data_employees MODIFY position char(50)";

10

$add_field = mysql_db_query("employees", $order1);

11

if ($add_field){

12

    echo ("<br><br>Field position succeeds in adding");

13

}else{

14

    echo ("<br><br>Field position fails in adding");

15

}

16

?>

01

<?

02

//the example of deleting MySQL database field table

03

//delete_field.php

04

mysql_connect("localhost","root","admin");//database connection

05

mysql_select_db("employees");

06

$order1 = "ALTER TABLE data_employees DROP position";

07

$add_field = mysql_db_query("employees", $order1);

08

if ($add_field){

09

    echo ("<br><br>Field position succeeds in deleting");

10

}else{

11

    echo ("<br><br>Field position fails in deleting");

12

}

13

?>