How to solve Mysql to mysql as I have some problems

Question

Th problem: it says

Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /Applications/XAMPP/xamppfiles/htdocs/...

I think I have change mysql to mysql but how?

<?php

    $database="sphider_db";
    $mysql_user = "root";
    $mysql_password = ""; 
    $mysql_host = "localhost";
    $mysql_table_prefix = "";



    $success = mysql_pconnect ($mysql_host, $mysql_user, $mysql_password);
    if (!$success)
        die ("<b>Cannot connect to database, check if username, password and host are correct.</b>");
    $success = mysql_select_db ($database);
    if (!$success) {
        print "<b>Cannot choose database, check if database name is correct.";
        die();
    }
?>

score 0 · Answer 1 · edited May 23 '17 at 12:23

0

You have to stop using mysql_* functions. These extensions have been removed in PHP 7. Learn about prepared statements for PDO and MySQLi and consider using PDO, it's really pretty easy.

edited May 23 '17 at 12:23

Community

1
1

answered Jan 19 '16 at 20:31

Jay Blanchard

34,243
16
77
119

"Thank you very much, I need PDO..." – Pinalla Jan 19 '16 at 20:32

Abdulla Nilam · Accepted Answer · 2016-01-19T20:42:22.933

0

MySQL extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used.

Use MySQLi-connect insted of MySQL_connect
as well as instead of mysql_select_db use mysqli_select_db

EDIT 01

in mysqli_connect you can select database too

$link = mysqli_connect("127.0.0.1", "my_user", "my_password", "my_db");

edited Jan 19 '16 at 20:42

answered Jan 19 '16 at 20:31

Abdulla Nilam

36,589
17
64
85

"When I change mysql_connect to mysql_connect then I face this problem: Cannot choose database, check if database name is correct." – Pinalla Jan 19 '16 at 20:38
@Pinalla check my answer. i have mention all – Abdulla Nilam Jan 19 '16 at 20:41
Should I change all the mysql to mysqli... – Pinalla Jan 19 '16 at 20:47
2

@Pinalla needs to go read the tutorials for both API's, then make a selection and learn to code for that selection. It isn't as simple as trading one function name for another. – Jay Blanchard Jan 19 '16 at 20:47
@Pinalla [check this link](http://php.net/manual/en/function.mysqli-connect.php#refsect1-function.mysqli-connect-examples). you can easily identify this – Abdulla Nilam Jan 19 '16 at 20:49
@Pinalla happy to help :) – Abdulla Nilam Feb 08 '16 at 11:28

How to solve Mysql to mysql as I have some problems

2 Answers2

Linked