How to quickly create dynamic web pages through html+css+mysql+php

Let me introduce to you how to quickly create dynamic web pages through html css mysql php. Let us set out to explore the unknown mysteries together! ! !

1. Construction of development environment

（1）apache php mysql environment construction

Because Apache is used as the server, MySQL is used as the database to store data, and PHP is used to write code to realize the interactive data between the web page and the database, so the above software needs to be downloaded, but the installation environment of the above software , configuration is very troublesome, so here I use a powerful website building integration software package---XAMPP,

    (2) Database client software navigat

It is inconvenient and not straightforward enough to operate the database directly on the cmd command console. Of course, you can also directly use phpmyadmin to operate it (after installing the above xampp software package, enter 127.0 in the browser .0.1/phpmyadmin can be opened), but phpmyadmin is inconvenient to operate. Here we use the database client Navicat

produced by Oracle. Click on the connection and enter the connection name. (Here I took it directly. The name of the IP address is 127.0.0.1), the host name and port number do not need to be changed, the user name and password here are. If you are using xampp, then the username is root and the password is empty; if you are not using xampp to install it, just log in according to the username and password you set. After filling in, click the connection test. If there are no problems, you can directly connect to the database.

## In addition, if you want to master the database, simply speaking any operation of the database, you must operate the SQL statement. In general, it is divided into four operations: increase Delete, modify and check.

①Add: Write data to the database

Statement: insert into users (`username`,`password`) values ​​('name','passwd')

(PS novices must pay attention to the `` symbol behind the users data table, which is a quotation mark above the tab key, and the one after values ​​​​is a single quotation mark)

②Delete: Delete existing data

Statement: delete from users WHERE id='3'

③Change: Modify data

Statement: update set users username='new value', password='new value' WHERE id=3

④Check: Read data from the database

Statement: select * from users where id>1 order by id desc limit 0,2

(3) HTML web page writing tool sublime text

Sublime Text is a code editor (Sublime Text 2 is a paid software, but it can be tried indefinitely), and it is also an advanced text editor for HTML and prose. device. Sublime text has a beautiful user interface and powerful functions, which is very suitable for programmers who write code.

                                                                                                                                                                                                                                  Using sublime text to write web page code, you can master this little trick, first create a new file, save the format as html web page format, and then in Open it in sublime text, enter html:4s and press the tab key to generate the general frame. Of course, if you want to use this shortcut key, you must follow the link I gave above and follow the steps to install the Emmet plug-in before you can use it.

（

4）Configuration of website domain name

Generally speaking, when you open the URL 127.0.0.1 in the browser, it will be redirected to apache A URL in the default directory. Here I modify it and change it to the directory where I do the project, E:\PHP

\xampp\apache\conf , open the httpd.conf file, and change the path inside to the directory where you store the website. Here I changed it to DocumentRoot "E:/php

/xampp/workplace"

Here you should pay attention to modify the path to your own directory according to your own download. Secondly, I also modified the 127.0.0.1 URL again to make its virtual domain name blog.com. After modification, after restarting, Enter blog.com in the browser, and the following scene will appear:

Here I found the DNS configuration I modified, and I don’t know when I added a comment in front of it. , resulting in the inability to open it. Everyone should also pay attention to configuring the connection according to the connection I gave. If it cannot be opened, check the configuration file for errors.

In short, the configuration environment and tools have been basically set up successfully. Next, I will start to explain the blog project.

2. Writing the blog website

1. Overall framework

First of all, let me introduce my overall structure here Let me explain the framework so that everyone can get familiar with it first.

Blog is the name of the project, the admin folder stores the background login file, the core folder stores the core files, and the theme folder stores the style files of the web page upfiles folder It stores the image information uploaded from the local to the server. Then the config.php file is the configuration file of the entire blog website. The header.inc.php loads a page style information. The index.php file is the homepage of the website. The read.php file It is a specific link to the article on the homepage of the website.

The design of the database table is given here for your reference and study. Here I mainly created three tables. The admin representation is used to store background administrator registrations. And login data, that is, account and password:

get('do')=='check'){
	 	/*获取页面提交的用户名和密码数据*/
	 	$ausername=$input->post('ausername');
	 	$apassword=$input->post('apassword');

	 	/*查询页面提交的数据是否在数据库提供的数据存在的sql语句*/
	 	 $sql="select * from admin where ausername='{$ausername}' and apassword='{$apassword}' ";
	 	 /*数据库查询语句返回结果*/
	 	 $mysqli_result=$db->query($sql);
	 	 /*以数组形式存储数据库查询语句的返回结果*/
	 	 $row=$mysqli_result->fetch_array( MYSQLI_ASSOC);
	 	 /*如果row确实返回了结果，则将结果的aid存储在session里，并转向home.php文件*/
	 	 if(is_array($row)){
	 	 	$_SESSION['aid']=$row['aid'];
	 	 	header("location:home.php");
	 	 }else{
	 	 	echo("账户或密码错误");
	 	 }
	 }
?>





	
	
	
	
	




	
	

		
		

			
			

			
			

			 
			    

			    	
			  		
管理员登录
			  		
			  		

			    		
			    		

							
							

						    	用户名
						    

						      	
						    
						    

							
							
						    

						    	密码
						    

						      	
						    
						    

							
							
						    

						    

						    
						    

						      	
						    
						    
							

								 
							
							

			    		

						

					

					 
			  		 
版权所有，盗版必究
			    

			
			

			
			

		

	

	
	
	
	

get('do')=='check'){
		/*获取用户页面注册传来的用户名和密码数据*/
		$ausername=$input->post('ausername');
		$apassword=$input->post('apassword');
		$aconfirmpassword=$input->post('aconfirmpassword');
		/*注册时的处理*/
		if($apassword!=$aconfirmpassword){
			echo "前后两次输入的密码不一致";
			exit;
		}
		/*将用户填入的数据插入到数据库的sql语句*/
		$sql="INSERT INTO admin(`ausername`,`apassword`) values('$ausername','$apassword')";
		/*提交sql语句到数据库处理*/
		$is=$db->query($sql);
		/*判断是否注册成功*/
		if($is){
			echo "注册成功";
			header("Location:login.php");
		}else{
			echo "注册失败";
		}
	}


?>







	
	
	
	
	



	
	

		
		

			
			

			
			

			 
			    

			    	
			  		
管理员注册
			  		
			  		

			    		
			    		

							
							

						    	用户名
						    

						      	
						    
						    

							
							
						    

						    	密码
						    

						      	
						    
						    

						    
						    

						    	确认密码
						    

						      	
						    
						    

							
							
						    

						    

						    

						      	
						    
						    

			    		

						

					

					 
			  		 
版权所有，盗版必究
			    

			
			

			
			

		

	

	
	
	
	

get('pid');
	/*初始化page，为了区别添加还是修改操作*/
	$page=array(
			'title'   => '',
			'author'  => '',
			'content' => '',
		);
	/*如果pid大于0，可以得出并不是添加操作，而是修改操作*/
	 if($pid>0){
	 	$sql="select * from page where pid ='{$pid}' ";
	 	$res=$db->query($sql);
	 	$page=$res->fetch_array(MYSQLI_ASSOC);
	 }



	 /*对于添加操作操作而言，账户或密码不能为空*/
	if($input->get('do')=='add'){
		$title=$input->post('title');
		$author=$input->post('author');
		$content=$input->post('content');
		if(empty($title)||empty($author)||empty($content)){
			echo("数据不能为空");
		}
		/*如果aid大于1，则得出更新操作，否则执行添加操作*/
		if($pid>0){
			$uptime=time();
			$sqlTpl="UPDATE page set title='%s',author='%s',content='%s',uptime='%d' where pid='%d' ";
			$sql=sprintf($sqlTpl,$title,$author,$content,$uptime,$pid);
		}
		else{
			$intime=time();
			$sqlTpl="INSERT INTO page(`title`,`author`,`content`,`intime`,`uptime`) values('%s','%s','%s','%d','%d')";
			$sql=sprintf($sqlTpl,$title,$author,$content,$intime,0);
			
		}			
		/*判断是否有结果*/
		$is=$db->query($sql);
		if($is){
			header("location:blog.php");
		}else{
			echo "执行失败";
		}
	}
?>





	
	
	

	
	
	
	
	
	




	
	

	
 博客管理 返回
	

		

			

			  

			    标题
			    

			      '>
			    
			  

			  

			    作者
			    

			      ' >
			    
			  


			  

			    正文
			    

			     	<?php echo $page['content'];?>
			     	
								     	
			    
			  

			  
			  

			    

			      提交
			    
			  

			
			
		

	

 true,
				'msg'     => '',
				'file_path'=>$urlName
				);
			echo json_encode($json);
		}
	}
?>

The above is the detailed content of How to quickly create dynamic web pages through html+css+mysql+php. For more information, please follow other related articles on the PHP Chinese website!