mysql - PHP insert image upload url in database -

-

i have 2 way insert image upload url in mysql database:

one:(only filename)

1410468094_shutterstock_130757219.jpg

two:(full url)

http://localhost/nws/uploads/files/1/shutterstock_130757219.jpg

which way better?

file name best cause if anytime change folder name or location .


Comments

Post a Comment

Popular posts from this blog

python - No exponential form of the z-axis in matplotlib-3D-plots -

-
Image
i have similar problem described in how prevent numbers being changed exponential form in python matplotlib figure : i don't want (in special case) weird scientific formatting of axis. problem different have problem @ z -axis. 2-d plots can use ax.get_yaxis().get_major_formatter().set_useoffset(false) . , there no function ax.get_zaxis() what use format z -axis same way? edit: example: from mpl_toolkits.mplot3d import axes3d import numpy np import sys import matplotlib import matplotlib.pyplot pyplot def func(xi, ti): res = 10e3 + np.cos(ti) * np.sin(xi) return res if __name__ == '__main__': timespacing = 20 timestart = 0 timeend = 1 time = np.linspace(timestart, timeend, timespacing) widthspacing = 50 widthstart = 0 widthend = 3 width = np.linspace(widthstart, widthend, widthspacing) reslist = [] matplotlib.rcparams['legend.fontsize'] = 10 fig = pyplot.figure() ax = fig.gca(projection = '3d...
Read more

php - Best Light server (Linux + Web server + Database) for Raspberry Pi -

-
i install web server database on raspberry pi (little computer). computer has 1gb ram. i want know best combination: linux distribution , web server , dbms run local server multiple users minimal latency, use php on server. , best settings performance , not have bugs (memory usage, disable plugin, disable service, etc)? i thought light debian , lighttpd server , sqlite database. solution? i think lighttpd + sqlite great choice. linux distro, debian @ centos or tiny core linux , although i'm not sure of compatibility pi. obviously, can't go wrong raspbian if want use in production , more stable performance, few more pi's , set them in cluster .
Read more

php - phpWord - Tables with borders in headers/footers -

-
i working phpword , bringing changes header/footer content gives me real hard time. trying have header content arranged in table. table created through code write. styles try apply table placed in header not take effect. following part of code in may making mistake. $phpwordobj = new phpword(); $section = $phpwordobj->addsection(); $styletable = array('bordersize' => 18, 'bordercolor' => '006699'); $phpwordobj->addtablestyle('my custom style', $styletable); //add header document $header = $section->addheader(); $header->firstpage(); $table = $header->addtable(); $table->addrow(); //logo $table->addcell(2000)->addimage( '../vendor/phpoffice/phpword/samples/resources/phpword.png', array('width' => 80, 'height' => 80, 'align' => 'left') ); //logo $cell = $table->addcell(7000); $textrun = $cell->addtex...
Read more