问题描述
我在使用mysqli时遇到问题.我们知道mysqli需要两个参数来执行.一个是查询",另一个是"php连接行代码".现在,我想制作一个单独的连接文件,并希望在每个文件中写入该单独的连接文件",这样我就不需要在每个文件中编写连接代码,或者如果我更改连接文件,则所有文件都将更新.
I am having a problem with mysqli. We know mysqli needs two parameter to execute. One is the "query" and other is the "php connection line code". Now, I want to make a separate connection file and want to write include "that separate connection file" in each file so that I do not need to write the connection code in each file or if I change the connection file, all files get the update.
但是在那种情况下,我不会在每个文件中都有连接行代码,所以我只有一个参数可以执行mysqli查询,所以我将无法执行它.有什么建议?我忽略了代码,因为Stack-overflow.com对它的限制太多.
But in that case, I will not have the connection line code in every file so I will have only one parameter to execute mysqli query so I will not be able to execute it. Any suggestions? I ignored code because Stack-overflow.com has too many restrictions on it.
推荐答案
Mark B
确实回答了这个问题,尽管他的答案是针对mysql的-已弃用且不应使用
Mark B
did answer the question although his answer was for mysql -which is deprecated and shouldn't be used
顺便说一句,它是mysqli而不是mysquli
by the way it is mysqli and not mysquli
程序样式
假设连接文件为:
Procedural style
let's say the connection file was:
conn.php
conn.php
<?php
$mysqli=mysqli_connect($host,$user,$password,$db);
if($mysqli_connect_error())
die('Connect Error');
?>
和其他文件:
other_file.php
other_file.php
<?php
require 'conn.php';
$res=mysqli_query($mysqli,$query); #yes $mysqli is available here although it is in another file
?>
OOP风格
conn.php
conn.php
<?php
$mysqli=new mysqli($host,$user,$password,$db);
if($mysqli->connect_error)
die('Connect Error');
?>
和其他文件:
other_file.php
other_file.php
<?php
require 'conn.php';
$res=$mysqli->query($query);
?>
在这里,我使用了普通的mysqli::query
和mysqli_query
(它们是相同的),但是我也建议使用预备语句而不是mysqli::query
,因为它对于SQL注入更安全.
Here I used the normal mysqli::query
and mysqli_query
(which are the same), butI would also recommend using prepared statements rather than mysqli::query
because it is safer for SQL injection.
这篇关于如何使用单独的connection.php文件使用mysqli查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!