Самостоятел_2(2)
.pdf+ |
|
|
|
|
} |
|
|
|
|
?> |
|
|
|
|
|
|
|
) |
$ |
|
|
) |
|
© |
|
) |
* |
|
|
|
Pcec |
ek c co |
k |
|
|
IsOMH) |
kc |
gsmkfZ]ihh_]n%& gsmkfZj]ihh_]n%&* |
|
|
|
|
|
|
* |
gsmkfZ]ihh_]t(). |
|
|
|
.* |
gsmkfZj]ihh_]n%&* |
|
|
|
/* |
^c_%&* |
|
|
|
61
|
oc |
co |
c c |
k k) |
|
|
|
|
K@>? LDL |
|
|
|
|
|
|
|
c |
|
K@>? LDL* |
|
K@>? |
||
|
k |
|
|
|
|
|
|
1. |
|
|
|
|
|
|
|
2. |
|
|
|
|
|
|
|
3. |
|
|
|
|
|
|
|
4. |
|
|
|
|
|
|
|
5. |
|
|
|
|
|
|
|
T |
c c: |
|
|
|
|
|
|
1. |
© |
- }LDL dMo_ls |
) |
)., |
)//0 * |
|
|
2. |
|
- } |
) |
6 |
).,, |
).44 |
* |
3. |
** |
- } |
0) 6} |
|
).,, |
)/1. |
* |
|
|
|
k |
e o |
|
|
|
|
|
|
|
|
K@>? |
|
|
|
|
|
K@>? |
) |
|
|
|
|
K@>?) |
|
|
|
K@>?) |
|
|
|
|
) |
|
=LE) |
K@>?=LE* |
|
|
|
6 |
|
||
Adabas D; |
|
|
|
|
|
|
|
|
IODBC; |
|
|
|
|
|
|
|
|
IBM DB2; |
|
|
|
|
|
|
|
|
Solid; |
|
|
|
|
|
|
|
|
Sybase SQL Anywhere. |
|
|
|
|
|
|
||
|
6 |
|
|
|
|
K@>? |
|
|
|
* |
|
|
|
K@>? |
|
|
|
|
* |
) |
|
K@>? - |
|
% |
|
|
|
|
& |
|
|
* |
|
|
|
|
K@>? |
|
) |
|
|
- |
||
|
|
|
|
* |
|
|
|
|
|
|
0, |
|
K@>?* |
) |
|
|
K@>? - |
|
|
|
|
) |
|
© * |
|
|
|
|
|
odbc_connect() |
|
|
|
|
|
|
© |
K@>? - |
|
|
|
|
) |
|
|
|
$ * $ |
|
|
i]]Z]ihh_]n%&* |
|
||
odbc_connect() : |
|
|
|
|
|
|
|
|
chni^]Z]ihh_]n%mnlcha © Z |
)mnlcha $Z |
)mnlcha |
W)chn Z |
X& |
||||
|
© |
Z |
K@>? - |
|
|
) |
|
|
|
$ * |
$Z |
|
) |
© |
|
) |
$ |
|
) |
|
© |
|
* |
$ |
|
|
Z |
|
$ |
|
) |
|
|
|
|
K@>?* |
© |
|
© |
6 |
|
|
|
|
SQL_CUR_USE_IF_NEEDED; |
|
|
|
|
|
|
||
SQL_CURSOR_USE_ODBC; |
|
|
|
|
|
|
||
SQL_CUR_USE_DRIVER; |
|
|
|
|
|
|
||
SQL CUR DEFAULT. |
|
|
|
|
|
|
||
© |
) |
|
|
) |
|
|
|
$ |
) |
|
K@>? |
|
|
|
|
* |
|
|
i^]Z]ihh_]n%& |
|
* |
: |
|
|
|
<?
obdc_connect("myAccessDB", "user", "secret") or die( "Could not connect to ODBC database"); ?>
62
|
|
|
|
(persistent) |
' |
. |
, |
odbc_pconnect() |
, |
' |
, |
||
, |
' |
. |
|
|
|
|
|
|
|
odbc_close() |
|
|
|
|
ODBC - |
|
|
' |
|
, |
, |
|
|
' |
. ' |
|
|
odbc_close() : void odbc_close([int |
|
_ ' |
]) |
|
|
|
|
Z$ |
|
|
|
$ |
* |
:
<?
obdc_connect("myAccessDB", "user", "secret") or die("Could not connect to ODBC database"); print "Currently connected to ODBC database"!; odbc_close($connect);
?>
|
|
odbc_prepare() |
|
|
|
chni^]Zjl_j[l_%chn |
Z$ |
)mnlcha & |
|
|
Z$ |
|
$ |
) |
i^]Z]ihh_]n%&* |
|
) |
|
* |
© |
) |
B=HOA7 |
|
) |
|
|
i^]Z_r_]on_%&% |
* © &* |
|
|
|
odbc_execute() |
|
|
) |
|
i^]Zjl_j[l_%&) |
|
i^]Z_r_]on_%&* |
i^]Z_r_]on_%&6 |
|
|
|
|
chni^]Z_r_]on_%chn |
|
W)[l[s |
X& |
|
|
Z |
|
|
) |
i^]Zjl_j[l_%&* |
$ |
|
) |
|
|
|
* |
|
|
:
<?
$connect = @obdc_connect("myAccessDB", "user", "secret") or die("Could not connect to ODBC database");$query = "UPDATE customers SET cust_id = \"Milano, Inc.\" WHERE cust_id \"2000 cu\"";
$result = odbc_prepare($connect, $query) or die("Couldn' t prepare query"!); $result = odbc_execute($result) or die("Couldn' t execute query"!); odbc_close($connect);?>
|
|
|
K@>?) |
|
© |
% |
|
|
OAHA?P&* |
K@>? |
MQANU |
© ) |
i^]Zl_mofnZ[f%&* |
|
|
|
odbc_exec() |
|
|
i^]Z_r_]%& $ i^]Zjl_j[l_%& i^]Z_r_]on_%&* |
i^]Z_r_]%&6 |
|||
chni^]Z_r_]%chn |
Z$ |
)mnlcha |
& |
|
|
Z$ |
|
$ |
) |
i^]Z]ihh_]n%&* |
|
|
) |
* |
© |
) |
B=HOA7 |
|
) |
|
|
6 |
|
|
<?
obdc_connect("myAccessDB", "user", "secret") or die("Could not connect to ODBC database"); $query = "SELECT * FROM customers";
$result = odbc_exec($connect, $query) or die("Couldn' t execute query"!); odbc_close($connect);?>
odbc_exec() |
, |
|
$query. |
$result |
; |
FALSE |
, |
die(). |
|
odbc_result_all() |
|
|
63 |
|
© |
odbc_result_all() |
|
© |
|
, |
odbc_exec() |
odbc_execute(). |
odbc_result_all() : |
|
int odbc_result_all(int |
_ |
[, string |
_ |
]) |
|
Z |
|
|
) |
i^]Z_r_]%& i^]Z_r_]on_%&* |
$ |
Z |
||
|
DPIH* |
|
|
6 |
<?
obdc_connect("myAccessDB", "user", "secret") or die("Could not connect to ODBC database"); $query = "SELECT * FROM customers";
$result = odbc_exec($connect, $query) or die("Couldn' t execute query"!); odbc_result_all($result, "BGCOLOR='#c0c0c0' border='1' ");odbc_close($connect);?>
customers
|
|
|
*0,** |
ODBC |
|
|
|
|
odbc_free_result() |
|
|
|
|
|
|
) |
$ |
|
* |
|
K@>? |
|
i^]Zl__Zl_mofn%&* |
|
|
i^]Zl__Zl_mofn%&6 |
|
|
|
|
int odbc_freeZl_mofn%chn |
Z |
& |
|
|
|
|
|
|
) |
|
|
* |
$ ) |
$ |
|
7 |
|
) |
i^]Zl__Zl_mofn%& |
© |
) |
|
© |
$ |
$ * |
© |
) |
i^]Zl__Zl_mofn%&* |
$ |
) |
|
© |
) |
|
|
|
|
) |
|
$ |
*
<?
obdc_connect("myAccessDB", "user", "secret") or die("Could not connect to ODBC database"); $query = "SELECT * FROM customers" :
$result = odbc_exec($connect, $query) or die("Couldn' t execute query"!); odbc_result_all($result, "BGCOLOR='#c0c0c0' border='1' "'); odbc_free_result($result);
odbc_close($connect); ?>
) |
i^]Zl_mofnZ[f%& |
) |
|
$ |
|
i^]Zl__Zl_mofn%&* |
|
|
Pcec |
ek c co |
k |
|
|
* |
|
|
|
kc |
|
1. |
i^]Z]ihh_]n%& |
|
|
2. |
i^bc_close() |
|
|
3. |
i^]Zjl_j[l_%& |
|
|
4. |
i^]Z_r_]on_%& |
|
|
5. |
i^]Z_r_]%& |
|
|
6. |
i^]Zl_mofnZ[f%& |
|
|
7. |
odbc_free_result() |
|
64
oc |
|
|
co c |
c |
k k) |
|
|
|
|
|
|
|
|
|
|
||
|
c |
|
|
|
IsOMH |
|
LDL* |
|
|
k |
|
|
|
|
|
|
|
1. |
|
|
|
|
|
|
|
|
2. |
|
|
|
|
|
|
|
|
3. |
|
|
|
|
|
|
|
|
4. |
|
|
|
|
|
|
|
|
5. |
|
|
|
|
|
|
|
|
T |
c c: |
|
|
|
|
|
|
|
1. |
© |
|
- }LDL dMo_ls |
) |
)., |
)//0 * |
||
2. |
|
- } |
|
|
) |
6 |
).,, |
).44 * |
3. |
** |
- } |
|
0) 6} |
).,, |
)/1. * |
||
|
|
|
|
k |
e o |
|
|
|
|
|
gsmkfZko_ls |
|
|
IsOMH* |
|
||
|
Onlo]nol_^Mo_lsH[hao[a_%OMH&*OMH- |
|
|
|
- |
|||
|
IsOQL - |
© |
|
|
* |
|
|
|
|
|
|
|
OMH- |
?NA=PA@=P=>=OA |
6 |
||
|
?NA=PA@=P=>=OA $ |
|
|
|
|
|
||
|
|
|
LDL- |
6 |
|
|
|
|
|
mysql_connect("mysql.myhost.com", "user", "sesame") or die(mysql_error()); |
|
||||||
|
mysql_query("CREATE DATABASE mydatabase") or die(mysql_error()); |
|
|
|||||
|
mysql_close(); |
|
|
|
|
|
|
|
|
$ |
|
IsOMH- |
* |
|
gs^[n[[m_* |
- |
|
$ |
IsOMH- |
* |
|
|
|
|
|
|
|
|
|
) |
|
|
LDL* |
|
|
|
|
OMH- |
?NA=PAP=>HA |
|
6 |
|
|
|
|
?NA=PAP=>HA $ |
|
|
|
|
|
||
|
( |
|
|
|
|
|
|
|
|
$Z |
|
Z |
) |
|
|
|
|
|
$Z |
. |
Z |
) |
|
|
|
|
|
$Z |
/ |
Z |
) |
|
|
|
|
|
... |
|
|
|
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
Z |
|
|
|
) |
|
|
* |
|
|
6 |
|
|
|
|
|
|
INT |
|
|
|
|
|
|
|
|
DECIMAL |
|
|
|
|
|
|
|
|
CHAR |
|
|
|
|
|
|
|
|
|
|
.11 |
|
© |
|
|
|
|
TEXT |
|
|
|
|
|
|
|
|
|
|
21)1/1 |
|
|
|
|
|
|
LONGTEXT |
|
|
|
|
|
|
|
|
|
|
|
0).50)523).51 |
|
|
|
|
|
Date |
|
|
|
|
|
|
|
|
|
|
-MM - |
|
|
|
|
|
|
Time |
|
|
|
|
|
|
|
|
|
|
6II 6 |
|
|
|
|
|
|
DATETIME |
|
|
|
|
|
|
|
|
|
|
|
- - |
6 6 |
|
|
|
|
65
* 6 mysql_connect("mysql.myhost.com", "user", "sesame") or die(mysql_error()); mysql_select_db("people") or die(mysql_error());
mysql_query("CREATE TABLE MyTable ( id INT AUTO_INCREMENT,
FirstName CHAR,
LastName CHAR, Phone INT, BirthDate DATE PRIMARY KEY(id)
)") Or die(mysql_error()); mysql_close ();
|
|
|
' |
MySQL - |
. |
|
|
gsmkfZm_f_]nZ^ |
j_ijf_* |
j_lmihm 1 |
* |
|
|||
|
) |
c^ |
EJP |
) |
|
|
|
|
) |
=QPKZEJ?NAIAJP |
|
|
|
) |
|
|
© |
|
|
E@* |
|
|
|
|
|
LNEI=NUGAU |
c^ |
|
+jlcg[lse_s* |
||
|
|
|
© |
%+ & |
) |
|
|
|
|
* |
|
|
|
|
|
|
|
|
jbjIs=^gch |
|
|
|
|
|
|
© |
|
|
LDL* |
|
|
|
jbjIs=^gch% |
- |
|
IsOMH&) |
|
|
|
|
- |
T=ILL* |
© |
) |
|
|
|
phpMyAdmin. |
|
|
|
|
|
|
|
|
|
jbjIs=^gch* |
- © ) |
|
IsOMH - |
|
|
% |
) bnj6+gsmkf*gsbimn*]ig &) |
© om_lh[g_ |
j[mmqil^* |
T=ILL |
6 |
||
http://localhost/phpmyadmin/ |
|
|
|
|
|
||
|
) |
|
$ |
?l_[n_ 6 |
|
|
|
|
© © |
) |
© |
* |
) |
) |
) © |
© |
* |
|
|
|
|
@[n[[m_m |
) |
6 |
|
66
$ |
Create new table in database ) |
$ |
|
Go": |
|
© |
_n]*) |
OMH* |
|
) |
|
id |
PRIMARY KEY |
|
AUTO_INCREMENT (A_I). |
|
|
|
|
|
|
|
* |
|
|
|
|
Pcec |
ek c |
co |
k |
|
|
|
|
|
SA>- |
* |
|
|
|
kc |
|
|
1. |
|
OMH- |
* |
|
|
2. |
) |
|
IsOMH* |
|
|
3. |
|
jbjIs=^gch* |
|
|
67
|
oc |
co |
c c |
k k) |
|
|
|
|
|
|
|
|
|
|
|
|
c |
|
IsOMH |
|
LDL* |
||
|
k |
|
|
|
|
|
|
1. |
|
|
|
|
|
|
|
2. |
|
|
|
|
|
|
|
3. |
|
|
|
|
|
|
|
4. |
|
|
|
|
|
|
|
5. |
|
|
|
|
|
|
|
T |
c c: |
|
|
|
|
|
|
1. |
© |
- }LDL dMo_ls |
) |
)., |
)//0 * |
|
|
2. |
|
- } |
) |
6 |
).,, |
).44 |
* |
3. |
** |
- } |
0) 6} |
|
).,, |
)/1. |
* |
|
|
k e o |
|
|
|
|
|
|
|
© |
|
6 |
© |
) |
OMH |
* |
|
|
|
|
$Query="INSERT into $TabName values ('valuel ', 'value2', 'value3 ', etc. ) "; |
|
|
||||
mysql_db_query("DatabaseName",$Query,$Link); |
|
|
|
|||
|
|
INSERT into $TabName values. |
© |
|
||
|
) |
|
|
* |
|
|
|
|
) |
|
|
* |
|
IsOMH |
gsmkfZ^Zko_ls%&* |
|
|
|||
|
) |
) |
|
DPIH |
) |
|
$) |
) |
|
|
*LDL |
) |
) |
|
|
* |
|
|
|
|
|
DPIH |
|
|
|
|
|
|
DPIH |
|
|
* |
|
|
|
DPIH |
6 |
|
|
|
|
<HTMLxHEADxTITLE>HTML Form</TITLEx/HEAD><BODY> |
|
|
||||
|
. |
|
|
|
|
|
<FORM ACTION="HandleForm.php" METHOD=POST> |
|
|
|
|||
|
. |
|
|
|
|
|
First Name <INPUT TYPE=TEXT NAME="Array[FirstName]" SIZE=20xBR> |
|
|
||||
Last Name <INPUT TYPE=TEXT 'NAME="Array [LastName] " SIZE=40xBR> |
|
|
||||
Email Address <INPUT. TYPE=TEXT NAME="Array[Email]" SIZE=60xBR> |
|
|
||||
Comments <TEXTAREA NAME='.'Array [Comments] " ROWS = 5 COLS=40> |
|
|
||||
</TEXTAREAxBR> |
|
|
|
|
|
|
© |
|
, © |
, |
|
|
|
|
HandleForm.php. |
|
|
|
|
|
|
Oogcn) |
DPIH |
* |
|
|
|
<INPUT TYPE=SUBMIT NAME="SUBMIT" VALUE="Submit ! "> |
|
|
||||
</FORMx/BODYx/HTML> |
|
|
|
|
|
|
© |
form.html |
© |
Web |
. |
|
|
<HTML>
<HEAD>
<TITLE>HTML Form</TITLE> </HEAD>
<BODY>
<FORM ACTION="HandleForm.php" METHOD=POST>
First Name -<INPUT TYPE=TEXT NAME="Array[FirstName]" SIZE=20xBR> Last Name <INPUT TYPE=TEXT NAME*11 Array [LastName]" SIZE=40xBR>
68
Email Address <INPUT TYPE=TEXT NAME*"Array[Email]" SIZE=60xBR> Comments <TEXTAREA NAME="Array[Comments]" ROWS=5 COLS=40> </TEXTAREAxBR>
<INPUT TYPE=SUBMIT NAME="SUBMIT" VALUE="Submit"!> </FORM>
</BODY>
</HTML>
HandleForm.php) |
|
* |
LDL |
*$ |
|
DPIH |
* |
|
<HTMLxHEADxTITLE>Inserting Data into a Database</TITLEx/HEADxBODY> |
|
|
LDL |
) |
) |
* |
|
|
<?php
$Array["FirstName" j = trim ($Array["FirstName"]); $Array["LastName"] = trim ($Array["LastName"]); $Array ["Email"] = trim ($Array ['"Email" ] ); $Array["Comments"] = trim ($Array["Comments"]);
.
$Host = "localhost"; |
|
|
|
|
|
|
$User = "user"; |
|
|
|
|
|
|
$Password = "password"; |
|
|
|
|
|
|
$DBName = "NewDatabase"; |
|
|
|
|
|
|
$TableName = "Feedback"; |
|
|
|
|
|
|
' |
MySQL, |
|
. |
|
|
|
$Link = mysql_connect ($Host, $User, $Password); |
|
|
|
|
||
SQuery = "INSERT into $TableName values ( " 0 ", "$Array[FirstName] |
|
|
||||
-"$Array[LastName]"Array[Email]"Array[Comments]")"; |
|
|
|
|
||
|
' |
INSERT into $TableName values. |
|
$ |
||
% |
© |
&) © |
|
|
© |
|
* |
|
|
|
|
|
|
c^ |
|
|
) |
© |
|
,* |
|
|
) |
|
|
) |
c^ |
$ |
|
* |
|
|
|
|
|
) |
) |
|
|
6 |
|
print ("The query is:<BR>$Query<P>\n"); |
|
|
|
|
||
|
|
|
) |
|
|
|
* |
|
) |
|
) |
© |
|
|
|
* |
|
|
|
|
|
) |
|
) |
|
|
|
|
|
* |
) |
|
|
) |
|
|
* |
|
|
|
|
if (mysql_db_query ($DBName, $Query, $Link)){ print ("The query was successfully executed!<BR>\n"); } else { . . '
print ("The query could not be executed!<BR>\n");
}
' |
MySQL, PHP |
HTML. |
|
mysql_close ($Link); |
|
|
|
?></BODYx/HTML> |
|
|
|
© |
HandleForm.php, |
© |
form.html |
|
. |
|
|
69
|
|
|
|
|
* |
) |
|
© |
|
|
|
* |
|
<HTML> |
|
|
|
|
|
|
<HEAD> |
|
|
|
|
|
|
<TITLE>Inserting Data into a Database</TITLEx/HEAD> |
|
|
||||
<BODY> . . |
|
|
|
|
|
|
<?php |
|
|
|
|
|
|
/* |
|
|
, |
|
|
|
"form.html". */ |
|
|
|
|
|
|
+ |
|
|
* |
|
|
|
$Array["FirstName"] = trim ($Array["FirstName"]); |
|
|
|
|||
$Array["LastName"] = trim ($Array["LastName"]); |
|
|
|
|||
$Array[" Email"] = trim ($Array[ "Email"] ); |
|
|
|
|||
$Array["Comments"] = trim ($Array["Comments"]); |
|
|
|
|||
+ |
|
|
|
* |
|
|
$Host = "localhost"; |
|
|
|
|
|
|
$User = "user"; |
|
|
|
|
|
|
$Password = "password"; |
|
|
|
|
|
|
$DBName = "NewDatabase"; |
|
|
|
|
||
$TableName = "Feedback"; |
|
|
|
|
|
|
$Link = raysql_connect ($Host, SUser, $Password); |
|
|
|
|||
$Query = "INSERT into $TableName values ("0", "$Array[FirstName] |
|
|
||||
"$Array[LastName]"Array[Email]"Array[Comments]")"; |
|
|
||||
print ("The query is:<BR>$Query<P>\n"); |
|
|
|
|||
if (mysql_db_query (SDBName, $Query, $Link)){ |
|
|
|
|||
print ("The query was successfully executed!<BR>\n"); |
|
|
|
|||
} else { |
|
|
|
|
|
|
print ("The query could not be executed!<BR>\n"); |
|
|
|
|||
} |
|
|
|
|
|
|
mysql_close ($Link); |
|
|
|
|
|
|
?> |
|
|
|
|
|
|
</BODY> |
|
|
|
|
|
|
</HTML> |
|
|
|
|
|
|
|
|
Pcec |
ek c |
co |
k |
|
* |
) |
|
© |
|
|
* |
.* |
|
|
OMH |
) |
|
) |
|
|
6jlchn%8 Pb_ko_lscm!Mo_ls->\h&7* |
|
|||
DPIH |
) |
© |
) |
kc |
* |
|
|
|
|
|
|
|
|
1. |
|
|
* |
|
|
|
2. |
|
|
|
* |
|
|
70