Since PHP 5.4, the original MySQL extension is obsolete and will generate alerts E_DEPRECATED level when connecting to a database. Instead, we can use the MySQLi extension or PDO_MySQL extension.<\/p>\n
If like me, you have sites with the MySQL extension, here are some small examples to switch to MySQL MySQLi (which I find easier to use on my little creations).<\/p>\n
Database connection<\/strong> Code PHP :<\/p>\n Now, with MySQLi :<\/strong><\/p>\n <?php<\/p>\n \/\/ Connection variables \/\/ Connect to MySQL Database \/\/ Check connection ?><\/p>\n <\/p>\n <\/p>\n MySQLi procedural methods use a parameter that references either an object link or a result object. We have seen the reference to the object link when we dealt with mysqli_select_db. The result object is similar to a MySQL result returned from a query, for example.<\/p>\n<\/div>\n Many of the methods in MySQL have very similar procedural methods in MySQLi, and are as simple to migrate as adding the i to mysql and adding or moving the link or result to the first parameter. Remember that MySQLi requires the link for those methods that reference a link. In the following list, the MySQL statement is followed by the replacement MySQLi procedural method.<\/p>\n<\/div>\n mysql_affected_rows<\/b> -> mysqli_affected_rows($link) <\/p>\n","protected":false},"excerpt":{"rendered":" Introduction Since PHP 5.4, the original MySQL extension is obsolete and will generate alerts E_DEPRECATED level when connecting to a database. Instead, we can use the MySQLi extension or PDO_MySQL extension. If like me,...<\/p>\n","protected":false},"author":1,"featured_media":2845,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35,25],"tags":[],"youtube_video":null,"_links":{"self":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/2733"}],"collection":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2733"}],"version-history":[{"count":0,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/2733\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/2845"}],"wp:attachment":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nPreviously, MySQL, connect to the database was thus:<\/p>\n\u00a0\r\n\/\/ we connect to MySQL\r\n$conn = mysql_connect<\/a>('$host', '$user', '$passwd');\r\n\r\n\/\/ we select database\r\nmysql_select_db<\/a>('mabase',$conn);<\/pre>\n<\/div>\n
\n$host = “localhost”; \/\/ MySQL host name eg. localhost
\n$user = “user1”; \/\/ MySQL user. eg. root ( if your on localserver)
\n$password = “”; \/\/ MySQL user password\u00a0 (if password is not set for your root user then keep it empty )
\n$database = “zzz”; \/\/ MySQL Database name<\/p>\n
\n$link = mysqli_connect($host, $user, $password, $database);<\/p>\n
\nif (mysqli_connect_errno())
\n{
\necho “Failed to connect to MySQL: ” . mysqli_connect_error();
\n}<\/p>\nLes requ\u00eates<\/h1>\n
Migrating to MySQLi Procedural Methods<\/h2>\n<\/div>\n
\nmysql_close<\/b> -> mysqli_close($link)
\nmysql_data_seek<\/b> -> mysqli_data_seek( $result, $offset)
\nmysql_errno<\/b> -> mysqli_errno( $link)
\nmysql_error<\/b> -> mysqli_error( $link)
\nmysql_fetch_array<\/b> -> mysqli_fetch_array( $result, $type)
\nmysql_fetch_assoc<\/b> -> mysqli_fetch_assoc( $result)
\nmysql_fetch_lengths<\/b> -> mysqli_fetch_lengths( $result )
\nmysql_fetch_object<\/b> -> mysqli_fetch_object( $result, $class, $params)
\nmysql_fetch_row<\/b> -> mysqli_fetch_row( $result)
\nmysql_field_seek<\/b> -> mysqli_field_seek( $result, $number)
\nmysql_free_result<\/b> -> mysqli_free_result(result)
\nmysql_get_client_info<\/b> -> mysqli_get_client_info( $link)
\nmysql_get_host_info<\/b> -> mysqli_get_host_info( $link)
\nmysql_get_proto_info<\/b> -> mysqli_get_proto_info( $link)
\nmysql_get_server_info<\/b> -> mysqli_get_server_info( $link)
\nmysql_info<\/b> -> mysqli_info( $link)
\nmysql_insert_id<\/b> -> mysqli_insert_id( $link)
\nmysql_num_rows<\/b> -> \u00a0mysqli_num_rows( $result)
\nmysql_ping<\/b> -> mysqli_ping( $link)
\nmysql_query<\/b> -> mysqli_query( $link, $query)
\nmysql_real_escape_string<\/b> -> mysqli_real_escape_string( $link)
\nmysql_select_db<\/b> – > mysqli_select_db( $link, $database)
\nmysql_set_charset<\/b> -> mysqli_set_charset( $link, $charset)
\nmysql_stat<\/b> -> mysqli_stat( $link)
\nmysql_thread_id<\/b> -> mysqli_thread_id( $link)<\/p>\n<\/div>\n