+--------------------------+---------------------------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------------------------+
| character_set_client | cp1251 |
| character_set_connection | cp1251 |
| character_set_database | cp1251 |
| character_set_filesystem | binary |
| character_set_results | cp1251 |
| character_set_server | cp1251 |
| character_set_system | utf8 |
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+---------------------------------------------------------+
PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- <html>
- <head>
- <title> СУБД </title>
- </head>
- <body bgcolor="lavender">
- <h1>
- <font><i><b>
- Электронный секретариат 1.0
- </b></i></font>
- </h1>
- <img src="C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\site\images\images.jpg"/>
- <FORM ACTION="HandleForm.php">
- First Name <INPUT TYPE=TEXT NAME="FirstName" SIZE=20xBR>
- <INPUT TYPE=SUBMIT NAME="SUBMIT" VALUE="Submit!">
- </FORM>
- <?PHP
- $hostname = "localhost";
- $username = "root";
- $password = "123";
- $database = "el_secretariat";
- print "Вы подключены к базе данных MySQL!<br>";
- $query = "SELECT * FROM `Person_tbl`";
- {
- echo "ФИО: ".$row['FIO']."<br>\n";
- echo "Дата рождения:".$row['DateBorn']."<br>\n";
- echo "Домашний адрес:".$row['HomeAddress']."<br><hr>\n";
- }
- ?>