5
Php MySQL
: | - MySQL PHP; - ; - phpMyAdmin; - . |
MySQL . MySQL , .
MySQL SQL ANSI 92, , .
MySQL.
1. , .
2. 50 .
3. . MySQL .
4. .
MySQL , .
PHP
.
PHP HTML .
HTML .
<HTML>
<HEAD>
<TITLE> </TITLE>
<BODY>
<CENTER>
?
<P>
<TABLE WIDTH = 400><TR><TD align = right>
<FORM ACTION="email.php" METHOD="POST">
:<BR> <INPUT TYPE="text" NAME="name" SIZE="20" MAXLENGTH="30">
<P>
email:<BR> <INPUT TYPE="text" NAME="email" SIZE="20" MAXLENGTH="30">
<P>
:
<SELECT NAME="preference">
<OPTION value = "">
<OPTION value = "">
</SELECT>
<P>
<INPUT TYPE="submit" VALUE=" !">
</FORM>
</TD></TR></TABLE></CENTER>
</BODY>
</HTML>
request.html. , email.php. :
<?
/* request.html */
PRINT "<CENTER>";
PRINT ", ".$_POST['name'];
PRINT "<BR><BR>";
PRINT " .<BR><BR>";
PRINT " ".$_POST['preference'].",
email: ".$_POST['email'];
PRINT "</CENTER>";
?>
, request.html , email: [email protected] , , " !", email.php, :
|
|
,
.
. email: [email protected]
email.
PHP MAIL.
: void mail(string to, string subject, string message, string add_headers);
to email .
subject .
message .
add_headers ( ).
email.php
<?php
$subj = " ";
$text = " ".$_POST['name']."!
!
".$_POST['preference']."
.
.";
mail($_POST['email'], $subj, $text);
$subj = " ";
$text = $_POST['name']." ".$_POST['preference']." email-: ".$_POST['email'];
mail($adminaddress, $subj, $text);
?>
. .
, - . .
MySQL ( ).
. MySQL, :
>CREATE DATABASE products;
>CREATE TABLE clients (name VARCHAR(25), email VARCHAR(25), choise VARCHAR(8));
MySQL PHP .