PHP Basic Learning Notes MySQL 2 (15)

Source: Internet
Author: User

Working with Databases in PHP
<?PHP//1: Connect the Database (System): mysql_connect ("Database system name/ip/address", "username", "password")Mysql_connect ("localhost","Root","");//mysql_connect () is a PHP built-in function//2: Set the Environment code to perform the database operation: Here the Environment code actually refers to the current PHP file character encoding. mysql_query ("Set names UTF8");//mysql_query () is also a PHP built-in function//3: Select the database you want to manipulatemysql_query ("Use php0910b");//4: Execute the specific SQL statement (INSERT, delete, UPDATE, select)//mysql_query ("INSERT into UserInfo3 (userName, postcode, fee, age, RegDate) VALUES (' test1 ', ' 101010 ', 180.7, 18, '    2014-10-9 ') "); //in other words, the mysql_query () function can be used to execute almost "all" SQL statements! $sql="Delete from UserInfo3 where id=5";//Typically, a SQL statement (command) is used in the future, usually in PHP with this variable name.            Note that this is a PHP string! //in other words, almost any SQL statement can be written here,$result= mysql_query ($sql);//$result represents the result of the mysql_query statement execution, here is a "true and false" value, which is a Boolean value//If the result is true, indicates that the statement executed successfully//If the result is false, it indicates that the statement execution failed.                                        if($result = =true) {echo"Successful Execution! "; }    Else{echo"execution failed. We apologize, please contact the administrator. Code Error reference information:"  .            Mysql_error (); //mysql_error () is used to get the error message when the last SQL statement failed to execute.     }?>

How data is submitted (delivered)

Only two: Post,get.

mode one: Post     <form action "abc.php"  method= "POST" >        <input type= "text" name= "S1"/>        <input type= " Text "name=" BB "/>    </form>     gets (receives) its data in PHP in the way:  $_post[' data item name value '];

Way two: Get

The Get method commits (passes) data in several forms:

Form 1:

    <form action "abc.php"  method= "get" >        <input type= "text" name= "S1"/>        <input type = "text" name= "BB"/>    </form>

The way in which to get (receive) its data in PHP is: $_get[' data item's name value '];

Form 2:

<a href= "ABC.PHP?S1=5&BB=18&CC=ABCD" >go go go</a>

Previous Line Description: The link will be delivered from the current page (submit) 3 data to abc.php this page, the first data name is S1, the value is "5", the second data is named BB, the value is "18", the 3rd data name is CC, the value is "ABCD".

Get (receive) its data way: $_get[' data item name ']

Form 3:

    <script>            = "abc.php?s1=5&bb=&cc=abcd";         </script>         Description: In fact, Form 3 is a variant of 2 forms, the same way. 

PHP Basic Learning Notes MySQL 2 (15)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.