php db類庫進(jìn)行數(shù)據(jù)庫操作
Jun 13, 2016 pm 12:24 PM
復(fù)制代碼 代碼如下:
require_once "DB.php"; //包含類庫文件
$conn = DB::connect("mysql://root:1981427@localhost/test"); //連接數(shù)據(jù)庫
if (!DB::isError($conn)) { //判斷是否連接成功
print "數(shù)據(jù)庫連接成功";
}
else
{
echo "數(shù)據(jù)庫連接失?。?;
}
?>
復(fù)制代碼 代碼如下:
require_once "DB.php";
$conn = DB::connect("mysql://root:1981427@localhost/test"); //調(diào)用connect連接數(shù)據(jù)庫
if (DB::isError($conn)) //如果連接出錯則報錯
{
print "數(shù)據(jù)庫連接失敗";
}
$rs = $conn->query("select id,username, password from tablename1"); //執(zhí)行SQL語句
if (DB::isError($rs)) //判斷是否執(zhí)行成功
{
print "數(shù)據(jù)查詢失敗";
}
while ($rs->fetchInto($rows)) //循環(huán)輸出查詢結(jié)果
{
print "編號號:$rows[0]
";
print "姓名:$rows[1]
";
print "密碼:$rows[2]
";
print "
";
}
?>
復(fù)制代碼 代碼如下:
require_once "DB.php";
$conn = DB::connect("mysql://root:1981427@localhost/test"); //調(diào)用connect連接數(shù)據(jù)庫
if (DB::isError($conn)) //如果連接出錯則報錯
{
print "數(shù)據(jù)庫連接失敗";
}
//執(zhí)行SQL語句,從第0條開始返回1條記錄
$rs = $conn->limitQuery("select id,username, password from tablename1",2,5); //查詢出記錄集中第三個到第六個數(shù)據(jù)
if (DB::isError($rs)) //如果查詢出錯則報錯
{
print "數(shù)據(jù)查詢失敗";
}
while ($rs->fetchInto($rows)) //循環(huán)輸出查詢結(jié)果
{
print "編號:$rows[0]
";
print "姓名:$rows[1]
";
print "密碼:$rows[2]
";
print "
";
}
?>
復(fù)制代碼 代碼如下:
require_once "DB.php";
$conn = DB::connect("mysql://root:1981427@localhost/test"); //連接數(shù)據(jù)庫
if (DB::isError($conn))
{
print "數(shù)據(jù)庫連接失敗";
}
//使用prepare函數(shù)準(zhǔn)備SQL語句
$rs = $conn->prepare("update tablename1 set password = 'Susan' where id = '1'");
if (DB::isError($rs))
{
print "數(shù)據(jù)更新失敗";
}
else
{
$conn->execute($rs); //執(zhí)行SQL語句更新數(shù)據(jù)庫
print "數(shù)據(jù)更新成功";
}
?>

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

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

The rational use of semantic tags in HTML can improve page structure clarity, accessibility and SEO effects. 1. Used for independent content blocks, such as blog posts or comments, it must be self-contained; 2. Used for classification related content, usually including titles, and is suitable for different modules of the page; 3. Used for auxiliary information related to the main content but not core, such as sidebar recommendations or author profiles. In actual development, labels should be combined and other, avoid excessive nesting, keep the structure simple, and verify the rationality of the structure through developer tools.

When you encounter the prompt "This operation requires escalation of permissions", it means that you need administrator permissions to continue. Solutions include: 1. Right-click the "Run as Administrator" program or set the shortcut to always run as an administrator; 2. Check whether the current account is an administrator account, if not, switch or request administrator assistance; 3. Use administrator permissions to open a command prompt or PowerShell to execute relevant commands; 4. Bypass the restrictions by obtaining file ownership or modifying the registry when necessary, but such operations need to be cautious and fully understand the risks. Confirm permission identity and try the above methods usually solve the problem.

To safely handle PHP file uploads, you need to verify the source and type, control the file name and path, set server restrictions, and process media files twice. 1. Verify the upload source to prevent CSRF through token and detect the real MIME type through finfo_file using whitelist control; 2. Rename the file to a random string and determine the extension to store it in a non-Web directory according to the detection type; 3. PHP configuration limits the upload size and temporary directory Nginx/Apache prohibits access to the upload directory; 4. The GD library resaves the pictures to clear potential malicious data.

InPHP,variablesarepassedbyvaluebydefault,meaningfunctionsorassignmentsreceiveacopyofthedata,whilepassingbyreferenceallowsmodificationstoaffecttheoriginalvariable.1.Whenpassingbyvalue,changestothecopydonotimpacttheoriginal,asshownwhenassigning$b=$aorp

The most direct way to find the last occurrence of a substring in PHP is to use the strrpos() function. 1. Use strrpos() function to directly obtain the index of the last occurrence of the substring in the main string. If it is not found, it returns false. The syntax is strrpos($haystack,$needle,$offset=0). 2. If you need to ignore case, you can use the strripos() function to implement case-insensitive search. 3. For multi-byte characters such as Chinese, the mb_strrpos() function in the mbstring extension should be used to ensure that the character position is returned instead of the byte position. 4. Note that strrpos() returns f

The reason why header('Location:...') in AJAX request is invalid is that the browser will not automatically perform page redirects. Because in the AJAX request, the 302 status code and Location header information returned by the server will be processed as response data, rather than triggering the jump behavior. Solutions are: 1. Return JSON data in PHP and include a jump URL; 2. Check the redirect field in the front-end AJAX callback and jump manually with window.location.href; 3. Ensure that the PHP output is only JSON to avoid parsing failure; 4. To deal with cross-domain problems, you need to set appropriate CORS headers; 5. To prevent cache interference, you can add a timestamp or set cache:f

AgeneratorinPHPisamemory-efficientwaytoiterateoverlargedatasetsbyyieldingvaluesoneatatimeinsteadofreturningthemallatonce.1.Generatorsusetheyieldkeywordtoproducevaluesondemand,reducingmemoryusage.2.Theyareusefulforhandlingbigloops,readinglargefiles,or

ToswitchdatabasesinRedis,usetheSELECTcommandfollowedbythenumericindex.Redissupportsmultiplelogicaldatabases(default16),andeachclientconnectionmaintainsitsownselecteddatabase.1.UseSELECTindex(e.g.,SELECT2)toswitchtoanotherdatabase.2.Verifywithcommands
