求教,谢谢
用的是ci框架, $urlpath = base_url()." ../upload/image/".$value['userpic'];没有启作用,它当成字符串连接了,这里要用转义吗?还是?
$objPHPExcel->getActiveSheet()->setCellValue('N'.$intrecord, $urlpath); 第二个参数 $urlpath 这个是写进excel的字符
回复讨论(解决方案)
什么意思?
你要把图片放进去吗?
不是, 是要把文件目录及文件名写进去。 比如 http://www.hrb.com:81/upload/image/1.jpg
根目录是http://www.hrb.com:81/admin
现在我这样写 ../upload/images/1.jpg 是想弄成 http://www.hrb.com:81/upload/image/1.jpg
(但是,现在的写成这样 就成了 “ ../upload/images/1.jpg”
而不是 upload/images 上一层目录 )
能把图片写进excel对应的一行一行的,是最好不过了。 现在给个地址,用户自已可以看到连接 点击 查看到也行
你不要 ../ 的话,程序里就不写就是了
不写的话,URL是有问题的
$urlpath = base_url()." ../upload/image/".$value['userpic']; 如果不写 ../ 的话结果是
http://www.hrb.com:81/admin/upload/image/1.jpg (这样是不对的,没有这个目录)
http://www.hrb.com:81/upload/image/1.jpg (这样才是正确的,才可以URL访问到图片)
可是 这里写的../ 没起作用 它当成字符串了,
$urlpath = base_url()." ../upload/image/".$value['userpic']; 这样写完后
它解析为 http://www.hrb.com:81/admin/../upload/image/XXXX.jpg
你是要写作 http://www.hrb.com:81/upload/image/XXXX.jpg 这样的,是吧?
这样写
$urlpath = basename(base_url()) ."/upload/image/".$value['userpic'];
php好学吗,他的优势是什么呢?对数据库的操作又用什么技术呢?
你是要写作 http://www.hrb.com:81/upload/image/XXXX.jpg 这样的,是吧?
是要写成 http://www.hrb.com:81/upload/image/XXXX.jpg 这样的
刚才把你发我的试了下 ,出来结果是
前边的http;// 域名 都没了
难道是写到excel所有的目录写法,不好使了?
现在的根目录是 http://www.hrb.com:81/admin
其实我想得到的是 http://www.hrb.com:81/ 这个就够了,然后再拼接后边的图片文件夹及名字
因为是后台地址,其它地方也在用, (直接改根目录或重定向 可能会影响到其它模块功能)

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Select DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl

TomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc

ToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin

Dependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Dreamweaver CS6
Visual web development tools

WebStorm Mac version
Useful JavaScript development tools

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
