[php] use XAMPP to build a local server, and then use the iOS client to upload data to the local server (three. PHP-side code Implementation)
Last Update:2016-03-12
Source: Internet
Author: User
<span id="Label3"></p><p><p>I. Installing XAMPP http://www.cnblogs.com/lidongxu/p/5256330.html</p></p><p><p>Two. Configure MySQL Http://www.cnblogs.com/lidongxu/p/5256515.html</p></p><p><p>And then, today we'll come into contact with the PHP development language</p></p><p><p>1. First of all, you need to create a new. php file under our native server folder resource, nonsense (you have to write php!)</p></p><p><p></p></p><p><p>2. Enter the following code in register.php</p></p><pre><?<span style="color: #000000;"><span style="color: #000000;">PHP</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">1. Obtain the value (this field//is specified here, The front end must abide by this name2, pass2 etc key Value) of the field in the body of the network request that the client uses the Post method</span></span><span style="color: #800080;"><span style="color: #800080;">$nameP</span></span>=<span style="color: #800080;"><span style="color: #800080;">$_post</span></span>[' name2 '<span style="color: #000000;"><span style="color: #000000;">];</span></span><span style="color: #800080;"><span style="color: #800080;">$passP</span></span>=<span style="color: #800080;"><span style="color: #800080;">$_post</span></span>[' Pass2 '<span style="color: #000000;"><span style="color: #000000;">];</span></span><span style="color: #800080;"><span style="color: #800080;">$ageP</span></span>=<span style="color: #800080;"><span style="color: #800080;">$_post</span></span>[' Age2 '<span style="color: #000000;"><span style="color: #000000;">];</span></span><span style="color: #800080;"><span style="color: #800080;">$telephoneP</span></span>=<span style="color: #800080;"><span style="color: #800080;">$_post</span></span>[' Telephone2 '<span style="color: #000000;"><span style="color: #000000;">];</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">2. Establish a database connection (the IP address where the 127.0.0.1 database resides)//root is the database user name (default)//"" password (default is Empty)</span></span><span style="color: #800080;"><span style="color: #800080;">$con</span></span>=<span style="color: #008080;"><span style="color: #008080;">mysql_connect</span></span>("127.0.0.1", "root", "" "<span style="color: #000000;"><span style="color: #000000;">);</span></span><span style="color: #800080;"><span style="color: #800080;">$myCon</span></span>=<span style="color: #008080;"><span style="color: #008080;">mysql_select_db</span></span>("lidongxu",<span style="color: #800080;"><span style="color: #800080;">$con</span></span><span style="color: #000000;"><span style="color: #000000;">);</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">3. Check first, if present, do not insert the</span></span><span style="color: #800080;"><span style="color: #800080;">$select</span></span>= "select userName from User where userName = '<span style="color: #800080;"><span style="color: #800080;">$nameP</span></span>‘"<span style="color: #000000;"><span style="color: #000000;">;</span></span><span style="color: #800080;"><span style="color: #800080;">$seleResult</span></span>=<span style="color: #008080;"><span style="color: #008080;">mysql_query</span></span>(<span style="color: #800080;"><span style="color: #800080;">$select</span></span><span style="color: #000000;"><span style="color: #000000;">);</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">4. If it is found that the user is already present, then return-1 to the client representative has already registered</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">if</span></span>(<span style="color: #008080;"><span style="color: #008080;">mysql_num_rows</span></span>(<span style="color: #800080;"><span style="color: #800080;">$seleResult</span></span><span style="color: #000000;"><span style="color: #000000;">)) {</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">success is the value of the key that corresponds to the string that follows</span></span> <span style="color: #800080;"><span style="color: #800080;">$a</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">Array</span></span><span style="color: #000000;"><span style="color: #000000;">(); </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' Success '] = "1"<span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' Status '] = "have"<span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #800080;"><span style="color: #800080;">$arr</span></span>= Json_encode (<span style="color: #800080;"><span style="color: #800080;">$a</span></span><span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Echo</span></span> <span style="color: #800080;"><span style="color: #800080;">$arr</span></span><span style="color: #000000;"><span style="color: #000000;">;}</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">5. If you have not registered, then</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Else</span></span><span style="color: #000000;"><span style="color: #000000;"> {</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">6. Insert the data into the MySQL database</span></span> <span style="color: #800080;"><span style="color: #800080;">$sql</span></span>= "insert into User values ('<span style="color: #800080;"><span style="color: #800080;">$nameP</span></span>‘, ‘<span style="color: #800080;"><span style="color: #800080;">$passP</span></span>‘, ‘<span style="color: #800080;"><span style="color: #800080;">$ageP</span></span>‘, ‘<span style="color: #800080;"><span style="color: #800080;">$telephoneP</span></span>‘)"<span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #800080;"><span style="color: #800080;">$result</span></span>=<span style="color: #008080;"><span style="color: #008080;">mysql_query</span></span>(<span style="color: #800080;"><span style="color: #800080;">$sql</span></span><span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">if</span></span>(<span style="color: #800080;"><span style="color: #800080;">$result</span></span>= = 1) {<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">7. Successful Execution</span> of the representative</span> <span style="color: #800080;"><span style="color: #800080;">$a</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">Array</span></span><span style="color: #000000;"><span style="color: #000000;">(); </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' Success '] = "1"<span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' Status '] = "ok"<span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #800080;"><span style="color: #800080;">$arr</span></span>= Json_encode (<span style="color: #800080;"><span style="color: #800080;">$a</span></span><span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Echo</span></span> <span style="color: #800080;"><span style="color: #800080;">$arr</span></span><span style="color: #000000;"><span style="color: #000000;">; } </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Else</span></span>{<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">8. Failed to insert on behalf</span> of</span> <span style="color: #800080;"><span style="color: #800080;">$a</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">Array</span></span><span style="color: #000000;"><span style="color: #000000;">(); </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' Success '] = "0"<span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' Status '] = "no"<span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #800080;"><span style="color: #800080;">$arr</span></span>= Json_encode (<span style="color: #800080;"><span style="color: #800080;">$a</span></span><span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Echo</span></span> <span style="color: #800080;"><span style="color: #800080;">$arr</span></span><span style="color: #000000;"><span style="color: #000000;">; }}</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">9. Receive picture of user picture//9.1. receive images to the default temporary file path on the server and the name (uploadfile To//field used by the Foreground)</span></span><span style="color: #800080;"><span style="color: #800080;">$url</span></span>=<span style="color: #800080;"><span style="color: #800080;">$_files</span></span>["uploadimagefile"] ["tmp_name"<span style="color: #000000;"><span style="color: #000000;">];</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">9.2 Get the path under the Downloads folder under the root path (download2 requires manual//go-local Creation)</span></span><span style="color: #800080;"><span style="color: #800080;">$destination _folder</span></span>=<span style="color: #800080;"><span style="color: #800080;">$_server</span></span>[' document_root ']. ' /download2/'<span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">9.3 Stitching to be saved as a file name on the server</span></span> <span style="color: #800080;"><span style="color: #800080;">$newfname</span></span>=<span style="color: #800080;"><span style="color: #800080;">$destination _folder</span></span>. (<span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span>)<span style="color: #800080;"><span style="color: #800080;">$nameP</span></span>.‘. JPG ';<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">Set your file ext//open a connection rb+ read and write open a binary file that allows read and write data, and the file must Exist. Get the files that are uploaded to the cache folder by the client</span></span> <span style="color: #800080;"><span style="color: #800080;">$file</span></span>=<span style="color: #008080;"><span style="color: #008080;">fopen</span></span>(<span style="color: #800080;"><span style="color: #800080;">$url</span></span>, "rb"<span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">if</span></span>(<span style="color: #800080;"><span style="color: #800080;">$file</span></span><span style="color: #000000;"><span style="color: #000000;">) { </span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">a write-only file opens in an additional way. If the file does not exist, the file will be created, and if the file exists, the data written will be added to the end of the file, that is, the original content of the file will be Retained. Get the name of the file you want to pass the client over to the new folder</span></span> <span style="color: #800080;"><span style="color: #800080;">$NEWF</span></span>=<span style="color: #008080;"><span style="color: #008080;">fopen</span></span>(<span style="color: #800080;"><span style="color: #800080;">$newfname</span></span>, "a"<span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">if</span></span>(<span style="color: #800080;"><span style="color: #800080;">$NEWF</span></span><span style="color: #000000;"><span style="color: #000000;">) </span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">checks whether the file ends, such as ending, returns a value other than 0</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"></span> while</span>(!<span style="color: #008080;"><span style="color: #008080;">feof</span></span>(<span style="color: #800080;"><span style="color: #800080;">$file</span></span><span style="color: #000000;"><span style="color: #000000;">)) { </span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">start reading 1MB from a file and write to the new path 1MB</span></span> <span style="color: #008080;"><span style="color: #008080;">fwrite</span></span>(<span style="color: #800080;"><span style="color: #800080;">$NEWF</span></span>,<span style="color: #008080;"><span style="color: #008080;">fread</span></span>(<span style="color: #800080;"><span style="color: #800080;">$file</span></span>, 1024 * 8), 1024 * 8<span style="color: #000000;"><span style="color: #000000;"> ); } } </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">if</span></span>(<span style="color: #800080;"><span style="color: #800080;">$file</span></span><span style="color: #000000;"><span style="color: #000000;">) { </span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">Close File Link</span></span> <span style="color: #008080;"><span style="color: #008080;">fclose</span></span>(<span style="color: #800080;"><span style="color: #800080;">$file</span></span><span style="color: #000000;"><span style="color: #000000;">); } </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">if</span></span>(<span style="color: #800080;"><span style="color: #800080;">$NEWF</span></span><span style="color: #000000;"><span style="color: #000000;">) { </span></span><span style="color: #008080;"><span style="color: #008080;">fclose</span></span>(<span style="color: #800080;"><span style="color: #800080;">$NEWF</span></span><span style="color: #000000;"><span style="color: #000000;">); } </span></span>?></pre><p><p>3. Then create a new Download2 folder under the local server folder</p></p><p><p></p></p><p><p>4. Then write the login PHP code too! under the Htdocs folder, create a new loginget.php file and insert the code</p></p><pre><?<span style="color: #000000;"><span style="color: #000000;">PHP</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">1. Get the key value corresponding to the value//declaration variable name1 and PASS1 receive in the Get Network request URL</span></span><span style="color: #800080;"><span style="color: #800080;">$name 1</span></span>=<span style="color: #800080;"><span style="color: #800080;">$_get</span></span>[' name '<span style="color: #000000;"><span style="color: #000000;">];</span></span><span style="color: #800080;"><span style="color: #800080;">$pass 1</span></span>=<span style="color: #800080;"><span style="color: #800080;">$_get</span></span>[' Pass '<span style="color: #000000;"><span style="color: #000000;">];</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">2. Establish database Connection//parameter 1: the address of the server where the database resides (native 127.0.0.1 or Localhost)//parameter 2:mysql the account of the database (default Root)//parameter 3:mysql The password of the database (default none)</span></span><span style="color: #800080;"><span style="color: #800080;">$con</span></span>=<span style="color: #008080;"><span style="color: #008080;">mysql_connect</span></span>("127.0.0.1", "root", "" "<span style="color: #000000;"><span style="color: #000000;">);</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">parameter 1: name of the database you created</span></span><span style="color: #800080;"><span style="color: #800080;">$myCon</span></span>=<span style="color: #008080;"><span style="color: #008080;">mysql_select_db</span></span>("lidongxu",<span style="color: #800080;"><span style="color: #800080;">$con</span></span><span style="color: #000000;"><span style="color: #000000;">);</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">3. Execute the query (using the username and password to match the lookup, if found the random return username (user name))</span></span><span style="color: #800080;"><span style="color: #800080;">$sql</span></span>= "select * from User where userName = '<span style="color: #800080;"><span style="color: #800080;">$name 1</span></span>' and password = '<span style="color: #800080;"><span style="color: #800080;">$pass 1</span></span>‘"<span style="color: #000000;"><span style="color: #000000;">;</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">4. Receive Results</span></span><span style="color: #800080;"><span style="color: #800080;">$result</span></span>=<span style="color: #008080;"><span style="color: #008080;">mysql_query</span></span>(<span style="color: #800080;"><span style="color: #800080;">$sql</span></span><span style="color: #000000;"><span style="color: #000000;">);</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">4.2 If the query results are empty</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">if</span></span>(<span style="color: #008080;"><span style="color: #008080;">mysql_num_rows</span></span>(<span style="color: #800080;"><span style="color: #800080;">$result</span></span>) = = 0<span style="color: #000000;"><span style="color: #000000;">) { </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">Array</span></span><span style="color: #000000;"><span style="color: #000000;">(); </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' Success '] = "0"<span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' name '] = "null"<span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' Status '] = "no"<span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #800080;"><span style="color: #800080;">$arr</span></span>= Json_encode (<span style="color: #800080;"><span style="color: #800080;">$a</span></span><span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Echo</span></span> <span style="color: #800080;"><span style="color: #800080;">$arr</span></span><span style="color: #000000;"><span style="color: #000000;">; }</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Else</span></span><span style="color: #000000;"><span style="color: #000000;"> {</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">5. Remove this record</span></span><span style="color: #800080;"><span style="color: #800080;">$row</span></span>=<span style="color: #008080;"><span style="color: #008080;">Mysql_fetch_row</span></span>(<span style="color: #800080;"><span style="color: #800080;">$result</span></span><span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">Array</span></span><span style="color: #000000;"><span style="color: #000000;">(); </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' Success '] = "1"<span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' name '] =<span style="color: #800080;"><span style="color: #800080;">$row</span></span>[0<span style="color: #000000;"><span style="color: #000000;">]; </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' Age '] =<span style="color: #800080;"><span style="color: #800080;">$row</span></span>[2<span style="color: #000000;"><span style="color: #000000;">]; </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' Telephone '] =<span style="color: #800080;"><span style="color: #800080;">$row</span></span>[3<span style="color: #000000;"><span style="color: #000000;">]; </span></span><span style="color: #800080;"><span style="color: #800080;">$a</span></span>[' Status '] = "ok"<span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #800080;"><span style="color: #800080;">$arr</span></span>= Json_encode (<span style="color: #800080;"><span style="color: #800080;">$a</span></span><span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Echo</span></span> <span style="color: #800080;"><span style="color: #800080;">$arr</span></span><span style="color: #000000;"><span style="color: #000000;">; } </span></span>?></pre><p><p>here, PHP temporarily reported a section of the way, and then the development of iOS code (happy not???)</p></p><p><p></p></p><p><p>To write iOS code ...... http://www.cnblogs.com/lidongxu/p/5267753.html</p></p><p><p></p></p><p><p>[php] use XAMPP to build a local server, and then use the iOS client to upload data to the local server (three. PHP-side code Implementation)</p></p></span>
