Shulou(Shulou.com)05/31 Report--

Editor to share with you how to query the database in PHP, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

How the query method should be implemented: according to the principle mentioned before, we need to use the following methods:

/ / filed method

/ / table method

/ / where method

/ / group method

/ / having method

/ / order method

/ / limit method

If we call one of them, then I will save one of them into an array, and finally we will query it through the select method, and finally return the result to us, and then we can present it in the form of code, as follows:

We first define a (function) function; we use the field method, and when it is passed, we have to determine whether the field is passed, if it is not empty, we will continue to pass it down, if it is empty, we will directly return $this, which means that if it is not empty, we will process it.

/ / field method:

Function field ($field) {/ / if not empty, process if (! empty ($field)) {if (is_ string ($field)) {$this- > options ['field'] = $field;} else if (is_ array ($field)) {$this- > options [' field'] = join (',', $field);} return $this;}

/ / table method:

The same thing, first of all, we have to judge whether it is empty or not.

Function table ($table) {if (! empty ($table)) {$this- > options ['table'] = $table;} return $this;} / / where method function where ($where) {if (! empty ($where)) {$this- > options [' where'] = 'where'. $where;} return $this;}

/ / group method

Function group ($group) if (! empty ($group)) {$this- > options ['group'] =' group by'. $group;} return $this;} / / having method function having ($having) {if (! empty ($having)) {$this- > options ['having'] =' having'.$having;} return $this;}

/ / order method

Function order ($order) {if (! empty ($order)) {$this- > options ['order'] =' order by'.$order;} return $thiys;}

/ / limit method

Function limit ($limit) {if (! empty ($limit)) {if (is_string ($limit)) {$this- > options ['limit'] =' limit'.$limit;} else if (is_array ($limit)) {$this- > options ['limit'] =' limit'. Join (',', $limit);} these are all the contents of the article "how to query a database in PHP". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.