$conn = mysqli_connect($hostname, $username, $password,$database) or trigger_error(mysql_error(),E_USER_ERROR);% ^& d: y; e( }, r# B
mysqli_query($conn ,"SET NAMES utf8"); 7 F$ {: T8 T. ]& t6 F
( y2 r# m7 z; [: t r3 \
$sql = "select count(*) as total from " . "table_name"; ! D& p/ I; \% U- o
$rec = mysqli_fetch_assoc(mysqli_query( $conn,$sql));& `# b+ I9 v- L
echo $rec['total']; & q& ?+ c" e1 ]3 Y. b: {2 y7 s- l
mysqli_close($conn);4 h6 ` m- w/ r/ G H
?>
複製代碼
[hide=d100000000000000000000,999999999999]於video1主機下 /test/connectmysql8.php[/hide] % ]" m1 s, {% [8 s. [! l5 Q2 F# u$ l7 T
: U, n- L( x6 V6 M: k: i) |% i, O當php 7.2.24 connect to mysql server,出現 :
PHP Fatal error: Uncaught Error: Call to undefined function mysqli_connect() in /test/connectmysql8.php:9- L6 v' U# l' Y d
Stack trace:- ^, O* ]: j' f- Q
#0 {main} . V4 \7 l4 O* \
thrown in /test/connectmysql8.php on line 9 $ [1 X. j( c( f* \' A
: v# B, C! I9 y* W
Fatal error: Uncaught Error: Call to undefined function mysqli_connect() in /test/connectmysql8.php:9+ V* t3 A5 u n' N7 G$ r
Stack trace: 6 S8 e0 U1 U& g3 ~7 j' |4 s8 e
#0 {main} 8 W4 c0 T9 o3 T" u3 \8 h' v
thrown in /test/connectmysql8.php on line 9
複製代碼
這是版本相依的問題,只要 yum install php-mysqlnd 或 yum install php-mysqli 即可8 [7 P/ F# |! t' [, k+ T1 b
0 O1 u8 a0 `5 s# H
/ A( J- I! s. `/ a
[Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 5 S$ R- C% W7 S \( a1 U" M7 @( f說明: 千萬不能照它建議用"UTF8MB4",否則無法成功啟動" c$ ?8 g5 d6 S0 d* ^% x
% |& x8 @, \3 S; `6 n; b
(2) ! y$ E- [' J7 A/ F# t% ~& @1 M; r4 v5 D(1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'system>0' at line 1 / Y, h1 K+ @7 f0 D% T2 OSELECT COUNT(*) FROM common_usergroup WHERE type='special' and system>0+ b* N2 [' E" Q. R
8 Q8 @$ G" E* k! P3 { G(1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups = '' AND starttime<=1532077291 AND (endtime>=1532077291 OR endtime=0) ORD' at line 1 9 h) n+ ]8 M+ x ^SELECT * FROM forum_announcement WHERE type!=2 AND groups = '' AND starttime<=1532077291 AND (endtime>=1532077291 OR endtime=0) ORDER BY displayorder, starttime DESC, id DESC LIMIT 1# z, o6 Q& @# v0 D! w( }+ ~