写了一个连接数据库的通用类,SQL语句执行有问题
有两个文件SqlTool.php和connector-test.php,SqlTool的代码如下:
class SqlTool
{
private $conn;
private $host="localhost";
private $user="root";
private $password="root";
private $db="db1";
function SqlTool()
{
$this->conn=mysql_connect($this->host,$this->user,$this->password);
if(!$this->conn)
{
echo("未连接数据库");
}
mysql_select_db($db,$this->conn);
mysql_query("set names utf8");
}
function execute_dml($sql)
{
$b=mysql_query($sql,$this->conn);
if(!$b)
{
return 0;
}
else
{
if(mysql_affected_rows($this->conn)>0)
{
return 1;
}
else
{
return 2;
}
}
}
}
?>
connector-test的代码如下:
require_once "SqlTool.php";
$sql="insert into table1 values(5,'187388','op')";
$st=new SqlTool();
$res=$st->execute_dml($sql);
if($res==0)
{
echo "执行未成功";
}
else if($res==1)
{
echo "执行成功";
}
else if($res==2)
{
echo "没有行数影响";
}
?>
现运行connector-test.php,总是显示执行未成功,不知道什么原因。望高手赐教。系统为Fedora15。
------解决方案--------------------
sql指令有错!
既然要封装数据库操作,就要把各种情况都考虑到
主要是封装错误处理
------解决方案--------------------
- PHP code
#SqlTool.php……$b=mysql_query($sql,$this->conn);#加一句:if(!$b) die("SQL-->>: {$sql} <br>Error-->>: " . mysql_error() ); //如果出错将sql语句和mysql错误全部打出来……<br><font color="#e78608">------解决方案--------------------</font><br>可能执行过一次成功插入<br><br>后来的插入因为5是主键值,失败,要打印出错误如#2。加油……封装了再写框架<div class="clear"> </div>

PHP remains a powerful and widely used tool in modern programming, especially in the field of web development. 1) PHP is easy to use and seamlessly integrated with databases, and is the first choice for many developers. 2) It supports dynamic content generation and object-oriented programming, suitable for quickly creating and maintaining websites. 3) PHP's performance can be improved by caching and optimizing database queries, and its extensive community and rich ecosystem make it still important in today's technology stack.

In PHP, weak references are implemented through the WeakReference class and will not prevent the garbage collector from reclaiming objects. Weak references are suitable for scenarios such as caching systems and event listeners. It should be noted that it cannot guarantee the survival of objects and that garbage collection may be delayed.

The \_\_invoke method allows objects to be called like functions. 1. Define the \_\_invoke method so that the object can be called. 2. When using the $obj(...) syntax, PHP will execute the \_\_invoke method. 3. Suitable for scenarios such as logging and calculator, improving code flexibility and readability.

Fibers was introduced in PHP8.1, improving concurrent processing capabilities. 1) Fibers is a lightweight concurrency model similar to coroutines. 2) They allow developers to manually control the execution flow of tasks and are suitable for handling I/O-intensive tasks. 3) Using Fibers can write more efficient and responsive code.

The PHP community provides rich resources and support to help developers grow. 1) Resources include official documentation, tutorials, blogs and open source projects such as Laravel and Symfony. 2) Support can be obtained through StackOverflow, Reddit and Slack channels. 3) Development trends can be learned by following RFC. 4) Integration into the community can be achieved through active participation, contribution to code and learning sharing.

PHP and Python each have their own advantages, and the choice should be based on project requirements. 1.PHP is suitable for web development, with simple syntax and high execution efficiency. 2. Python is suitable for data science and machine learning, with concise syntax and rich libraries.

PHP is not dying, but constantly adapting and evolving. 1) PHP has undergone multiple version iterations since 1994 to adapt to new technology trends. 2) It is currently widely used in e-commerce, content management systems and other fields. 3) PHP8 introduces JIT compiler and other functions to improve performance and modernization. 4) Use OPcache and follow PSR-12 standards to optimize performance and code quality.

The future of PHP will be achieved by adapting to new technology trends and introducing innovative features: 1) Adapting to cloud computing, containerization and microservice architectures, supporting Docker and Kubernetes; 2) introducing JIT compilers and enumeration types to improve performance and data processing efficiency; 3) Continuously optimize performance and promote best practices.


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

Atom editor mac version download
The most popular open source editor

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

WebStorm Mac version
Useful JavaScript development tools

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.