,,,
. . .
:
, 2010
( - ). MYSQL (PhpMyAdmin) , .
I. - ()
1.1
1.1.1
1.1.2
1.1.3
1.2
1.3
1.4
1.5
1.5.1
1.5.2
1.5.3
1.5.4
1.6
II.
2.1.
2.1.1
2.1.2
2.1.3 :
2.2.
( - ). . , . . . , .
MYSQL (PhpMyAdmin) , .
, :
, , ;
- ;
;
;
.
, :
, ;
;
() ()
-
/
I. - ()
2000 , . -, -һ, , - . -һ (2000 .), , , . -һ, - , , . , , . .
, , . . - . - 10 IBM PC Pentium 1 . (), . , 2000 -һ, , -, -һ, . , . . Web- . -, , , . , . . 13-16- . 50 , , 160 , . . 2000 CADA , 2001/2002 . . 135 . . . (. www.cit.tj). Visual Basic 6 . . 350 , . , , , .. 2000 . Windows 2000 Windows , . . - , , . - Palatino Linotype. . , , . , . . . 2001 , , -һ , . - , , , . -, . , .
2001 , , , . , . , , , . , -һ, , .
2004 . . - . 29 2004 . -һ (. 001-1455, 0007038 ) .
, , . .
, , , . . , . : , Web , , , .. , , (). ( 4 5 ) , . . , -һ -̻ . 2001 18 . 2007 . , -̻. , - , . . .
:
2000 . 2008 . 1756 .
. Visual Basic 6 Pascal Delphi. Linux Mandrake 10, . , .
, -һ -̻, . IBM PC Pentium IV. - . . , . . , .
www.cit.tj . , , , . . , .. :
., (on-line);
;
(on-line);
(on-line) ;
, , .
(. top.mail.tj ).
2006 . . . . . , , . . - .
. , . , . , .
1.1
:
;
;
() .
:
;
.
() , . , ( .. ), , . , .
. (): , .
1.1.1
, - . 500 . , , ., - . ( , ..), , , . , .. , , .. , . - :
|
- ;
- ;
- ;
- ;
- .
1.1.2
.
2- . .
:
- - ( 6- );
- ( , , ).
8 . 6 .
; 8 .
, .
.
, . :
;
, 2 .
- ( ) - .
- , . :
- ;
- - ;
, , . :
;
.
, .
1.1.3
, .
() - , , .
( ). , , , .
. , . , , . , : , , . . , .
. .
, , , . . , , , .
, , .. - ().
, , : , , , , -, .
:
1. - .
2. .
3. .
4. , .
, :
1. .
2. .
3. - .
4. .
5. .
6. - .
7. - .
, , , .
:
- ;
-
- ;
- ;
, . . 1.3.1 .
.1.3.1.
1.2
: . , . , (, - ).
, , .
- , , .
:
1. - .
2. .
3. .
4. , .
, :
1. .
2. .
3. - .
4. .
5. .
6. - .
7. - .
, , , .
:
- ;
-
- ;
- ;
- , , .
:
;
;
;
;
;
;
1.3
() .
1.4
() , , , , .
, 1.2.2 , .
, , 40 . , 20 , 40 . .
1.4.1:
1.4.1
, . | |
Pentium IV | 40 |
/ | 40 |
4 | |
4 | |
12 | |
- | 10 |
1.5
. .
,
. ,
, , , , , .
1.5.1
, 30 , 185 (). . .
, 21 10 .
1.5.2
, . :
, :
, , ;
;
, ;
, , CD-ROM .., , ;
, , .
, :
1. ;
2. .
, .
:
;
:
;
;
;
;
.
1.
: . , , ; , , . , .
|
. 1.4.1.
. , 10 .
:
10 ;
;
;
, , .
, .
2.
10 , , , , . .
. 1.4.2.
. , .
. , , , .
, , . . , , , .
, , . , , Windows 2000 Server, : .
, .
, . - , , 486 8 16 .
3.
, . , , .
, .
, , 10, . , , , .
.
, , , .
1.5.3
, . , ( , ), - .
. , :
;
;
;
.
, . . , . . , .
:
(.1.4.3 );
(.1.4.3 );
(.1.4.3 ).
|
|
|
.1.4.3.
(), . , , , , . , , , .
, , .
1. (.1.4.3 )
. , , .
. , , , . .
, , . , .. , , . , , :
;
, ;
;
;
.
, .
2. (.1.4.3 )
, . . , , , .
- , - . , , . ( , ), . .
3. (.1.4.3 )
, . . , , . , , .
. , , . . 200 10 000 .
8 60 .
, , , . , , . .
:
;
.
, , .
1. -
. 1.4.4. -
- . : . - . .
-
|
. 1.4.5. -
, - , .
3.
. 1.4.6.
. , ; (. 1.4.6). , .
, . . .. , , , ,
- . - , ( ) , .
. 1.4.7.
, , , - λ , , .. .
1.5.4
, , , , . , Microsoft (Word, Excel, Access PowerPoint) , Windows. Microsoft Windows. Microsoft (ASP, ActiveX, NET, MS SQL ) .
OS/2 Unix, , . , , , Windows, .
UNIX- Windows - . UNIX- , Windows , .
Windows . , , , , .
, Windows , :
: , Windows, .
: Windows .
.
: .
: Windows .
Windows 2000 Server , Windows 2000, , , - .
Windows 2000 Server , Windows, , , .
, Windows 2000 Server .
, , , , Windows 2000 Server .
1.6
, , , , .
() . , . -/.
, -/ , , .
II.
2.1
. , , . , , , . PhpMyAdmin.
, PhpMyAdmin (). PhpMyAdmin , . PhpMyAdmin , , .
PhpMyAdmin . Microsoft Windows. , PhpMyAdmin
, .
, :
, ;
, , ;
(, ), . , ;
( , . .). , ;
( , , ).
, , , . , .
Ms Access :
. . ;
. - ;
. , , ;
. , , ;
- Web-, , Microsoft Access MS SQL Server;
- , ;
- , Visual Basic, .
- . , . . , (, ), , .
, PhpMyAdmin (mysql) . , . . , MySql . 7 :
1-
2-
3-
PhpMyAdmin ,
. ,
,
, , .
, :
( 255 );
- ( 1, 2, 4 8 );
/ (8 );
( 1) (4 );
1-
2-
3-
()
2.1.1
, . , .. , . , . , . .
. , . , , .
2.1.2 :
<form method="post">
<input type="text" name="ahmad" size=30><input type="text" name="hmad" size=30><select name="mad" ><option value=""></option><option value="1 ">1 </option><option value="2 ">2 </option><option value="3 ">3 </option></option></select>
<input type="submit" value=""></form>
<? @$rs=$_POST["ahmad"];
@$rr=$_POST["hmad"];
@$rf=$_POST["mad"];
@$db=mysql_pconnect("localhost","root");
if(!$db){
echo" ";
exit;}
mysql_select_db("log1");
if($rf=="")
{echo" ";}
else
{if($rf=="1 "){
$query="select * from avto where ='$rs' && ='$rr'";
$result=mysql_query($query);
$num_result=mysql_num_rows($result);
if($num_result==0) echo"<font color=red><b> !"."</b></font>"."";else
echo "<B> :</b>"." "."<b>"."$num_result"."</b>"."<BR>";
for($i=0;$i<=$num_result;$i++)
{$row=mysql_fetch_array($result);
echo "<h4>".$row[""]." ";
echo $row[""]." ";
echo $row[""]." ";
echo $row[""]." ";}
$i=0;
if($rs==""){echo$i+=1;}}
if($rf=="2 ")
{$qury="select * from avto2 where ='$rs' && ='$rr'";
$reslt=mysql_query($qury);
$nm_result=mysql_num_rows($reslt);
if($nm_result==0) echo"<font color=red><b> !"."</b></font>"."";else
echo "<B> :</b>"." "."<b>"."$nm_result"."</b>"."<BR>";
for($i=0;$i<=$nm_result;$i++)
{$row=mysql_fetch_array($reslt);
echo "<h4>".$row[""]." ";
echo $row[""]." ";
echo $row[""]." ";
echo $row[""]." ";}
$i=0;
if($rs==""){echo$i+=1;}}
if($rf=="3 ")
{$qury="select * from avto3 where ='$rs' && ='$rr'";
$reslt=mysql_query($qury);
$nm_result=mysql_num_rows($reslt);
if($nm_result==0) echo"<font color=red><b> !"."</b></font>"."";else
echo "<B> :</b>"." "."<b>"."$nm_result"."</b>"."<BR>";
for($i=0;$i<=$nm_result;$i++)
{$row=mysql_fetch_array($reslt);
echo "<h4>".$row[""]." ";
echo $row[""]." ";
echo $row[""]." ";
echo $row[""]." ";}
$i=0;
if($rs==""){echo$i+=1;}}}?>
:
<?php
@$F=$_POST["F"];
@$I=$_POST["I"];
@$X=$_POST["X"];
@$rf=$_POST["mad"];
@$db=mysql_pconnect("localhost","root");
if(!$db)
{echo" ";
exit;}
mysql_select_db("log1");
$table_name ="avto";
if($rf=="")
{$sq = "UPDATE `avto` SET = '$X' WHERE = '$F' && = '$I'";
$result=mysql_query($sq);}
if($rf=="")
{$sq = "UPDATE `avto` SET = '$X' WHERE = '$F' && = '$I'";
$result=mysql_query($sq);}
if($rf=="")
{$sq = "UPDATE `avto` SET = '$X' WHERE = '$F' && = '$I'";
$result=mysql_query($sq);}?>
2.1.3 :
<?php
@$login=$_POST["login"];
@$password=$_POST["pass"];
@$db=mysql_pconnect("localhost","root");
if(!$db)
{echo" ";
exit;}
mysql_select_db("log");
$query="select * from avto where login = '$login' and password = '$password'";
$result=mysql_query($query);
$s=mysql_num_rows($result);
if(!$s)
{header("Location:error.php");}
else {("Location:aut.php");}
?><center><br><br><br><br><br><br><br><br><br><h4><a href="kurs.php"> </a></h4><br>
<a href="poisk.php"> </a></h4><br>
2.2
, . PhpMyAdmin (Mysql) PhpMyAdmin.
Auto, . . , . () . . .
, . ;
;
, , ;
.
.
: data mysql,
. . .
. , . .
1.
2. PhpMyAdmin
. . . :
Copyright (c) 2024 Stud-Baza.ru , , , .