Mysql and php dynamic website development introductory tutorial, mysql website development

This series of tutorials starts with the form, because the form can integrate the interaction between the database and the web It's obvious. Submit the form and the database records the registration information.

This tutorial is a basic tutorial. God, please skip it. The stability between php and mysql is very popular among programmers. Although the hack language has recently appeared to replace the php language, this language itself is also based on php. We can learn the hack language later. There seem to be a lot of big names in the blogging community. I don’t know if they will be criticized. I’m so scared....... Of course, I took advantage of my own motivation to learn and recorded the learning process. The tutorial involves html form, simple php and mysql. Use the simplest form first and understand the interaction between them. I remember that when we didn’t understand anything and the code was unclear, we were thinking about the fantasy world of code and felt extremely wonderful. When we stepped into the world of code, we felt at a loss again. What is the code. Let’s start with html. Of course, if you don’t understand html, you won’t come to the blog park. Just to put it casually, right-click in the browser and view the source code. The code is html. But it is just the structure of a web page. Of course, a lot of things are needed to form a beautiful web page. I will talk about other things when I have a chance. This time I will talk about the interaction between web pages. That is, the development of dynamic websites. If you don’t know the form, search it. It’s that time of registration, those frameworks. The following is the form code.

<span><span><</span><span>form </span><span>action</span><span>='index.php' </span><span>method</span><span>='post'</span><span>>  //这里的index.php 就是一个动态传送的文件。后面会说。</span>
<span><</span><span>p</span><span>></span>please type your first name:<span><</span><span>input </span><span>type</span><span>="text"</span><span> name</span><span>="first_name"</span><span> value</span><span>=""</span><span>></</span><span>p</span><span>></span>
<span><</span><span>p</span><span>></span>please type your second name:<span><</span><span>input </span><span>type</span><span>="text"</span><span> name</span><span>="second_name"</span><span> value</span><span>=""</span> <span>></</span><span>p</span><span>></span>
<span><</span><span>p</span><span>></span>please type your age:<span><</span><span>input </span><span>type</span><span>="text"</span><span> name</span><span>="age"</span><span> value</span><span>=""</span><span>></</span><span>p</span><span>></span>
<span><</span><span>p</span><span>><</span><span>input </span><span>type</span><span>="submit"</span><span> name</span><span>='submit' </span><span>value</span><span>='register'</span><span>></</span><span>p</span><span>></span>
<span></</span><span>form</span><span>></span></span>

Copy after login

It’s just this string of code. After saving it, the webpage is opened, and only the box is in . Clicking it is of no use. Of course, this is the front end. The backend we are talking about today. What you need is to transfer the input part to the so-called database and save it, so as to facilitate website management. How was it passed on? Here we have to talk about php and mysql. Note: When running php and mysql, an environment is required. There must be a basis for their operation. Their environment, otherwise how would they survive. Right? Then there is the famous one piece kit package. These environments are included. Next step Next step Just install it. Address: http://apmserv.s135.com/ Respect the original address. It seems that Windows 8 cannot be installed. Why. . . After installation, let’s get familiar with it first. Well ~~ php is in the code area Write php code in the middle. The file is in .php format, and html language can be added to it. Well, put the form in. Put it in and access it the same as before. Then make it dynamic. Add a few variables.

<span><span><</span><span>p</span><span>></span>please type your first name:<span><</span><span>input </span><span>type</span><span>="text"</span><span> name</span><span>="first_name"</span><span> value</span><span>="<? if(isset($_REQUEST['first_name'])) echo $_REQUEST['first_name'];?>"</span><span>></</span><span>p</span><span>></span>
<span><</span><span>p</span><span>></span>please type your second name:<span><</span><span>input </span><span>type</span><span>="text"</span><span> name</span><span>="second_name"</span><span> value</span><span>="<? if(isset($_REQUEST['first_name'])) echo $_REQUEST['second_name'];?>"</span> <span>></</span><span>p</span><span>></span>
<span><</span><span>p</span><span>></span>please type your age:<span><</span><span>input </span><span>type</span><span>="text"</span><span> name</span><span>="age"</span><span> value</span><span>="<? if(isset($_REQUEST['age'])) echo $_REQUEST['age'];?>"</span><span>></</span><span>p</span><span>></span>
<span><</span><span>p</span><span>><</span><span>input </span><span>type</span><span>="submit"</span><span> name</span><span>='submit' </span><span>value</span><span>='register'</span><span>></</span><span>p</span><span>></span></span>

Copy after login

Hmm, a very familiar form. Then you need to store the input in that variable. Here we are going to talk about php arrays. In php arrays, you can use string arrays. It's array['name'] and name can be something you define. The form here is very special. This REQUEST is a super-global variable. It seems cool. Even if it doesn’t need to be defined, it is always there. The name of the form is placed in it, and the input is The content is saved in this array. Of course, you can also use $_POST['name']. This Post is a subset of REQUEST. Anyway, this expression is the same. Then all your data is saved in this array, and then it is very convenient to extract it. In the middle, it is used to judge whether the data is filled in, and then returned. This isset() is to judge whether the data is filled in. , and then it will be the same as the html form. You still have to judge whether the data has been filled in. You have to make a judgment. There is the following paragraph.

<span><span>$error</span>=<span>array</span><span>();
</span><span>if</span> (<span>empty</span>(<span>$_REQUEST</span>['first_name'<span>])) {
     </span><span>echo</span> '<p>you forget type your first_name;<p>' ;<span>#</span><span> code...</span>
     <span>$error</span>='1'<span>;
}
</span><span>else</span><span>{
     </span><span>$f</span>=<span>$_REQUEST</span>['first_name'<span>];
}

</span><span>if</span> (<span>empty</span>(<span>$_REQUEST</span>['second_name'<span>])) {
     </span><span>echo</span> '<p>you forget type your second_name;<p>' ;<span>#</span><span> code...</span>
     <span>$error</span>='2'<span>;
}
</span><span>else</span><span>{
     </span><span>$s</span>=<span>$_REQUEST</span>['second_name'<span>];
}

</span><span>if</span> (<span>empty</span>(<span>$_REQUEST</span>['age'<span>])) {
     </span><span>echo</span> '<p>you forget type your age;<p>'; <span>#</span><span> code...</span>
     <span>$error</span>='3'<span>;
}
</span><span>else</span><span>{
     </span><span>$a</span>=<span>$_REQUEST</span>['age'<span>];
}</span></span>

Copy after login

This empty() is used to determine whether it is empty, and echo is the output of php. You can also output html. Define an error array It is to judge whether there are any errors, if everything is filled out. It’s ok. Then save those variables into other variables. This looks simpler. Well, then I found that there was no error. Then return to this section. Well, this section is the most important part, which is used to connect to our database.

<span><span>if</span><span> (empty($error)) {
     echo</span><span>'</span><span><p> everything is ok<p></span><span>'</span><span>;
     require(</span><span>'</span><span>connect/mysqli_connect.php</span><span>'</span><span>);
     $q</span><span>=</span>"<span>insert</span> <span>into</span> <span>user</span> (first_name,second_name,age) value(<span>'</span><span>$f</span><span>'</span>,<span>'</span><span>$s</span><span>'</span>,<span>'</span><span>$a</span><span>'</span><span>)";
     $r</span><span>=</span><span>@mysqli_query</span><span>($dbc,$q);
}</span></span>

Copy after login

那个require( )就是需要连接数据库的文件。数据库的地址啊，表名啊，用户名啊，密码啊，靠这些联系数据库。这个文件就换一个地方去了.直接调用它过来连接就行了。就是require了。这个就是 mysqli_connect.php了.

<span><?
<span>$dbc</span>=@<span>mysqli_connect</span>(localhost,root,123,<span>test);
</span>?></span>

Copy after login

尽量简单一点，哈哈好短的文件，这个文件就保存在index.php 的同一目录下的connect 文件夹里面. 里面有一个函数 mysqli_connect() 这个函数就是连接数据库用的呀。 mysqli_connect(hostname,username,password,databasename) 数据的地址名一般都是localhost 了，当然也不一定。看你的数据库在哪。然后就是账户，密码，数据库名。然后它返回的保存在一个变量里面。ok了调用，然后就连上数据库了下面又定义一个$q，这就又说到了数据库的知识了，在数据库中，你要创建数据库呀，表名呀，列呀，然后一一匹配的把刚才那些变量传送过去。恩，这就说说数据库了。恩~~ 啊~~。数据库管理现在好多都是 phpadmin之类的东东了，好像很方便的样子。在那个东东里面，有个sql 命令的地方，你要输入点小命令，创建刚才说的那些东东。先来创建一个数据库吧。输入的是 create database test; 这就创造了一个数据库。 test是数据库的名字了。很简单样子。下面就是创建表名了。还是用create

<span><span>create</span> <span>table</span> <span>user</span><span>(
          first_name </span><span>varchar</span>(<span>20</span>) <span>not</span> <span>null</span><span>,
          second_name </span><span>varchar</span>(<span>20</span>) <span>not</span> <span>null</span><span>,
          age </span><span>varchar</span>(<span>20</span>) <span>not</span> <span>null</span><span>

);</span></span>

Copy after login

写程序一定要注意一些分号呀，冒号呀，逗号啊等等。注意这些在哪个地方，怎么用，中文和英文版的分号的区别呀，要不然就出错了。这个就是创造表名和列名了。这个东东 varchar(20) 你就要查 mysql数据类型了。就是定义它是个什么类型的数据了前面就是列名了。这样就创造了一个user表名三个列名 first_name second_name age ; 好了数据传送过去

<span>   $q<span>=</span>"<span>insert</span> <span>into</span> <span>user</span> (first_name,second_name,age) value(<span>'</span><span>$f</span><span>'</span>,<span>'</span><span>$s</span><span>'</span>,<span>'</span><span>$a</span><span>'</span>)";</span>

Copy after login

就是这个东东了 ,insert into user ( , , , ,) value( , , , , ,); 插入恩插入这些数据进入。一一对应前面是列名后面就是它的值了。后面不就是刚才保存的变量吗恩。输入的东东就进去了。

<span>$r<span>=</span><span>@mysqli_query</span>($dbc,$q);</span>

Copy after login

这个函数也很重要。 mysqli_query( ) 前面是那个连接，后面参数是查询本身。这样就连接上了。咚咚咚 ~~~ 运行起来了。。你输入东西到表单上去。Then click Submit, then refresh the database. Do you find that there are too many column names? The whole code is the main index.php below

Mysql and php dynamic website development introductory tutorial, mysql website development_PHP tutorial

include('includes/header.html'); echo '

this is a test

'; $error=array(); if (empty($_REQUEST['first_name'])) { echo '

you forget type your first_name;

' ;# code... $error='1'; } else{ $f=$_REQUEST['first_name']; } if (empty($_REQUEST['second_name'])) { echo '

you forget type your second_name;

' ;# code... $error='2'; } else{ $s=$_REQUEST['second_name']; } if (empty($_REQUEST['age'])) { echo '

you forget type your age;

'; # code... $error='3'; } else{ $a=$_REQUEST['age']; } if (empty($error)) { echo'

everything is ok

';# code... require('connect/mysqli_connect.php'); $q="insert into user (first_name,second_name,age) value('$f','$s','$a')"; $r=@mysqli_query($dbc,$q); } ?>

View Code

The mysqli_connect.php file under connect in the same directory.

Inside is

<? $dbc=@mysqli_connect(localhost,root,123,test); ?> View Code

There should also be a header.html file in the includes folder in the same directory. This is casual.

Well, this interaction is formed. There are still a lot of things that I haven’t added yet, so I’ll keep it simple today. that's all. There are also things like bug reports. The form will gradually improve all functions in the future. Yeah, not bad. There are a lot of things to do next. Well, let’s talk about it later. Reference: larry Ullman "PHP and MySQL for Dynamic Web Sites visual quickPro Guide forward Edition" "Dynamic website development with php and mysql"

"PHP+MySQL+Dreamweaver 8 dynamic website development from basics to practice" News release system background management password?

Try it. The username and password are both admin. Can you upload your login.php code and let me help you find it?

Mysql and php dynamic website development introductory tutorial, mysql website development_PHP tutorial

Mysql and php dynamic website development introductory tutorial, mysql website development

"PHP+MySQL+Dreamweaver 8 dynamic website development from basics to practice" News release system background management password?

Error message