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="//m.sbmmt.com/m/faq/index.html"; } }); } } );

Back-end php page:

=100) echo "一等奖"; if($score<100&&$score>=60) echo "二等奖"; if($score<60) echo "三等奖"; exit; } } ?>

Note: We need to run the php file Usephp 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!