mysql - Multiple Database Connections PHP -


i'm having trouble figuring out solution problem. have multiples classes on site handle different things. have comment class, profile class, login class , on , forth. i;m happy code design far because logic out of html template. have minimal logic in template. problem is, have single class database connection, , extend every class database class , use parent constructor connect database. problem every page has @ least 2 separate classes on , site getting more complicated , i'm having 4 or 5 classes per page, it's noticeably effecting load time since have reconnect database each time.

my question what's best way use database connections in class. i'm thinking maybe database queries have handled in html, or create whole function file included on every page has database connection loaded it. i'd know how more experienced programmers can fix right way.

thanks advice.

although use singleton sure 1 connection used, seems holy war declared on stack overflow honest pattern.

nevertheless, extending application classes db class bad idea. these classes have nothing in common. database class service - so, use service. of classes have send emails sure - don't extend classes email class too?

you have instantiate db class once, , pass object other classes in constructors. easiest way use global $db;, or can bother passing them in constructor parameters. or use advertized dependency injection approach.

anyway, should use single connection (with same credentials) throughout whole script execution. opening , closing connection many times no better having multiple simultaneous connections.


Comments

Post a Comment

Popular posts from this blog

ios - iPhone/iPad different view orientations in different views , and apple approval process -

i force app's home screen portrait , other views landscape. apple rejects app if this? if not , how force first screen launch in portrait mode? , force other screens launch in landscape. this not duplicate question search every possible answer in website. i force app's home screen portrait , other views landscape. apple rejects app if this? no apple not reject app this. have lot of apps doesn't support orientation. forcing on 1 screen won't cause app reject. if not , how force first screen launch in portrait mode? , force other screens launch in landscape. can on write : -(nsuinteger)supportedinterfaceorientations; function.
Read more

java Extracting Zip file -

i'm looking way extract zip file. far have tried java.util.zip , org.apache.commons.compress, both gave corrupted output. basically, input zip file contain 1 single .doc file. java.util.zip: output corrupted. org.apache.commons.compress: output blank file, 2 mb size. so far commercial software winrar work perfectly. there java library make use of this? this method using java.util library: public void extractzipnative(file filezip) { zipinputstream zis; stringbuilder sb; try { zis = new zipinputstream(new fileinputstream(filezip)); zipentry ze = zis.getnextentry(); byte[] buffer = new byte[(int) ze.getsize()]; fileoutputstream fos = new fileoutputstream(this.tempfolderpath+ze.getname()); int len; while ((len=zis.read(buffer))>0) { fos.write(buffer); } fos.flush(); fos.close(); } catch (filenotfoundexception e) { // todo auto-generated catch block ...
Read more

C# WinForm - loading screen -

i ask how make loading screen (just picture or something) appears while program being loaded, , disappears when program has finished loading. in fancier versions, have seen process bar (%) displayed. how can have that, , how calculate % show on it? i know there form_load() event, not see form_loaded() event, or % property / attribute anywhere. all need create 1 form splash screen , show before main start showing landing page , close splash once landing page loaded. class splashform { //delegate cross thread call close private delegate void closedelegate(); //the type of form displayed splash screen. private static splashform splashform; static public void showsplashscreen() { // make sure launched once. if (splashform != null) return; thread thread = new thread(new threadstart(splashform.showform)); thread.isbackground = true; thread.setapartmentstate(apartmentstate.sta); thread....
Read more