谈php＋mysql扎实个人基本功_MySQL
1.不要依赖register_global=ON的环境，从你刚懂得配置php运行环境甚至尚不明白register_global的ON/OFF会对自己有什么影响的那天起，就应该勇敢地把它设为OFF.
2.写程序前看看怎么用error_reporting.
3.不懂就问本身没错，但你需要在那之前查查手册。
4.当然，你需要懂得使用手册。手册上找不到答案的时候，应该考虑下网络上的搜索引擎。
5.刚学会php+mysql之后，不要叫嚷着要写论坛，要写XXX。要明白，刚学会写汉字并不表示你有能力写诗。
6.在学web编程的时候，你应该先去认识html这个朋友。
7.有点能力后，试着回答新手的问题，不要看到自己懂的而别人不懂就沾沾自喜，扔下一名“简单，那是基本的东西”就走更要不得。
8.思考是一个好习惯，不动手去写就等于空想，什么也没有。
9.写好一段程序，如果觉得很满意，一周后再看一遍，也许你会认为它应该有所改变
10.有空多看看别人的程序，找出他人的不足或优点，自己掂量。
二. 各取所需
1.善于使用“引用”,它能直接影响到程序的效率。
2.善于用三元运算子,可以让程式较精简有效率。
比如:
<font size="2"><font face="Verdana">PHP代码:</font><hr></font><code><font color="#000000"> <font color="#0000bb"><br></font><font color="#007700">if (</font><font color="#0000bb">$data</font><font color="#007700">[</font><font color="#0000bb">$i</font><font color="#007700">][</font><font color="#dd0000">'nickname'</font><font color="#007700">]) <br>{ <br> </font><font color="#0000bb">$nickname </font><font color="#007700">= </font><font color="#0000bb">$data</font><font color="#007700">[</font><font color="#0000bb">$i</font><font color="#007700">][</font><font color="#dd0000">'nickname'</font><font color="#007700">]; <br>} <br>else <br>{ <br> </font><font color="#0000bb">$nickname </font><font color="#007700">= </font><font color="#0000bb">$data</font><font color="#007700">[</font><font color="#0000bb">$i</font><font color="#007700">][</font><font color="#dd0000">'ip'</font><font color="#007700">]; <br>}<br></font><font color="#0000bb"></font> </font> </code><hr>Copy after login
可以写成:
<font size="2"><font face="verdana,arial,helvetica">PHP代码:</font><hr></font><code><font color="#000000"> <font color="#0000bb"><br>$nickname </font><font color="#007700">= </font><font color="#0000bb">$data</font><font color="#007700">[</font><font color="#0000bb">$i</font><font color="#007700">][</font><font color="#dd0000">'nickname'</font><font color="#007700">] ? </font><font color="#0000bb">$data</font><font color="#007700">[</font><font color="#0000bb">$i</font><font color="#007700">][</font><font color="#dd0000">'nickname'</font><font color="#007700">] : </font><font color="#0000bb">$data</font><font color="#007700">[</font><font color="#0000bb">$i</font><font color="#007700">][</font><font color="#dd0000">'ip'</font><font color="#007700">];<br></font><font color="#0000bb"></font> </font> </code><hr>Copy after login
3.善于组织if...else...回圈
比如:
<font size="2"><font face="verdana,arial,helvetica">PHP代码:</font><hr></font><code><font color="#000000"> <font color="#0000bb"><br>$ext_name </font><font color="#007700">= </font><font color="#0000bb">strtolower</font><font color="#007700">(</font><font color="#0000bb">str_replace</font><font color="#007700">(</font><font color="#dd0000">"."</font><font color="#007700">, </font><font color="#dd0000">""</font><font color="#007700">, </font><font color="#0000bb">strrchr</font><font color="#007700">(</font><font color="#0000bb">$upfilename</font><font color="#007700">, </font><font color="#dd0000">"."</font><font color="#007700">))); <br>if (!empty(</font><font color="#0000bb">$type</font><font color="#007700">)) <br>{ <br> if (!</font><font color="#0000bb">strpos</font><font color="#007700">(</font><font color="#0000bb">$type</font><font color="#007700">, </font><font color="#0000bb">$ext_name</font><font color="#007700">)) <br> { <br> echo </font><font color="#dd0000">"Please upload the file of $type form."</font><font color="#007700">; <br> exit(); <br> } <br>}<br></font><font color="#0000bb"></font> </font> </code><hr>Copy after login
上面的代码你应该写成这样:
<font size="2"><font face="verdana,arial,helvetica">PHP代码:</font><hr></font><code><font color="#000000"> <font color="#0000bb"><br>$ext_name </font><font color="#007700">= </font><font color="#0000bb">strtolower</font><font color="#007700">(</font><font color="#0000bb">str_replace</font><font color="#007700">(</font><font color="#dd0000">"."</font><font color="#007700">, </font><font color="#dd0000">""</font><font color="#007700">, </font><font color="#0000bb">strrchr</font><font color="#007700">(</font><font color="#0000bb">$upfilename</font><font color="#007700">, </font><font color="#dd0000">"."</font><font color="#007700">))); <br>if (!(</font><font color="#0000bb">$type</font><font color="#007700">===</font><font color="#dd0000">''</font><font color="#007700">) && </font><font color="#0000bb">strpos</font><font color="#007700">(</font><font color="#0000bb">$type</font><font color="#007700">, </font><font color="#0000bb">$ext_name</font><font color="#007700">)===</font><font color="#0000bb">false</font><font color="#007700">) <br>{ <br> echo </font><font color="#dd0000">"Please upload the file of $type form."</font><font color="#007700">; <br> exit(); <br>}<br></font><font color="#0000bb"></font> </font> </code><hr>Copy after login
4.尽量让你的代码清淅些
如果写成这样，是比较让人头痛的:
<font size="2"><font face="verdana,arial,helvetica">PHP代码:</font><hr></font><code><font color="#000000"> <font color="#0000bb"><br>$foo</font><font color="#007700">=</font><font color="#0000bb">$_post</font><font color="#007700">[</font><font color="#dd0000">"foo"</font><font color="#007700">]; <br> </font><font color="#0000bb">$username</font><font color="#007700">=</font><font color="#0000bb">$_post</font><font color="#007700">[</font><font color="#dd0000">"user"</font><font color="#007700">]; <br></font><font color="#0000bb">$group</font><font color="#007700">=</font><font color="#0000bb">$_POST</font><font color="#007700">[</font><font color="#dd0000">"group"</font><font color="#007700">]; <br>if (</font><font color="#0000bb">$group</font><font color="#007700">==</font><font color="#dd0000">"wheel"</font><font color="#007700">){ <br></font><font color="#0000bb">$username</font><font color="#007700">=</font><font color="#0000bb">$username</font><font color="#007700">.</font><font color="#dd0000">"wheel"</font><font color="#007700">; <br>}<br></font><font color="#0000bb"></font> </font> </code><hr>Copy after login
同样的代码，这样就比较让人看得舒服了:
<font size="2"><font face="verdana,arial,helvetica">PHP代码:</font><hr></font><code><font color="#000000"> <font color="#0000bb"><br>$foo </font><font color="#007700">= </font><font color="#0000bb">$_post</font><font color="#007700">[</font><font color="#dd0000">"foo"</font><font color="#007700">]; <br></font><font color="#0000bb">$username </font><font color="#007700">= </font><font color="#0000bb">$_post</font><font color="#007700">[</font><font color="#dd0000">"username"</font><font color="#007700">]; <br></font><font color="#0000bb">$group </font><font color="#007700">= </font><font color="#0000bb">$_POST</font><font color="#007700">[</font><font color="#dd0000">"group"</font><font color="#007700">]; <br>if (</font><font color="#0000bb">$group</font><font color="#007700">==</font><font color="#dd0000">"wheel"</font><font color="#007700">) <br>{ <br> </font><font color="#0000bb">$username </font><font color="#007700">= </font><font color="#0000bb">$username</font><font color="#007700">.</font><font color="#dd0000">"wheel"</font><font color="#007700">; <br>}<br></font><font color="#0000bb"></font> </font> </code><hr>Copy after login
当然，有一定基础后，你应该要写成这样:
<font size="2"><font face="verdana,arial,helvetica">PHP代码:</font><hr></font><code><font color="#000000"> <font color="#0000bb"><br>$foo </font><font color="#007700">= &</font><font color="#0000bb">$_POST</font><font color="#007700">[</font><font color="#dd0000">'foo'</font><font color="#007700">]; <br></font><font color="#0000bb">$username </font><font color="#007700">= </font><font color="#0000bb">$_POST</font><font color="#007700">[</font><font color="#dd0000">"group"</font><font color="#007700">]!=</font><font color="#dd0000">'wheel' </font><font color="#007700">? </font><font color="#0000bb">$_POST</font><font color="#007700">[</font><font color="#dd0000">"username"</font><font color="#007700">] : </font><font color="#0000bb">$_POST</font><font color="#007700">[</font><font color="#dd0000">"username"</font><font color="#007700">].</font><font color="#dd0000">'wheel'</font><font color="#007700">;<br></font><font color="#0000bb"></font> </font> </code><hr>Copy after login
5.编写规范的mysql 语句。
字段和表名用"`"引起来，避免保留字的影响。
如果看到下面这样的一个sql query，会让人比较头痛:
<font size="2"><font face="verdana,arial,helvetica">PHP代码:</font><hr></font><code><font color="#000000"> <font color="#0000bb"><br>$query</font><font color="#007700">=</font><font color="#dd0000">"select `flash_comment`.`content` , `flash_comment`.`nickname` , `flash_comment`.`date` , `flash_comment`.`ip` , `product`.`p_name` , `sgflash`.`fid` from `flash_comment` left join `product` on ( `flash_comment`.`p_no` = `product`.`p_no` ) left join `sgflash` on ( `product`.`p_name` = `sgflash`.`f_name` ) where `flash_comment`.`p_no` != '' order by `flash_comment`.`date`"</font><font color="#007700">;<br></font><font color="#0000bb"></font> </font> </code><hr>Copy after login
同样的一个query,写成这样就令人看得明白得多了:
<font size="2"><font face="verdana,arial,helvetica">PHP代码:</font><hr></font><code><font color="#000000"> <font color="#0000bb"><br>$query </font><font color="#007700">= </font><font color="#dd0000">"SELECT `flash_comment`.`content` , `flash_comment`.`nickname` , `flash_comment`.`date` , `flash_comment`.`ip` , `product`.`p_name` , `sgflash`.`fid` <br> FROM `flash_comment` <br> LEFT JOIN `product` ON ( `flash_comment`.`p_no` = `product`.`p_no` ) <br> LEFT JOIN `sgflash` ON ( `product`.`p_name` = `sgflash`.`f_name` ) <br> WHERE `flash_comment`.`p_no` != '' <br> ORDER BY `flash_comment`.`date`"</font><font color="#007700">;<br></font><font color="#0000bb"></font> </font> </code><hr>Copy after login
//
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to solve win7 driver code 28
Dec 30, 2023 pm 11:55 PM
Some users encountered errors when installing the device, prompting error code 28. In fact, this is mainly due to the driver. We only need to solve the problem of win7 driver code 28. Let’s take a look at what should be done. Do it. What to do with win7 driver code 28: First, we need to click on the start menu in the lower left corner of the screen. Then, find and click the "Control Panel" option in the pop-up menu. This option is usually located at or near the bottom of the menu. After clicking, the system will automatically open the control panel interface. In the control panel, we can perform various system settings and management operations. This is the first step in the nostalgia cleaning level, I hope it helps. Then we need to proceed and enter the system and
What to do if the blue screen code 0x0000001 occurs
Feb 23, 2024 am 08:09 AM
What to do with blue screen code 0x0000001? The blue screen error is a warning mechanism when there is a problem with the computer system or hardware. Code 0x0000001 usually indicates a hardware or driver failure. When users suddenly encounter a blue screen error while using their computer, they may feel panicked and at a loss. Fortunately, most blue screen errors can be troubleshooted and dealt with with a few simple steps. This article will introduce readers to some methods to solve the blue screen error code 0x0000001. First, when encountering a blue screen error, we can try to restart
Solve the 'error: expected initializer before 'datatype'' problem in C++ code
Aug 25, 2023 pm 01:24 PM
Solve the "error:expectedinitializerbefore'datatype'" problem in C++ code. In C++ programming, sometimes we encounter some compilation errors when writing code. One of the common errors is "error:expectedinitializerbefore'datatype'". This error usually occurs in a variable declaration or function definition and may cause the program to fail to compile correctly or
The computer frequently blue screens and the code is different every time
Jan 06, 2024 pm 10:53 PM
The win10 system is a very excellent high-intelligence system. Its powerful intelligence can bring the best user experience to users. Under normal circumstances, users’ win10 system computers will not have any problems! However, it is inevitable that various faults will occur in excellent computers. Recently, friends have been reporting that their win10 systems have encountered frequent blue screens! Today, the editor will bring you solutions to different codes that cause frequent blue screens in Windows 10 computers. Let’s take a look. Solutions to frequent computer blue screens with different codes each time: causes of various fault codes and solution suggestions 1. Cause of 0×000000116 fault: It should be that the graphics card driver is incompatible. Solution: It is recommended to replace the original manufacturer's driver. 2,
GE universal remote codes program on any device
Mar 02, 2024 pm 01:58 PM
If you need to program any device remotely, this article will help you. We will share the top GE universal remote codes for programming any device. What is a GE remote control? GEUniversalRemote is a remote control that can be used to control multiple devices such as smart TVs, LG, Vizio, Sony, Blu-ray, DVD, DVR, Roku, AppleTV, streaming media players and more. GEUniversal remote controls come in various models with different features and functions. GEUniversalRemote can control up to four devices. Top Universal Remote Codes to Program on Any Device GE remotes come with a set of codes that allow them to work with different devices. you may
Resolve code 0xc000007b error
Feb 18, 2024 pm 07:34 PM
Termination Code 0xc000007b While using your computer, you sometimes encounter various problems and error codes. Among them, the termination code is the most disturbing, especially the termination code 0xc000007b. This code indicates that an application cannot start properly, causing inconvenience to the user. First, let’s understand the meaning of termination code 0xc000007b. This code is a Windows operating system error code that usually occurs when a 32-bit application tries to run on a 64-bit operating system. It means it should
What does the blue screen code 0x000000d1 represent?
Feb 18, 2024 pm 01:35 PM
What does the 0x000000d1 blue screen code mean? In recent years, with the popularization of computers and the rapid development of the Internet, the stability and security issues of the operating system have become increasingly prominent. A common problem is blue screen errors, code 0x000000d1 is one of them. A blue screen error, or "Blue Screen of Death," is a condition that occurs when a computer experiences a severe system failure. When the system cannot recover from the error, the Windows operating system displays a blue screen with the error code on the screen. These error codes
Introduction to methods for individuals to join corporate WeChat
Mar 26, 2024 am 10:16 AM
1. First, open the enterprise WeChat software you downloaded on your mobile phone. When logging in, there are two ways to choose: one is to use WeChat ID, the other is to use mobile phone number. 3. At this time, the enterprise administrator needs to add your mobile phone number in the background, and then Enterprise WeChat will identify the enterprise based on your mobile phone number. Then display your business and click the Enter Business option below. 4. Then you can enter the use of functions in the software. It can be said that the most important thing is that your mobile phone number must be added to the enterprise by the administrator, otherwise it will not be available.
