php-mysql-mysqli_connect
mysqli_connect()连接数据库,使用时发现有不能连接mysql8.0的问题,没有解决
<?php set_time_limit(0); $begin = microtime( true ); $mysqli = mysqli_connect('127.0.0.1:4404', 'user', 'passwd', 'dbname'); if(!$mysqli ){ echo mysqli_connect_error(); } $strsql = "select tb_item_id,sales_total from stat_item_mall_201908 where tb_item_id in($strtbitemid);"; $arritemsales = array(); $result = $mysqli->query($strsql); while($row = $result->fetch_assoc()){ $intsales_total = $row['sales_total']; $tb_item_id = $row['tb_item_id']; $arritemsales[$tb_item_id] = $intsales_total; } var_dump($arritemsales); $end = microtime( true ); echo "cost : ".( $end - $begin ).' sec'.PHP_EOL; exit;
。
编程改变生活
posted on 2019-08-22 09:10 coding-farmer 阅读(146) 评论(0) 编辑 收藏 举报