How to add data to database in php

php method to add data to the database: 1. Declare character encoding; 2. Connect to the database; 3. Get data; 4. Through "insert into user_info (userId, userName, phoneNumber, userScore)..." Just insert data.

The operating environment of this article: windows7 system, PHP7.1 version, DELL G3 computer

How does php add data to the database?

php adds data to the database

Front-end code:

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";
                                }
                            });
                        }
                    }    
                );

PHP code

<?
//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;
    }
}
  
 
?>

Recommended study:《PHP video tutorial》

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