简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

MySQL PHP syntax

巴扎黑
Release： 2016-11-29 09:05:42
Original
1236 people have browsed it

MySQL can be used in multiple languages, including PERL, C, C++, JAVA and PHP. Among these languages, MySQL is the most widely used in PHP web development.

PHP provides multiple ways to access and operate Mysql database records.

PHP Mysql function format is as follows:

mysql_function(value,value,...);

The function part in the above format describes the function of the mysql function, such as:

mysqli_connect($connect);

mysqli_query($ connect,"SQL statement");

mysql_fetch_array()

mysql_connect()

mysql_close()

The following template shows the syntax for calling mysql functions in PHP: 

<html>
<head>
<meta charset="utf-8"> 
<title>PHP MySQL</title>
</head>
<body>
<?php
   $retval = mysql_function(value, [value,...]);
   if( !$retval )
   {
       die ( "相关错误信息" );
   }
   // 其他 MySQL 或 PHP 语句
?>
</body>
</html>
Copy after login


Related labels：
mysql
source：php.cn
Previous article：The solution process for viewing garbled mysql data in phpmyadmin Next article：Simple steps to install phpMyAdmin on centos 6.3
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
Latest Articles by Author
Latest Issues
How to list data in a section by ID using while loop in PHP? I have a mysql table with these columns: series_id, series_color, product_name In the outp...
From 2023-11-17 20:03:03
0
1
290
Using triggers and constraints to limit the number of records in MySQL I have a table called BFFs that stores user IDs and best friends' user IDs, and I want to ...
From 2023-11-14 13:35:02
0
4
434
Resolving django.db.utils.NotSupportedError error in Django I'm getting an error when running a project in Django. The problem is unfortunately I upgr...
From 2023-11-14 11:59:20
0
1
246
Retrieve MySql rows with the same column value Let us consider the following table - IDScore19521003884100573 I am a complete SQL noob, b...
From 2023-11-10 21:53:39
0
2
331
How to publish SQLite database data to an online MySQL database in Flutter? How to sync offline SQLite to MySQL online database in Flutter? Any suggestions?
From 2023-11-10 12:36:40
0
2
247
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！