How to store data in the database in phpstudy

phpstudy's method of storing data in the database:

(1) Connect the background file to the database

(2) Receive the form data and build sql statement

(3) Execute the sql statement and observe the execution result

Example:

The user name and mobile phone number entered by the user on the front-end page, click Submit The terminal determines whether the mobile phone number already exists. If it does not exist, insert it into the database and return the insertion result (when the insertion is successful) to the previous page.

Requirement analysis:

1. Create an html page to enter the user name and mobile phone number, and create a php page to process the data;

2. Write and submit data in the html page The js script uses ajax to submit data to the php page;

3. The php script receives the data submitted by the html page and queries whether the mobile phone number already exists in the database;

4. If the mobile number already exists in the database If a mobile phone number exists, the insertion failure message will be returned;

5. If the mobile phone number to be added does not exist in the database, then the user name, mobile phone number and other data will be inserted into the database, and a message of successful data addition will be returned.

Sample code:

Sample code for ajax request in the front-end html page

function submit_result() {             
                $.post(
                    "Controllers/ajaxController.php",
                    {
                        "name": $("#name").val(),
                        "mobile": $("#mobile").val(),
                        "score": $("#sp_score").html()
                    },
                    function(msg) {
                        if (msg == "0") {
                            layer.open({
                                content: '您已参与过该活动，下次再参与哦！',
                                btn: ['知道了']
                            });
                        } else {
                            layer.open({
                                content: '恭喜您，获得了，'+msg,
                                btn: ['知道了'],
                                end:function(){
                                    location.href="index.html";
                                }
                            });
                        }
                    }    
                );

Back-end php page:

<?
//1. 声明字符编码
header("Content-Type:text/html;charset=utf8"); 

//2. 连接数据库
$link=mysql_connect("localhost","root","root");//连接数据库
if(!$link) echo "系统异常，请稍后再试";//如果连接数据库失败
mysql_select_db("test", $link); //选择数据库
mysql_query("set names &#39;utf8&#39;");  // 解决中文乱码

//3. 获取数据
$name = $_POST["name"];
$phone = $_POST["mobile"];
$score=$_POST["score"];

//4. 查询手机号码是否存
$strsql = "select phoneNumber from user_info where phoneNumber=&#39;$phone&#39;";
mysql_query("SET NAMES utf8");
$result=@mysql_query($strsql);//执行查询
$row=mysql_fetch_array($result);//获取数据行

//5. 根据是否返回数据行，如果数据行为空，即已参与活动，否则返回获得奖励等级
if(!empty($row)){
    //5.1 数据行不为空，返回0
    echo 0;
}else{
    //5.2 数据行为空，手机号码没有参与活动，插入数据到数据库
    $strsql = "insert into user_info(userId,userName,phoneNumber,userScore,dataTime) values(null,&#39;$name&#39;,&#39;$phone&#39;,&#39;$score&#39;,now())";
    $result = @mysql_query($strsql);
    
    //5.3. 成功添加
    if($result)
    {
        if($score>=100) echo "一等奖";
        if($score<100&&$score>=60) echo "二等奖";
        if($score<60) echo "三等奖";
        exit;
    }
}
?>

Note: We need to run the php file Use php server.

The above is the detailed content of How to store data in the database in phpstudy. For more information, please follow other related articles on the PHP Chinese website!