Home Backend Development PHP Tutorial php连接数据库的有关问题

php连接数据库的有关问题

Jun 13, 2016 am 10:18 AM
mysql name nbsp quot

php连接数据库的问题
$link=mysql_connect("localhost","root","906200");  
 mysql_select_db("manage");
$sql="select * from commodity where commodity_name=".$name;/////////报错说这句不对!!!????
$result=mysql_query($sql)or die(mysql_error());
$num = mysql_num_rows($result);
echo $num;
if($num>0){
while($rs=mysql_fetch_object($result))
  {
  $c_id=$rs->commodity_id;
  $c_name=$rs->commodity_name;
  $c_kind=$rs->commodity_kind;
  $c_price=$rs->commodity_buyprice;
  echo "

". $c_id." ".$c_name." ".$c_kind." ". $c_price." ";
  }
  mysql_close(); 
}



已经验证前一网页把值成功传入$name,报错说You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''select * from commodity where commodity_name='饼干' at line 1 

这是为什么嘞。。。。。。(表名是commodity)
 
 


------解决方案--------------------
$sql="select * from commodity where commodity_name='$name'";
------解决方案--------------------
查找/更新/插入的字段如果是 varchar,char,text等类型 需要使用引号将内容括起来.
------解决方案--------------------
贴出出错时的 $sql

big5_chinese_ci ???
你的 $name 是什么编码的?
------解决方案--------------------
=两边的编码不一致一个是latin1_swedish_ci 一个是big5_chinese_ci
注意统一编码
------解决方案--------------------
在你连接数据库时加上:mysql_query(“set names gbk”);
------解决方案--------------------
utf8_general_ci
然后你的php,html文件都保存为UTF-8格式。就不会再有乱码的困扰了
------解决方案--------------------
说的是,一个个改为utf8_general_ci,这是最通用的
注意:对于int型变量不用改
主要改三点,
一是数据库类型有一个地方
二是表属性有一个地方
三是每个字段非int型都有一个地方
连接数据库后
mysql_query("set NAMES utf-8");
以后所有的中文操作都不用你再担心编码问题出现
(多注意chatset=utf-8;或是php页面属性dw改为utf-8)
------解决方案--------------------
windows环境的话就全用gbk,linux环境就全用utf8,包括html的http-equiv,数据库编码,php文件编码(与系统locale相同)。
------解决方案--------------------
统一编码

首先,确定你的文件的字符编码,第二,确定你数据库连接时输入输出的编码,第三,确定你数据库,表,字段的字符编码。这些药全部一致才行

最好都用UTF-8。我一般用的是utf8_general_ci
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

Video Face Swap

Video Face Swap

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

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)

MySQL's Role: Databases in Web Applications MySQL's Role: Databases in Web Applications Apr 17, 2025 am 12:23 AM

The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.

Laravel Introduction Example Laravel Introduction Example Apr 18, 2025 pm 12:45 PM

Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.

How to start mysql by docker How to start mysql by docker Apr 15, 2025 pm 12:09 PM

The process of starting MySQL in Docker consists of the following steps: Pull the MySQL image to create and start the container, set the root user password, and map the port verification connection Create the database and the user grants all permissions to the database

Solve database connection problem: a practical case of using minii/db library Solve database connection problem: a practical case of using minii/db library Apr 18, 2025 am 07:09 AM

I encountered a tricky problem when developing a small application: the need to quickly integrate a lightweight database operation library. After trying multiple libraries, I found that they either have too much functionality or are not very compatible. Eventually, I found minii/db, a simplified version based on Yii2 that solved my problem perfectly.

How to install mysql in centos7 How to install mysql in centos7 Apr 14, 2025 pm 08:30 PM

The key to installing MySQL elegantly is to add the official MySQL repository. The specific steps are as follows: Download the MySQL official GPG key to prevent phishing attacks. Add MySQL repository file: rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm Update yum repository cache: yum update installation MySQL: yum install mysql-server startup MySQL service: systemctl start mysqld set up booting

Centos install mysql Centos install mysql Apr 14, 2025 pm 08:09 PM

Installing MySQL on CentOS involves the following steps: Adding the appropriate MySQL yum source. Execute the yum install mysql-server command to install the MySQL server. Use the mysql_secure_installation command to make security settings, such as setting the root user password. Customize the MySQL configuration file as needed. Tune MySQL parameters and optimize databases for performance.

Laravel framework installation method Laravel framework installation method Apr 18, 2025 pm 12:54 PM

Article summary: This article provides detailed step-by-step instructions to guide readers on how to easily install the Laravel framework. Laravel is a powerful PHP framework that speeds up the development process of web applications. This tutorial covers the installation process from system requirements to configuring databases and setting up routing. By following these steps, readers can quickly and efficiently lay a solid foundation for their Laravel project.

MySQL and phpMyAdmin: Core Features and Functions MySQL and phpMyAdmin: Core Features and Functions Apr 22, 2025 am 12:12 AM

MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.

See all articles