blocks|key|2889345|text|PHP7已经完全删除了mysql_*。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2889346|您需要使用PDO或mysqli。Wordpress似乎不支持这一点。|2889347|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

PHP 7 has removed mysql_* completely.

You need to use PDO or mysqli. Wordpress seems not to support this.

blocks|key|124042|text|在PHP7.0中删除的mysql_*函数将您的代码更新为mysqli或PDO|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|124043|如果您正在处理用户输入，还可以查看准备好的语句。减少SQL+injections的机会|124044|mysqli连接字符串示例：|124045|<?php
$mysqli+=+new+mysqli("localhost",+"user",+"password",+"database");
if+($mysqli->connect_errno)+{
++++echo+"Failed+to+connect+to+MySQL:+("+.+$mysqli->connect_errno+.+")+"+.+$mysqli->connect_error;
}
?>|code-block|syntax|javascript|124046|pdo连接字符串示例：|124047|<?php
++++$dbh+=+new+PDO('mysql:host=localhost;dbname=test',+$user,+$pass);
?>+|124048|注意：|124049|该mysqli示例处理连接错误|124050|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/book.mysqli.php|1|http://php.net/manual/en/book.pdo.php|2|https://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php^0|B|7|S|6|0|Z|3|1|0|Q|E|2|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@$9|19|A|1A|B|C]]|D|@$9|1B|A|1C|1|1D]|$9|1E|A|1F|1|1G]]|E|$]]|$1|F|3|G|5|6|7|1H|8|@]|D|@$9|1I|A|1J|1|1K]]|E|$]]|$1|H|3|I|5|6|7|1L|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|1M|8|@]|D|@]|E|$M|N]]|$1|O|3|P|5|6|7|1N|8|@]|D|@]|E|$]]|$1|Q|3|R|5|L|7|1O|8|@]|D|@]|E|$M|N]]|$1|S|3|T|5|6|7|1P|8|@]|D|@]|E|$]]|$1|U|3|V|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|W|3|-4|5|6|7|1R|8|@]|D|@]|E|$]]]|X|$Y|$5|Z|10|11|E|$12|13]]|14|$5|Z|10|11|E|$12|15]]|16|$5|Z|10|11|E|$12|17]]]]

<code>mysql_*</code> functions got deleted in PHP 7.0 update your code to <a href="http://php.net/manual/en/book.mysqli.php" rel="nofollow noreferrer">mysqli</a> or <a href="http://php.net/manual/en/book.pdo.php" rel="nofollow noreferrer">PDO</a>

Also take a look at prepared statements if you are handling user input. To reduce the chance of <a href="https://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php">SQL injections</a>

An example of mysqli connection string:

<pre><code>&lt;?php
$mysqli = new mysqli("localhost", "user", "password", "database");
if ($mysqli-&gt;connect_errno) {
 echo "Failed to connect to MySQL: (" . $mysqli-&gt;connect_errno . ") " . $mysqli-&gt;connect_error;
}
?&gt;
</code></pre>

An example of pdo connection string:

<pre><code>&lt;?php
 $dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);
?&gt; 
</code></pre>

Note:

That mysqli example handles a connection error

blocks|key|122144|text|检查Wordpress是否仍在使用PHP7中删除的Mysql扩展。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|122145|http://php.net/manual/en/migration70.removed-exts-sapis.php|offset|length|122146|保留了Mysqli和PDO扩展。这就是你的其他网站正常工作的原因。|122147|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1N|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

Check if the Wordpress still using the Mysql extension that was removed in PHP7.

<a href="http://php.net/manual/en/migration70.removed-exts-sapis.php" rel="nofollow">http://php.net/manual/en/migration70.removed-exts-sapis.php</a>

The Mysqli and PDO extensions were kept. This is the reason your other websites are working.

blocks|key|122149|text|正如在其他地方提到的，ext/mysql函数已被删除。我们被talking+about+this+for+some+time了。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|122150|MySQL+/+|122151|是为MySQL+3.23构建的，从那时起只增加了很少的内容，同时大部分都保持了与这个旧版本的兼容性，这使得代码更难维护。|blockquote|122152|122153|122154|如果您非要把它们放回原处，可以使用ext/mysql+PECL+Library将它们重新添加到PHP7中|122155|需要注意的是，Wordpress+3.9+or+later+supports+mysqli|122156|122157|在WordPress+3.9中，我们向WPDB添加了一个额外的层，使它在使用PHP5.5或更高版本时切换到使用mysqli+PHP库。|122158|122159|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php|1|https://pecl.php.net/package/mysql|2|https://make.wordpress.org/core/2014/04/07/mysql-in-wordpress-3-9/^0|B|9|U|W|0|0|0|0|0|0|H|M|1|0|7|12|2|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@$9|17|A|18|B|C]]|D|@$9|19|A|1A|1|1B]]|E|$]]|$1|F|3|G|5|6|7|1C|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|1D|8|@]|D|@]|E|$]]|$1|K|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|1F|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|1G|8|@]|D|@$9|1H|A|1I|1|1J]]|E|$]]|$1|O|3|P|5|6|7|1K|8|@]|D|@$9|1L|A|1M|1|1N]]|E|$]]|$1|Q|3|-4|5|6|7|1O|8|@]|D|@]|E|$]]|$1|R|3|S|5|J|7|1P|8|@]|D|@]|E|$]]|$1|T|3|-4|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|U|3|-4|5|6|7|1R|8|@]|D|@]|E|$]]]|V|$W|$5|X|Y|Z|E|$10|11]]|12|$5|X|Y|Z|E|$10|13]]|14|$5|X|Y|Z|E|$10|15]]]]

As has been mentioned elsewhere, the <code>ext/mysql</code> functions have been removed. We've been <a href="https://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php">talking about this for some time</a>.

<blockquote>
 ext/mysql was built for MySQL 3.23 and only got very few additions since then while mostly keeping compatibility with this old version which makes the code a bit harder to maintain.
</blockquote>

If you're hell-bent on putting them back in, you can add them back to PHP 7 by using the <a href="https://pecl.php.net/package/mysql" rel="nofollow noreferrer">ext/mysql PECL Library</a>

It's important to note that <a href="https://make.wordpress.org/core/2014/04/07/mysql-in-wordpress-3-9/" rel="nofollow noreferrer">Wordpress 3.9 or later supports mysqli</a>

<blockquote>
 In WordPress 3.9, we added an extra layer to WPDB, causing it to switch to using the mysqli PHP library, when using PHP 5.5 or higher.
</blockquote>

blocks|key|2889393|text|该问题是由php+7.1.0-dev引起的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2889394|我用相同的配置版本7.0.0构建了另一个，这个问题已经解决了。|2889395|这与WordPress无关，因为当找不到MySQL时，它会自动尝试使用MySQLi。至少在WP4.4中是这样。|2889396|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

This issue is caused by php 7.1.0-dev. 

I built another one with the same configuration version 7.0.0 and the issue was resolved.

This has nothing to do with WordPress since it will automatically try to use MySQLi when MySQL is not found. At least in WP 4.4.

blocks|key|2677719|text|在Ubuntu上，我通过运行以下命令修复了这个错误|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2677720|sudo+apt-get+install+php-mysql|code-block|syntax|javascript|2677721|然后重新启动我的服务器(caddy，但您可能正在使用apache或nginx)。|2677722|source|offset|length|2677723|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/37083448/3006854^0|0|0|0|0|6|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

On Ubuntu, I fixed this error by running

<pre><code>sudo apt-get install php-mysql
</code></pre>

And then restarting my server (caddy, but you might be using apache or nginx). 

<a href="https://stackoverflow.com/a/37083448/3006854">source</a>

I have built PHP 7 with a configuration that worked for a previous version of PHP.
Now my WordPress websites get the message: 

<blockquote>
 Your PHP installation appears to be missing the MySQL extension which is required by WordPress.
</blockquote>

Other websites using mysqli do work. What am I missing?

I've also included all .so files with mysql in the name:

<pre><code>extension=dba.so
extension=mysql.so
extension=mysqli.so
extension=mysqlnd_mysql.so
extension=mysqlnd_mysqli.so
extension=mysqlnd.so
extension=pdo.so
extension=pdo_mysql.so
extension=pdo_odbc.so
extension=odbc.so
</code></pre>

Compiled PHP 7 missing mysql extension in WordPress

服务器

WordPress

Ubuntu

MySQL

我已经构建了PHP7，其配置适用于上一版本的PHP。现在我的WordPress网站得到了这样的信息：您的PHP安装似乎缺少WordPress所需的MySQL扩展。其他使用mysqli的网站也可以使用。我遗漏了什么？我还在名称中包含了所有带有mysql的.so文件：extension=dba.soextension=my...

问编译后的PHP7在WordPress中缺少mysql扩展
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问编译后的PHP7在WordPress中缺少mysql扩展EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问编译后的PHP7在WordPress中缺少mysql扩展
EN