- 博客(5)
- 收藏
- 关注
RSS订阅原创 php执行sql语句
<?php header("Content-type:text/html;charset=gbk");?><?php$host = "127.0.0.1"; $userName = "root"; $password = "password"; $dbName = "db1"; $connID = mysql_connect($host, $userName, $password); mysql_select_db($dbName, $c
2022-02-10 16:39:38
275
原创 PHPEXCEL导出语句
define('EOL', '<br />'); $objPHPExcel = new \app\extensions\PHPExcel\PHPExcel(); ini_set("memory_limit", "1024M"); // 设置php可使用内存 $cacheMethod = \PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip; if (!\PHPExcel_Settings::...
2022-02-10 16:25:52
74
原创 mysql获取oracle数据库的数据查询
////////////oracle beginconn=ociconnect("user","password","db");if(!conn = oci_connect("user","password","db");if (!conn=ociconnect("user","password","db");if(!conn) {e=ocierror();triggererror(htmlentities(e = oci_error(); trigger_error(htmlentitie
2022-02-10 16:21:25
1306
原创 mysql数据转换成excel数据
//mysql数据转换成excel数据excel的日期时间 = (MySQL时间数据+8*3600)/86400+25569//excel数据转换成时间戳mzinfo=(mzinfo=(mzinfo=(mzinfo-70*365-19)86400-83600//将时间戳转换成2019-07-12，用date(“Y-m-d H:i:s”，1513264258); // 2017-12-14 23:13:51mzinfo[′data′]=date("Y−m−d",mzinfo['data']=dat
2022-02-10 16:17:40
271
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人