HOME | PHP Tutorial | CSS
facebook icon
AgerNic.com
WEB DEVELOPER SITE, HTML, CSS, PHP
HTML Tutorial

CSS Tutorial

mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in - How to fix



mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/..../..


Example: How to fix.
<?php
$result = mysql_query("select keyword_ID, keyword from ".$mysql_table_prefix."keywords");
echo mysql_error();
while($row=mysql_fetch_array($result)) {
$all_keywords[addslashes($row[1])] = $row[0];
}
?>

how to solve it?
Alternatives to this function mysql_query() use: mysqli_query() as much:

Example: use mysqli_query()
<?php
$result = mysqli_query($link, "select keyword_ID, keyword from ".$mysql_table_prefix."keywords");
echo mysqli_connect_error();
while($row=mysqli_fetch_array($result)) {
$all_keywords[addslashes($row[1])] = $row[0];
}
?>




mysql_query Mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in - php tutorial

2595. The loop statement: for, do...while, foreach and we add break - continue statement in PHP, php tutorial
The loop statement: for, do...while, foreach and we add break - continue statement in PHP php tutorial
http://www.agernic.com/php-tutorial/for-do-while-foreach-break-continue-in-php.html

3364. PHP Summary
Provides a summary to this PHP tutorial.
https://www.quackit.com/php/tutorial/php_summary.cfm

3224. PHP Syntax, php tutorial
PHP Syntax php tutorial
https://www.agernic.com/php-tutorial/php-syntax.html

2602. PHP Install, php tutorial
PHP Install php tutorial
http://www.agernic.com/php-tutorial/php-install.html

3362. PHP Mail
Use PHP to send email with this PHP tutorial.
https://www.quackit.com/php/tutorial/php_mail.cfm

2601. PHP echo and print Statements, php tutorial
PHP echo and print Statements php tutorial
http://www.agernic.com/php-tutorial/php-echo-and-print-statements.html

Your add here
How to get PHP errors to display?
How to prevent sql injection in php mysqli
How do I get PHP errors to display - PHP error_reporting()
mysql_query(): The mysql extension is deprecated and will be removed i
Function eregi_replace() is deprecated in php - How to fix
PHP delete an element from an array
Uncaught Error: Call to undefined function MYSQL_NUM_ROWS() in
Deprecated: mysql_connect() mysql extension is deprecated and will be
mysqli_fetch_array() expects parameter 1 to be mysqli_result boolean g
SQL IN Operator - example
SQL BETWEEN Operator
SQL like syntax and example
SQL WHERE AND & OR multiple conditions
SQL create table primary key autoincrement
PHP mysqli_connect () Function
SQL COUNT(), AVG() and SUM() Functions
Display data from SQL database with MySQLi into php - html table
SQL CREATE DATABASE - example
SQL mysql order by columns, by date, by asc, by desc, random with PHP
PHP mysqli_query() Function - mysqli query
SQL delete row - SQL delete table
SQL update - SQL update select
Insert into SQL - Insert into table SQL - Insert data in sql
Login in PHP - simple login script with PHP MYSQL