Home Backend Development PHP Tutorial 一段查询代码多处使用可以吗解决办法

一段查询代码多处使用可以吗解决办法

Jun 13, 2016 am 11:51 AM
gt nbsp sql this

一段查询代码多处使用可以吗

<br />$bliang='这是个变量'<br />$sql=SELECT * FROM A表 WHERE cart LIKE '%.$bliang.%'<br />$query=mysql_query($sql);<br />while($row=mysql_fetch_array($query)){<br /> <br />  …………<br />}
Copy after login


上边是查询代码   然后我使用它时  只需要这样  比如 $row[$bliang='分类2']   这样就可以分类2下的内容 

$row[$bliang='分类3'] 就显示分类3下的内容

这样的需求  要怎么样实现呢

------解决方案--------------------
写成函数啊,我也是刚学php,我给你一个我自己做的类参考下吧,所有数据库操作都在这里了

<br><?php <br />// <br><font color="#FF8000">------解决方案--------------------</font><br> PHP version 5.3<br>// 数据库操作类 Order by phuai007 <br>// Date 2014/2<br>class my_sql {<br>  public $dsn = 'mysql:host=localhost;dbname=lif2';//host为数据库连接地址,dbname为数据库名<br>  public $user = 'root';                           //数据库连接用户名<br>  public $pass = '123456';                         //对应的密码<br>  public $names = 'SET NAMES UTF8';                //数据库查询编码<br>  //查询数据库返回结果<br>  public function sql_select($sql) {<br>	  try {<br>		  $dbh = new PDO($this->dsn, $this->user, $this->pass);<br>		  $dbh->query($this->names);<br>		  return $dbh->query($sql);<br>		  $dbh = null;<br>	  }<br>	  catch(Exception $e) {<br>		  echo 'error: ' . $e->getMessage();<br>	  }<br>  }<br>  //操作单条数据(更新/删除/插入),无返回结果<br>  public function sql_one($sql) {<br>	  try {<br>		  $dbh = new PDO($this->dsn, $this->user, $this->pass);<br>		  $dbh->exec($this->names);<br>		  $dbh->exec($sql);<br>		  $dbh = null;<br>	  }<br>	  catch(Exception $e) {<br>		  echo 'error: ' . $e->getMessage();<br>	  }<br>  }<br>  //操作多条数据(更新/删除),无返回结果<br>  public function sql_more($sql, $str) {<br>	  try {<br>		  $dbh = new PDO($this->dsn, $this->user, $this->pass);<br>		  $dbh->exec($this->names);<br>		  foreach ($str as $arrs) {<br>			  $dbh->exec($sql . $arrs);<br>		  }<br>		  $dbh = null;<br>	  }<br>	  catch(Exception $e) {<br>		  echo 'error: ' . $e->getMessage();<br>	  }<br>  }<br>  <br>  //参数化查询数据库返回结果(单条)<br>  public function cs_sql_select($sql,$str) {<br>	  try {<br>		  $dbh = new PDO($this->dsn, $this->user, $this->pass);<br>		  $dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);<br>		  $dbh->query($this->names);<br>		  $stmt = $dbh->prepare($sql);<br>		  $stmt->bindValue(":key", $str ,PDO::PARAM_INT);<br>		  $stmt->execute();<br>		  return $stmt;<br>		  $dbh = null;<br>	  }<br>	  catch(Exception $e) {<br>		  echo 'error: ' . $e->getMessage();<br>	  }<br>  }  <br>  //参数化查询操作多条数据(删除/更新),无返回结果<br>  public function cs_sql_more($sql, $str) {<br>	  try {<br>		  $dbh = new PDO($this->dsn, $this->user, $this->pass);<br>		  $dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);<br>		  $dbh->exec($this->names);<br>		  foreach ($str as $arrs) {<br>			  $stmt = $dbh->prepare($sql);<br>			  $stmt->bindValue(":key", $arrs,PDO::PARAM_INT);<br>			  $stmt->execute();<br>		  }<br>		  $dbh = null;<br>	  }<br>	  catch(Exception $e) {<br>		  echo 'error: ' . $e->getMessage();<br>	  }<br>  }<br>  //参数化查询操作单条数据(删除/更新),无返回结果<br>  public function cs_sql_one($sql, $str) {<br>	  try {<br>		  $dbh = new PDO($this->dsn, $this->user, $this->pass);<br>		  $dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);<br>		  $dbh->exec($this->names);<br>		  $stmt = $dbh->prepare($sql);<br>		  $stmt->bindValue(":key", $str,PDO::PARAM_INT);<br>		  $stmt->execute();<br>		  $dbh = null;<br>	  }<br>	  catch(Exception $e) {<br>		  echo 'error: ' . $e->getMessage();<br>	  }<br>  }<br>  <br>  <br>  ////////<br>}<br>?><div class="clear">
                 
              
              
        
            </div>
Copy after login
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Solution: Your organization requires you to change your PIN Solution: Your organization requires you to change your PIN Oct 04, 2023 pm 05:45 PM

The message "Your organization has asked you to change your PIN" will appear on the login screen. This happens when the PIN expiration limit is reached on a computer using organization-based account settings, where they have control over personal devices. However, if you set up Windows using a personal account, the error message should ideally not appear. Although this is not always the case. Most users who encounter errors report using their personal accounts. Why does my organization ask me to change my PIN on Windows 11? It's possible that your account is associated with an organization, and your primary approach should be to verify this. Contacting your domain administrator can help! Additionally, misconfigured local policy settings or incorrect registry keys can cause errors. Right now

How to adjust window border settings on Windows 11: Change color and size How to adjust window border settings on Windows 11: Change color and size Sep 22, 2023 am 11:37 AM

Windows 11 brings fresh and elegant design to the forefront; the modern interface allows you to personalize and change the finest details, such as window borders. In this guide, we'll discuss step-by-step instructions to help you create an environment that reflects your style in the Windows operating system. How to change window border settings? Press + to open the Settings app. WindowsI go to Personalization and click Color Settings. Color Change Window Borders Settings Window 11" Width="643" Height="500" > Find the Show accent color on title bar and window borders option, and toggle the switch next to it. To display accent colors on the Start menu and taskbar To display the theme color on the Start menu and taskbar, turn on Show theme on the Start menu and taskbar

How to change title bar color on Windows 11? How to change title bar color on Windows 11? Sep 14, 2023 pm 03:33 PM

By default, the title bar color on Windows 11 depends on the dark/light theme you choose. However, you can change it to any color you want. In this guide, we'll discuss step-by-step instructions for three ways to change it and personalize your desktop experience to make it visually appealing. Is it possible to change the title bar color of active and inactive windows? Yes, you can change the title bar color of active windows using the Settings app, or you can change the title bar color of inactive windows using Registry Editor. To learn these steps, go to the next section. How to change title bar color in Windows 11? 1. Using the Settings app press + to open the settings window. WindowsI go to "Personalization" and then

How to enable or disable taskbar thumbnail previews on Windows 11 How to enable or disable taskbar thumbnail previews on Windows 11 Sep 15, 2023 pm 03:57 PM

Taskbar thumbnails can be fun, but they can also be distracting or annoying. Considering how often you hover over this area, you may have inadvertently closed important windows a few times. Another disadvantage is that it uses more system resources, so if you've been looking for a way to be more resource efficient, we'll show you how to disable it. However, if your hardware specs can handle it and you like the preview, you can enable it. How to enable taskbar thumbnail preview in Windows 11? 1. Using the Settings app tap the key and click Settings. Windows click System and select About. Click Advanced system settings. Navigate to the Advanced tab and select Settings under Performance. Select "Visual Effects"

What are the differences between Huawei GT3 Pro and GT4? What are the differences between Huawei GT3 Pro and GT4? Dec 29, 2023 pm 02:27 PM

Many users will choose the Huawei brand when choosing smart watches. Among them, Huawei GT3pro and GT4 are very popular choices. Many users are curious about the difference between Huawei GT3pro and GT4. Let’s introduce the two to you. . What are the differences between Huawei GT3pro and GT4? 1. Appearance GT4: 46mm and 41mm, the material is glass mirror + stainless steel body + high-resolution fiber back shell. GT3pro: 46.6mm and 42.9mm, the material is sapphire glass + titanium body/ceramic body + ceramic back shell 2. Healthy GT4: Using the latest Huawei Truseen5.5+ algorithm, the results will be more accurate. GT3pro: Added ECG electrocardiogram and blood vessel and safety

What is the difference between HQL and SQL in Hibernate framework? What is the difference between HQL and SQL in Hibernate framework? Apr 17, 2024 pm 02:57 PM

HQL and SQL are compared in the Hibernate framework: HQL (1. Object-oriented syntax, 2. Database-independent queries, 3. Type safety), while SQL directly operates the database (1. Database-independent standards, 2. Complex executable queries and data manipulation).

Display scaling guide on Windows 11 Display scaling guide on Windows 11 Sep 19, 2023 pm 06:45 PM

We all have different preferences when it comes to display scaling on Windows 11. Some people like big icons, some like small icons. However, we all agree that having the right scaling is important. Poor font scaling or over-scaling of images can be a real productivity killer when working, so you need to know how to customize it to get the most out of your system's capabilities. Advantages of Custom Zoom: This is a useful feature for people who have difficulty reading text on the screen. It helps you see more on the screen at one time. You can create custom extension profiles that apply only to certain monitors and applications. Can help improve the performance of low-end hardware. It gives you more control over what's on your screen. How to use Windows 11

10 Ways to Adjust Brightness on Windows 11 10 Ways to Adjust Brightness on Windows 11 Dec 18, 2023 pm 02:21 PM

Screen brightness is an integral part of using modern computing devices, especially when you look at the screen for long periods of time. It helps you reduce eye strain, improve legibility, and view content easily and efficiently. However, depending on your settings, it can sometimes be difficult to manage brightness, especially on Windows 11 with the new UI changes. If you're having trouble adjusting brightness, here are all the ways to manage brightness on Windows 11. How to Change Brightness on Windows 11 [10 Ways Explained] Single monitor users can use the following methods to adjust brightness on Windows 11. This includes desktop systems using a single monitor as well as laptops. let's start. Method 1: Use the Action Center The Action Center is accessible

See all articles