


Newbie asking for help: php database error, Fatal error: Call to a member function exec() on a non-object in
Today I sorted out the previous pdo database encapsulation class, but when using it, an error was reported. Fatal error: Call to a member function exec() on a non-object in sqlcontrol.class.php on line 45. This is a complete error. Tip, this error did not occur when there was no modification before. What is going on?
This is the class I use
<code><span><?php</span>header(<span>"content-type:text/html;charset=utf-8"</span>); <span><span>class</span><span>dbPdoManger</span> {</span><span>private</span><span>$conn</span>=<span>''</span>;<span>//连接数据库服务器的资源类型</span><span>private</span><span>$host</span>=<span>""</span>;<span>//主机地址</span><span>private</span><span>$dbname</span>=<span>""</span>;<span>//数据库名称</span><span>private</span><span>$user</span>=<span>""</span>;<span>//数据库用户名</span><span>private</span><span>$pwd</span>=<span>""</span>;<span>//密码</span><span>private</span><span>$charset</span>=<span>""</span>;<span>//链接编码</span><span>private</span><span>$config</span>=<span>array</span>(); <span>/* * 构造函数初始化数据库 * 变量: $host连接的服务器名称 * $user登陆服务器的用户名 * $pwd登陆服务器的密码 */</span><span>public</span><span><span>function</span><span>__construct</span><span>(<span>$config</span>)</span> {</span><span>$this</span>->config=<span>$config</span>; <span>$this</span>->host=<span>$this</span>->config[<span>"host"</span>]; <span>$this</span>->dbname=<span>$this</span>->config[<span>"dbname"</span>]; <span>$this</span>->user=<span>$this</span>->config[<span>"user"</span>]; <span>$this</span>->pwd=<span>$this</span>->config[<span>"pwd"</span>]; <span>$this</span>->charset=<span>$this</span>->config[<span>"charset"</span>]; <span>//$this->open();</span> } <span>/* * 打开数据库 */</span><span>public</span><span><span>function</span><span>open</span><span>()</span> {</span><span>$this</span>->conn=<span>new</span> PDO(<span>"mysql:host="</span>.<span>$this</span>->host.<span>";dbname="</span>.<span>$this</span>->dbname,<span>$this</span>->user,<span>$this</span>-pwd); <span>$this</span>->conn->query(<span>'set names '</span>.<span>$this</span>->charset); <span>echo</span><span>$this</span>->conn; } <span>/* * 增删改 */</span><span>public</span><span><span>function</span><span>execSql</span><span>(<span>$sql</span>)</span> {</span><span>$bool</span>=<span>$this</span>->conn->exec(<span>$sql</span>); <span>if</span>(<span>$bool</span>><span>0</span>) { <span>return</span><span>true</span>; }<span>else</span> { <span>return</span><span>false</span>; } } <span>/* * 查询一条数据 */</span><span>public</span><span><span>function</span><span>quer</span><span>(<span>$sql</span>,<span>$mode</span>=PDO::FETCH_ASSOC)</span> {</span><span>$result</span>=<span>$this</span>->conn->query(<span>$sql</span>); <span>$result</span>->setFetchMode(<span>$mode</span>); <span>$re</span>=<span>$result</span>->fetch(); <span>$result</span>=<span>null</span>; <span>return</span><span>$re</span>; } <span>/* * 查询多条数据 */</span><span>public</span><span><span>function</span><span>querMore</span><span>(<span>$sql</span>,<span>$mode</span>=PDO::FETCH_ASSOC)</span> {</span><span>$result</span>=<span>$this</span>->conn->query(<span>$sql</span>); <span>$result</span>->setFetchMode(<span>$mode</span>); <span>$re</span>=<span>$result</span>->fetchAll(); <span>$result</span>=<span>null</span>; <span>return</span><span>$re</span>; } <span>/*查询指定表中有多少条记录*/</span><span>public</span><span><span>function</span><span>getTabRows</span><span>(<span>$key</span>,<span>$tableName</span>,<span>$where</span>)</span> {</span><span>$sql</span>=<span>"select count("</span>.<span>$key</span>.<span>") as 'c' from "</span>.<span>$tableName</span>.<span>" where "</span>.<span>$where</span>.<span>""</span>; <span>$result</span>=<span>$this</span>->conn->query(<span>$sql</span>); <span>$result</span>->setFetchMode(PDO::FETCH_ASSOC); <span>$re</span>=<span>$result</span>->fetch(); <span>$result</span>=<span>null</span>; <span>return</span> intval(<span>$re</span>[<span>'c'</span>]); } <span>/*关闭数据库*/</span><span>public</span><span><span>function</span><span>closeConn</span><span>()</span> {</span><span>$this</span>->conn=<span>null</span>; } } <span>?></span></span></code>
The following is the code I use to call this class
<code><span><span><?php</span> header(<span>"content-type:text/html;charset=utf-8"</span>); <span>include</span><span>"sqlcontrol.class.php"</span>; <span>$config</span>[<span>"host"</span>]=<span>"localhost"</span>; <span>$config</span>[<span>"dbname"</span>]=<span>"biaodan"</span>; <span>$config</span>[<span>"user"</span>]=<span>"root"</span>; <span>$config</span>[<span>"pwd"</span>]=<span>""</span>; <span>$config</span>[<span>"charset"</span>]=<span>"utf-8"</span>; <span>$db</span>=<span>new</span> dbPdoManger(<span>$config</span>); <span>$sql</span>=<span>"INSERT INTO `test` (`name`, `nicheng`, `password`, `sex`, `icon`, `cardid`, `city`, `phone`, `qq`, `mail`, `liuyan`) VALUES ('t', 't', 't', 't, 't', '1315', 'tttt', '598562', '79874564', 'tret', 'werterter')"</span>; <span>echo</span><span>$db</span>->execSql(<span>$sql</span>);</span></span></code>
Please help me. . .
The above introduces the beginner's help: PHP database error, Fatal error: Call to a member function exec() on a non-object in, including the content. I hope it will be helpful to friends who are interested in PHP tutorials.

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

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

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

While installing a new version of an application, Windows may display this error message "An error occurred while parsing C:\\Windows\Microsoft.Net\Framework\v2.0.50727\Config\machine.configParser returned error 0xC00CE556". This problem also occurs when your system boots. No matter what situation you encounter this problem, .NETFramework is the real culprit behind the scenes. There are some very simple fixes you can use to stop this error code from appearing again. Fix 1 – Replace corrupted files You can easily replace corrupted ma from the original directory

Why Snipping Tool Not Working on Windows 11 Understanding the root cause of the problem can help find the right solution. Here are the top reasons why the Snipping Tool might not be working properly: Focus Assistant is On: This prevents the Snipping Tool from opening. Corrupted application: If the snipping tool crashes on launch, it might be corrupted. Outdated graphics drivers: Incompatible drivers may interfere with the snipping tool. Interference from other applications: Other running applications may conflict with the Snipping Tool. Certificate has expired: An error during the upgrade process may cause this issu simple solution. These are suitable for most users and do not require any special technical knowledge. 1. Update Windows and Microsoft Store apps

With the continuous development of the PHP language, ThinkPHP, which is widely used in the PHP back-end framework, is also constantly improving. As business scenarios become increasingly complex, the demand for configuration management in ThinkPHP is also increasing. In this context, ThinkPHP provides rich configuration management functions. Today we will introduce how to implement configuration management through ThinkPHPConfig. 1. Introduction to ThinkPHPConfig ThinkPHPConfig is Thin

In Java, private means "private" and is an access control modifier used to modify classes, properties and methods. Class members modified with private can only be accessed and modified by the methods of the class itself, and cannot be accessed and referenced by any other class (including subclasses of the class); therefore, the private modifier has the highest level of protection.

1. Introduction to CodeIgniter CodeIgniter is a lightweight and comprehensive PHP development framework designed to provide web developers with fast and powerful tools to build web applications. It is an open source framework that uses the MVC architecture pattern to achieve rapid development and basic functions, while supporting a variety of databases. 2. Introduction to the Config library The Config library is a component in the CodeIgniter framework and is used to configure and manage code. The Config library contains many

Part 1: Initial Troubleshooting Steps Checking Apple’s System Status: Before delving into complex solutions, let’s start with the basics. The problem may not lie with your device; Apple's servers may be down. Visit Apple's System Status page to see if the AppStore is working properly. If there's a problem, all you can do is wait for Apple to fix it. Check your internet connection: Make sure you have a stable internet connection as the "Unable to connect to AppStore" issue can sometimes be attributed to a poor connection. Try switching between Wi-Fi and mobile data or resetting network settings (General > Reset > Reset Network Settings > Settings). Update your iOS version:

php提交表单通过后,弹出的对话框怎样在当前页弹出php提交表单通过后,弹出的对话框怎样在当前页弹出而不是在空白页弹出?想实现这样的效果:而不是空白页弹出:------解决方案--------------------如果你的验证用PHP在后端,那么就用Ajax;仅供参考:HTML code
