how to create photo gallery in php and mysql

Actually prepared to learn the PHP language has been planned for several years, but are busy with some things do not meditate, given the needs of the project, must learn some technology, so ready to the front-end, front-end framework and PHP this backend application gradually learn. According to the previous study progress and habits, or directly to do the project more directly, because the old Chiang himse

As a PHP developer, I was sometimes asked to make a shoutbox. If the same thing happens to you, here's a quick guide. Obviously, you want to add your own CSS to it above, but here's the basic idea.We need a MySQL database table and three PHP files.First, we need a file to save the database information---file #1: mysql.inc.php--- # Simply Shouting-ashoutboxexa

Table One: admin Field: ID (int11) name (VARCHVR) password (VARCHVR) Table II: LO Field: ID (int11) Username (VARCHVR) Sex (VARCHVR) QQ (VARCHVR) Email (VARCHVR) info (text) IP (VARCHVR) submit_time (datetime) 1. conn.php (connect database file) Copy the Code code as follows: mysql_connect ("localhost", "root", "");//Connect to Databasemysql_select_db ("Lyb");//Select Database?> 2. header.php (Common header file) Copy the Code code as follows: Copy the Code code as follows: $counte

Use PHP to link to mysqli, after successful use, Mysqli_query () Create DATABASE and data table.$con = Mysqli_connect ("localhost", "root", "root");if (! $con){Die ("No connection succeeded". Mysqli_error ());};if (!mysqli_query ($con, "CREATE Database Jiangxia")){Die ("No success created". Mysqli_error ());}mysqli_select_db ($con, "Jiangxia");$sql = "

databasesCreating a DatabaseThe CREATE DATABASE syntax is used for creating a data base.Grammar: CREATE DATABASE db_name PHP MySQL function library, the mysql_query () function is used to send and execute SQL statements to MySQL.Create a database named TestDB: TipsCreating a database requir

/*** Created by Phpstorm.* User:administrator* Date:2015/3/31* time:14:40 */Header("Content-type:text/html;charset=utf8");//declaring the encoding format$conn=mysql_connect("localhost","Root","AAAAAA") or die("Database connection Error".Mysql_errno());//ConnectionSQL//$createTable =mysql_query ("CREATE Database Phptest", $conn) or Die ("CREATE TABLE Error:". Mysql_errno ());//

simply edit a file named index.html and put it in the directory to test. Test PHP support Open the editor, create a PHP file, and typeCode: Save the file to the E:/html folder and name it phpinfo. php. Enter http: // 127.0.0.1/phpinfo. php in the address bar of the bro

PHP page has a browse count of 200 concurrent per second, resulting in the insert to the MySQL caused a lot of pressure LNMP environment, the other page content has done a cache, not much load, is the number of browsing statistics function, to the MySQL bring great pressure, I ask you what solution? How to say do not use My