.


:

:



,



( , )

:

































 

 

 

 
FAQ

.11. MySQL

PHP , . , . , , (). PHP MySQL.

MySQL, , (). frm, MYD, MYI. . , . , , .

, Web-, PHP MySQL. , , . -.

-

, - . Web- Apache, MySQL, ORACLE, Windows.

, , . MSIE (MS Internet Explorer), ICQ. , - . , , . . , , . , , , , .

( ), . .

:

FTP (File Transfer Protocol)

HTTP (Hyper Text Transfer Protocol)

SMTP (Simple Mail Transfer Protocol)

IP (Internet Protocol)

MySQL Client/Server Protocol

, , .

, Apache MySQL. .

, () : news/index.php. MSIE, Apache MySQL :

 

  1. (Apache) ( )
  2. (MSIE) !
  3. (Apache) !
  4. (MSIE) ?
  5. (Apache) !
  6. (MSIE) news/index.php
  7. (Apache) ( PHP index.php /news)
  8. (Apache) ( PHP , , MySQL )
  9. (Apache) ( HTML PHP)
  10. (Apache) !
  11. (MSIE) ( HTML )
  12. (MSIE) !
  13. (Apache) !
  14. (Apache) ( )
  15. (MSIE) ( HTML )

 

, PHP MySQL.

. , , , , , .

 

, . mysql_ connect(). : , . ( ), .

 

11.1 ( primer11_1.php)

 

<?php

$p = mysql_connect(" ", " ","") or die(" ");

?>

 

, , , . -.

 

die(). , mysql_connect() , false, die() . , .

 

, , , . mysql_ select_ db(), : . , , , .

 

11.2 ( primer11_2.php)

 

<?php

print "";

$p = mysql_connect(" ", " ","") or die(" ");

print "";

print " new";

mysql_select_db(" ") or die("No base!!! ");

print " ";

?>

 

mysql_select_db( ) new. , , , No base!!! .

 

. telephones. , .

, . .

 

tinyint

-128 127

smallint

-32 768 32767

mediumint

-8 388 608 8 388 607

int

-2 127 483 648 2 127 483 647

bigint

-9 223 372 036 854 775 808 9 223 372 036 854 775 807

 

float
double

 

tinytext

255

text

65 535

mediumtext

16 777 215

longtext

4 294 967 295

 

.

, , . VARCHAR, , , VARCHAR(20).

. "" , . ,

NOT NULL ,

PRIMARY KEY(_) ,

AUTO_INCREMENT 1 (), ,

INDEX KEY ( ),

UNIQUE .

 

 

, . 4 :

id INT AUTO_INCREMENT PRIMARY KEY , 1, .
surname VARCHAR(20) , . , 20
email VARCHAR(20)
tel VARCHAR(20)

 

SQL:

create table telephones(id INT AUTO_INCREMENT PRIMARY KEY,

surname VARCHAR(20),

email VARCHAR(20),

tel VARCHAR(20));

 

SQL . mysql_querry(). : . ( ), , false . , .

11.3 telephones ( primer11_3.php)

<?php

$p = mysql_connect(" ", " ","") or die( );

mysql_select_db(" ", $p) or die(" ");

$query = "CREATE TABLE telephones(id INT AUTO_INCREMENT PRIMARY KEY,

surname VARCHAR(20),

email VARCHAR(20),

tel VARCHAR (20))";

mysql_query($query, $p) or die(" ");

print " ";

?>

 

SQL $query. , mysql_query(). , mysql_connect(). .

. , CREATE TABLE mysql_query . $query .

 

. , SQL .

 

11.4 ( primer11_4.php)

 

<?php

$p = mysql_connect(" ", " ","");

mysql_select_db(" ",$p) or die (" ");

$query = "INSERT INTO telephones(surname,email,tel)

values('Kolbin', '[email protected]', '580-46-82');

mysql_query($query, $p) or die(" ");

print " ";

?>

 

, id. . , . 11.4 , , id ( 1).

, , . , , . .

11.5 , , .

 

11.5 ( add_user.html)

 

<html>

<body>

<form action="add.php" method="POST">

Surname <input type="text" name="surname">

Email: <input type="text" name="email">

Tel: <input type="text" name="tel">

<input type="submit" value="ADD">

</form>

<body>

<html>

 

: add.php, .

 

11.6 ( add.php)

 

<?php

 

function add_data($surname, $email, $tel)

{

$p=mysql_connect(" ", ,) or die( );

mysql_select_db(" ",$p) or die("NO BASE!");

$query = "INSERT INTO telephones(surname, email, tel)

values('$surname','$email','$tel')";

mysql_query($query,$p) or die("Could't execute");

}

 

if (($_POST['surname']!="") and ($_POST['email']!="") and ($_POST['tel']!= ""))

{

add_data($_POST['surname'], $_POST['email'], $_POST['tel']);

print "Added data: Surname: ".$_POST['surname']. ", Email: ".$_POST['email']. ", TEl: " $_POST['tel']. "<br>";

}

else

{

print "Check data<br>";

}

?>

<html>

<body>

<a href="add.html">Add another</a>

</body>

</html>

 

add_data() . new. , (telephones). add_data() : ($surname), ($email) ($tel). PHP , add.

if, : $surname (and) $email $tel (!="") ( , ), add_data() , , . (, - ), , .

HTML-, add_user.html . , - .

 

,

 

. SQL- SELECT. , .

 

11.7 ( primer11_7.php)

 

<?php

$p = mysql_connect(" ", " ","");

mysql_select_db(" ") or die ("NO BASE!");

 

$query = "SELECT surname, tel, email

FROM telephones

WHERE surname = $_POST['surname']";

 

$result = mysql_query($query) or die ("Can't execute");

 

while($mas_info = mysql_fetch_row($result))

foreach($mas_info as $temp)

{

print "$temp<br>";

}

?>

 

<html>

<head>

<title> Find tel by name </title>

</head>

<body>

<form method ="POST">

Surname: <input type = "text" name = "surname">

<input type = "submit" value = "FIND">

</form>

</body>

</html>

 

C new. SQL-, . $surname, . $query, mysql_query(). , , . , .

while $mas_info , mysql_fetch_row(). , , . . , false while . $mas_info .

HTML- . , , .

 

- . , . .

 

 

 

.. 1

- PHP. 1

.1. . 1

PHP HTML.. 2

. 2

.2. . 3

. 3

.. 4

. 4

.. 4

.. 5

. 5

. 6

. 6

.3. .. 6

. 6

if 6

else if 7

elseif if 8

.. 9

while. 10

. 11

.4.. 11

. 12

. 13

. 13

.5... 13

. 14

array() 14

. 14

.. 15

. 16

. 16

foreach. 16

. 17

sort() 17

. 18

.6. . 18

, .. 18

.. 20

HTML- PHP- . 22

. 23

. 24

.7. . 24

.. 24

. 25

. 25

. 26

, . 26

fgets() 27

fwrite () 27

. 28

.8. .. 29

. 29

. 29

. 30

.9. . 30

printf() 30

. 30

. 31

. 31

.10. . 31

. 31

. 31

. 32

. 33

. 33

.11. MySQL.. 34

-. 34

. 35

. 35

. 36

, . 39

. 40

 

<== | ==>
7.2 primer7_2.php | ?
:

: 2018-10-18; !; : 272 |

:

:

, - , ; , - .
==> ...

1478 - | 1487 -


© 2015-2024 lektsii.org - -

: 0.125 .