Posted on 07-04-2011
Filed Under (Oracle, PHP) by admin

Database Resident Connection Pooling (DRCP) oracle 11g ile gelen önemli yeniliklerdendir. PHP kullanarak yapılan dedicated oracle veritabanı işlemleri, fazla talep olduğunda problemlere neden olmaktadır. 11g ile gelen DRCP özelliğini kullanarak bu problemi çözebilirsiniz.

oracle php performans problemlerini sona erdirmek için Oracle RAC + DRCP özelliğine sahip bir mimariye sahip olmalısınız. dedicated oracle database’e php ile direct connection kurmanın doğal sonucu performans problemleridir.

Teknik detaylar için aşağıdaki belgeye gözatabilirsiniz.

http://www.oracle.com/technetwork/topics/php/whatsnew/php-scalability-ha-twp-128842.pdf

11g kullanıyorsanız; DRCP özelliğini şu şekilde aktif hale getirebilirsiniz.
SQL>execute dbms_connection_pool.start_pool;
SQL> select * from gv$cpool_stats;

(0) Comments    Read More   
Posted on 23-02-2011
Filed Under (PHP) by admin

ioncube_encoder ile PHP kaynak kodlarınızı şifreleyebilirsiniz. Kesin koruma sağlamaz. Kodlarınız deşifre edilebilir. Fakat yine de daha az  akıllılar tarafından kolayca okunamayacaktır. Alternatif olarak zend guard ürününü de deneyebilirsiniz.

ubuntu-server üzerinde kullanırken aldığım hata ve çözümü,

Hata:

bash: ioncube_encoder53: No such file or directory

Çözüm:

apt-get install ia32-libs

(0) Comments    Read More   
Posted on 09-11-2010
Filed Under (PHP) by admin

adLDAPb php ile active directory ldap dizinlerine erişebileceğiniz bir kütüphanedir. Paket içerisindeki örnek kodu özelleştirerek kolayca kullanabilirsiniz.

http://adldap.sourceforge.net/

Özellikleri

  • User authentication
  • Group management
  • User management
  • Contact management
  • Exchange mailbox creation
(0) Comments    Read More   
Posted on 26-10-2010
Filed Under (PHP) by admin
print str_pad(9, 2, "0", STR_PAD_LEFT)."\n";
print str_pad(24, 2, "0", STR_PAD_LEFT)."\n";
print str_pad(10, 2, "0", STR_PAD_LEFT)."\n";

rakamların önüne 0 ekler

(0) Comments    Read More   
Posted on 07-10-2010
Filed Under (Geographic Information Systems, PHP) by admin

Google earth ile çizdiğim test yolundaki her koordinatı, belirlediğim zaman aralığıda “test amaçlı” GPS verisi geldiğini düşünerek belli zamanlara eşlemem gerekiyordu, aşağıdaki PHP kodunu inceleyebilirsiniz,

 
#
# 07/10/2010, izmir 
#Ali Okan YÜKSEL aokany@gmail.com
# 

$sStr="27.11895333422714,38.46666974727331,0 27.11940927422533,38.46724358466437,0 27.1198622134575,38.46781826208379,0 27.12061451440553,38.46858833235991,0 27.12148232586754,38.46908012213039,0 27.12223945647677,38.46962328976672,0 27.12301053964507,38.47004265994084,0 27.12358268445096,38.47021814665585,0 27.12462464116645,38.470618989439,0 27.12502817697452,38.470763068428,0 27.12560041191175,38.47093856766278,0 27.12648040206868,38.47096460422151,0 27.12668562411619,38.47086491660885,0 27.12760493442525,38.47075871544659,0 27.1280493250138,38.47076974187539,0 27.12874349352461,38.47054597093874,0 27.12955306576598,38.47026579329732,0 27.13025616779168,38.47003725068681,0 27.13127527915839,38.46965495660945,0 27.1316973536911,38.46944974140612,0 27.13267771305684,38.46919911583716,0 27.13358192972966,38.46887271210886,0 27.13416769169605,38.46870132064774,0 27.13485716052152,38.46847960263316,0 27.13554672316479,38.46825785310346,0 27.13582192382679,38.46823712839175,0 27.13647630362674,38.46814511828428,0 27.13695866357282,38.46802383487184,0 27.1375077259361,38.46798295950249,0 27.13805663114318,38.46794210226459,0 27.13867192313604,38.46798162639064,0 27.13962059442183,38.46808602758581,0 27.14023112187808,38.46812870657828,0 27.14117948005547,38.46823343578382,0 27.14206456979133,38.4682553291563,0 27.14286001140315,38.46855208020349,0 27.14349029887796,38.46881545520796,0 27.14388953918701,38.46896372720551,0 27.14471399033652,38.46947538333863,0 27.14537167843009,38.46995474336389,0 27.14579750111756,38.47031875807773,0 27.14615920021751,38.47060028922362,0 27.14671480107915,38.47113058203738,0 27.14724991655002,38.47143768358031,0 27.14802700333322,38.47183995195253,0 27.14863295619931,38.47220944744606,0 27.14964215578283,38.47271402194583,0 27.15062183512714,38.47300607605388,0 27.15119506736971,38.47316499640778,0 27.15176716428283,38.47332359779279,0 27.15227350070325,38.47340289862351,0 27.15284349456556,38.47356097295864,0 27.1533479892586,38.47364048833313,0 27.15439422258049,38.47368031136321,0 27.15540011734931,38.47385765424463,0 27.1564448970026,38.47390682840869,0 27.15698738298618,38.47386921263966,0 27.15769752288936,38.47386172167531,0 27.15790511327424,38.4737638294188,0 27.15880032857843,38.4734526025988,0 27.1596357833994,38.47306883283701,0 27.16015976006193,38.47283034262259,0 27.16078910588165,38.47254219637161,0 27.16156355903912,38.47207197944173,0 27.1621919701962,38.4717765182282,0 27.16292171945658,38.47142499178102,0 27.16412232822523,38.47075780549437,0 27.16447587815366,38.47047530610757,0 27.16524537384909,38.46998889433868,0 27.165910892295,38.46955329680442,0 27.16620176746978,38.46919055819099,0 27.1665968804685,38.46877674576557,0 27.16684655224947,38.46854431532866,0 27.16735346089643,38.4680849282741,0 27.16752793847286,38.46756668572258,0 27.16782809079222,38.46720788657654,0 27.16812053983136,38.46684326542495,0 27.16834828337349,38.46639657213525,0 27.16914538918938,38.46556546879184,0 27.16962608360021,38.46488463810254,0 27.16985458406053,38.46443671984402,0 27.17014588873781,38.46406967820136,0 27.17038619883203,38.46327218666707,0 27.17060950551979,38.46282188910615,0 27.17097851694593,38.46218793590548,0 27.17109788092563,38.46178885940726,0 27.17157138598589,38.46110381285775,0 27.17177033408135,38.46043864146684,0 27.17213906067381,38.45980453536927,0 27.17259797517373,38.4594675879158,0 27.17291231254822,38.45931465789371,0 27.17354097346514,38.45900880533304,0 27.17411924469768,38.45827273232848,0 27.17518156505832,38.45741481483709,0 27.17572002489394,38.45681177127077,0 27.1766755667302,38.45600497824801,0 27.17762947377079,38.45519847570381,0 27.17845487886591,38.45422784767679,0 27.1791828183495,38.45330700959397,0 27.17995164280044,38.4522525017657,0 27.18077912031449,38.45128120546461,0 27.18131688858023,38.45067818617265,0 27.18150096944322,38.45036109199371,0 27.18197376516094,38.44967598085076,0 27.18192332598582,38.44924557488957,0 27.18166358893338,38.44891703506929,0 27.18140384533333,38.44858848211189,0 27.18083010977473,38.44841272175974,0 27.18057032878534,38.44808412503613,0 27.18011303048442,38.4475100877105,0 27.1801914192444,38.44724434167065,0 27.17992932765679,38.44691670843091,0 27.17933975359933,38.44617968209515,0 27.17907825068315,38.44585195637765,0 27.17868830019383,38.44535930507506,0 27.1784283292017,38.44503085687678,0 27.17841828233226,38.44446704635787,0 27.17858069161065,38.44393284569104,0 27.17863735047209,38.44345004160104,0 27.17892589701673,38.44308218691846,0 27.17948891138969,38.44269458509079,0 27.18001231847946,38.44243999773447,0 27.18064028850302,38.44213455784013,0 27.18122863168929,38.44196212734713,0 27.181882036214,38.44187177961362,0 27.18245633093368,38.44204737870233,0 27.18307013818057,38.44208999254348,0 27.18361882940762,38.4420505338536,0 27.18427211339119,38.44196018076333,0 27.18458595357719,38.44180748491701,0 27.18510899882462,38.44155301208003,0 27.18542280794461,38.44140033036594,0 27.18594579103161,38.44114587829952,0 27.18633814849235,38.44072754260797,0 27.18683500190388,38.44025838195213,0 27.18705759260288,38.43980896022718,0 27.1876330532391,38.43907420638111,0 27.18796557850706,38.4385709472723,0 27.18818843892137,38.43812139221982,0 27.18817676604154,38.43755852207324,0 27.18806060980931,38.43704648191012,0 27.18780051675651,38.43671815049087,0 27.18747539882354,38.4363077292896,0 27.18713637546281,38.43624517504097,0 27.18654887044967,38.43641713810465,0 27.18592183614192,38.4367220192975,0 27.18550371011024,38.43692533937791,0 27.18507981317183,38.43713245459082,0 27.18444988188837,38.43743923578676,0 27.18382265684309,38.43774421505044,0 27.18329992821629,38.43799838064219,0 27.18256803938491,38.43835424324939,0 27.18204521408006,38.43860844976572,0 27.18162692236989,38.4388118224989,0 27.18079026519373,38.43921860250836,0 27.18033245787186,38.43955488116336,0 27.17976993482364,38.43994209205173,0 27.17937713268934,38.44036050102154,0 27.17891912674946,38.44069691240482,0 27.17831692190731,38.44121717434231,0 27.1770605864567,38.44182812755326,0 27.17643235772022,38.44213361676416,0 27.17590880518961,38.44238821038332,0 27.17523994736623,38.44282739993946,0 27.17477870626993,38.44316601278673,0 27.17431977659449,38.44350300259283,0 27.17381063358268,38.44340928753416,0 27.17357589238054,38.44329590718062,0 27.17314607068215,38.44293607693893,0 27.1726914517664,38.44236057438729,0 27.17236765288881,38.44194864624014,0 27.17210720409479,38.44162025637166,0 27.17233083297671,38.44117030446268,0 27.17257979630184,38.44093558819517,0 27.17303814392973,38.44059912490602,0 27.17332660771797,38.44023151925779,0 27.17354989733033,38.4397818940479,0 27.17366849029686,38.4393831700264,0 27.17361724423526,38.43895330086606,0 27.17335664797531,38.43862517954103,0 27.17292658586936,38.43826554355479,0 27.17245695440764,38.43803881301821,0 27.17154310392008,38.43780039557103,0 27.17096873081934,38.43762448300708,0 27.17073388655359,38.43751110038374,0 27.16995007026799,38.4374368752744,0 27.16923127434003,38.43744475649888,0 27.16851211664436,38.43745307250509,0 27.16762303179146,38.4374302412065,0 27.16690380825659,38.43743857013061,0 27.16620999464421,38.43766198999892,0 27.16583052264354,38.43773265727903,0 27.16528106509447,38.43777228480651,0 27.16441499318158,38.43796879646937,0 27.16369506860876,38.43797862848142,0 27.16304089014898,38.4380692934044,0 27.1623867107586,38.43815995529297,0 27.16177218465714,38.43811773154604,0 27.16098776371044,38.43804445884894,0 27.16037326757778,38.43800223245004,0 27.1596682433485,38.43766321697003,0 27.15898868563049,38.43753902949587,0 27.15834884421861,38.43728198831083,0 27.15747406872377,38.4369120373347,0 27.15687400859592,38.43652224466474,0 27.15650892622531,38.4362454329432,0 27.15580417252409,38.43590658773456,0 27.15547886553221,38.43549697587683,0 27.15500908918678,38.4352711108184,0 27.15468383910396,38.43486154723044,0 27.15429356766733,38.43437010650119,0 27.15390333728126,38.43387870474495,0 27.15364320551754,38.4335511247106,0 27.15342282154548,38.43309079362416,0 27.15330720621518,38.43257961115832,0 27.15321689463772,38.43228310161454,0 27.15307599022224,38.43155632772024,0 27.15286995717916,38.43074442534454,0 27.15289871893585,38.43004559312447,0 27.15292754032425,38.42934832719615,0 27.15294195461463,38.4289996819155,0 27.15299609051705,38.42851765414252,0 27.15331394457017,38.42745290141888,0 27.15336812266002,38.4269729240016,0 27.15352706077231,38.42644303039948,0 27.15362096052541,38.42583316342135,0 27.15377984743428,38.42530515509005,0 27.15389898894927,38.42490923808045,0 27.15413719718037,38.42411762096047,0 27.15425626818375,38.42372192143448,0 27.15454510292749,38.42335197718541,0 27.15474368015485,38.42268429659858,0 27.15524183854767,38.42221610257681,0 27.15563526699275,38.42179866217666,0 27.15613334063586,38.42133053338009,0 27.156526705048,38.42091315644456,0 27.15688036972453,38.42062840796548,0 27.15758763906856,38.42005894930465,0 27.15850413281847,38.41938792803042,0 27.15902742518943,38.41913362971116,0 27.15969503182832,38.41869562746935,0 27.16032296830471,38.41839038589721,0 27.16084623524057,38.41813602014685,0 27.16147414203429,38.4178307801691,0 27.16241598244548,38.41737292381951,0 27.1631440914768,38.41703606974061,0 27.16351467188427,38.41699970992847,0 27.1644564304959,38.41684951074561,0 27.16525750577477,38.41685753867167,0 27.16542466406198,38.41689406794248,0 27.16614364993134,38.41687022505388,0 27.16678493568628,38.41710867145371,0 27.16708592092385,38.41729451199655,0 27.16751775418878,38.41763996135308,0 27.16777927935007,38.41795912615857,0 27.16810632803053,38.41835825572713,0 27.1682249956502,38.4188588841049,0 27.16789952101188,38.4193530786139,0 27.16782183527129,38.41961427277425,0 27.16770527232622,38.42000615553099,0 27.16749184612653,38.42042839454162,0 27.1673864163283,38.42079000331771,0 27.16724552474597,38.42127326113177,0 27.16716886008446,38.42153184813065,0 27.166670958917,38.42200098899528,0 27.16627770475167,38.42241925017533,0 27.16598915573916,38.42278649998908,0 27.16553101358249,38.42312237541921,0 27.16507284107242,38.42345825675525,0 27.16467970070456,38.42387602169345,0 27.16405118509336,38.42418279768534,0 27.16334268060678,38.42475767373615,0 27.16292416561882,38.42496062553823,0 27.16240099335567,38.42521432986265,0 27.16198242634202,38.42541729838015,0 27.161524308649,38.4257525877879,0 27.16127546016386,38.4259863984756,0 27.16081726712631,38.42632173132461,0 27.16046370564096,38.42660633348601,0 27.16024032249905,38.42705414496925,0 27.15991239462584,38.42755192610614,0 27.15964960444055,38.4281309436406,0 27.15970074223049,38.42855855336173,0 27.15979143771375,38.42885404505832,0 27.15986817961035,38.42949567024061,0 27.16012872608029,38.42982240818349,0 27.16041490504448,38.4303632360589,0 27.16074074690756,38.43077157484845,0 27.16119750451295,38.43134154301392,0 27.16145785042815,38.43166985885182,0 27.16178329055722,38.4320802532764,0 27.16217382984057,38.43257273521608,0 27.16253898281964,38.43285016551816,0 27.16307401734013,38.43315876981119,0 27.16364874221846,38.43333439784604,0 27.16405359371493,38.43347884257627,0 27.16469340856528,38.43373653706893,0 27.16530780616852,38.43377917464972,0 27.16592219137367,38.4338218066189,0 27.16630160066204,38.43375118451166,0 27.16695563275464,38.43366083957059,0 27.16743977957771,38.43353931209609,0 27.16823818415517,38.4332651015527,0 27.16876194661285,38.4330106211988,0 27.16928564187203,38.43275622178997,0 27.16980909653634,38.43250216702781,0 27.17054186859599,38.43214651336554,0 27.1709605633792,38.43194329490522,0 27.17158855618072,38.43163849323523,0 27.17204678762773,38.4313024031505,0 27.1722569184756,38.43119961853833,0 27.17265195647566,38.4307787360609,0 27.17321498358609,38.43039162228704,0 27.17350316804465,38.43002464877376,0 27.17406539982344,38.42963858074993,0 27.17437913860396,38.429486440004,0 27.17473212062851,38.42920185424054,0 27.17515037429195,38.42899902728532,0 27.17581692547112,38.42856238786416,0 27.17654868209668,38.42820752808022,0 27.17717675305774,38.42790220649342,0 27.17759557204465,38.42769851234034,0 27.17841955864106,38.42763835887779,0 27.17907360422401,38.42754732368763,0 27.17985821104828,38.42761988354096,0 27.18032904098195,38.4278449035182,0 27.18103631673039,38.42818143225458,0 27.18163879430073,38.42856918733873,0 27.18210494073412,38.42879927720531,0 27.18236448333034,38.42912825321941,0 27.18248971034875,38.42963128783017,0 27.18239714934223,38.43024458626318,0 27.18231799003175,38.43051052295384,0 27.1820942552572,38.43096062887452,0 27.18176477558284,38.43146261285394,0 27.18126580847062,38.43193312889883,0 27.18097622319972,38.43230184031003,0 27.18068665290538,38.43267053092468,0 27.18033282150504,38.43295634922527,0 27.17993489095985,38.4333793672903,0 27.17940777062023,38.43363733956399,0 27.1789861733931,38.43384366979717,0 27.17835862818682,38.4341485581586,0 27.17783568001747,38.43440260590403,0 27.1773777397585,38.43473875458276,0 27.1772335799071,38.43492246833946,0 ";
 
$sArray=explode(" ",$sStr);
 
$i=0;
foreach($sArray as $k=>$v) {
	$i=$i+5;
	$next  = date("Y-m-d H:i:s", mktime(0, 0, date("s")+$i, date("m")  , date("d")+1, date("Y")));	 // hour minute seconds month day year
	print $v." >>> $next <br />";
}
(0) Comments    Read More   

CKFinder kullanıyorsanız ve bu ifade;

ckfinder/core/js dizininde yer alan ckfinder_gecko.js ckfinder_ie.js dosyasını düzenlemeniz gerekiyor. Kullandığım sürüm: CKFinder 1.4.1.1

qo+=’\75\x27\x3C\144\x69\166\x20\163\x74\x79\x6C\145\75\x22\x74\145\170\x74\55\x61\154\151\x67\156\x3A\40\143\145\156\x74\x65\x72\73\40\146\157\x6E\x74\x2D\x73\151\172\x65\x3A\x20\61\x36\160\170\x3B\x20\143\x6F\154\157\162\x3A\x20\x52\x65\x64\x3B\40\x70\141\x64\x64\x69\156\147\72\40\61\60\160\x78\73\40\x66\x6F\156\x74\x2D\x77\145\151\147\x68\164\x3A\40\142\157\x6C\x64\x22\76\x54\150\x69\163\x20\x69\x73\40\x74\150\145\x20\144\145\x6D\157\40\166\145\x72\163\x69\x6F\x6E\40\x6F\146\40\103\113\106\151\x6E\x64\145\x72\x2E\40\74\x61\x20\x68\162\145\x66\x3D\x22\x68\x74\164\x70\72\x2F\57\x77\167\x77\56\143\153\x66\x69\156\x64\x65\x72\56\x63\x6F\155\42\40\164\141\162\x67\x65\164\x3D\42\x5F\x62\x6C\x61\156\x6B\x22\40\163\164\171\x6C\145\75\42\x63\x6F\x6C\x6F\x72\72\40\102\154\x75\x65\42\x3E\103\x6C\151\143\x6B\x20\150\145\162\145\40\x74\157\40\x76\x69\x73\x69\x74\x20\x6F\165\162\x20\x77\x65\x62\40\163\151\164\145\74\57\141\76\x2E\40\x3C\151\x6E\160\x75\x74\40\x74\x79\160\x65\x3D\x22\142\x75\x74\x74\x6F\x6E\42\40\x76\141\154\x75\145\x3D\x22\x48\151\x64\145\x20\x4D\x65\x73\x73\x61\147\x65\x22\40\157\x6E\143\x6C\x69\x63\x6B\x3D\42\164\150\151\x73\56\160\x61\x72\145\x6E\164\x4E\157\144\145\x2E\x70\x61\162\x65\x6E\x74\x4E\x6F\x64\x65\56\x73\x74\x79\154\145\x2E\x64\x69\163\160\x6C\x61\x79\75\134\x27\156\157\156\x65\134\x27\73\x22\x20\x2F\x3E\74\x2F\144\x69\166\76\x27\73′;

ckfinder_gecko.js   ckfinder_gecko.js_  ckfinder_ie.js
(0) Comments    Read More   
Posted on 23-08-2009
Filed Under (PHP) by admin
Örnekte kullanılan kütüphane resize_lib.php dosyasını
http://www.white-hat-web-design.co.uk/articles/php-image-resizing.php adresinde bulabilirsiniz.
ini_set('display_errors', 1); 
Include("resize_lib.php");
$uploadpath = "./yuklemeler/";
if($_FILES["imaj1"]["name"]!="") {
	if(!preg_match("/(jpg|gif|bmp)/",substr(strtolower($_FILES["imaj1"]["name"]),-3))) die("file extension problem!!");
	if(move_uploaded_file($_FILES["imaj1"]["tmp_name"],$uploadpath.strtolower($_FILES["imaj1"]["name"]))) print '<script>alert("uploaded!!");</script>';
	$image = new SimpleImage();
	$image->load($uploadpath.strtolower($_FILES["imaj1"]["name"]));
	$image->resizeToWidth(250);
	$image->save($uploadpath."minik_".$_FILES["imaj1"]["name"]);
}
print '
<form name="yukle" method="post" action="" enctype="multipart/form-data">
<input type="file" name="imaj1" />
<input type="submit" value="upload it!!" />
</form>
';

Dikkat edilmesi gereken noktalar, öneriler;

  • dosya yüklemesi söz konusu olduğunda form içinde enctype tanımı
  • resize özelliğinin sorunsuz çalışması için PHP’nin GD destekli kurulduğundan emin olun.
  • Güvenlik kaygısı nedeniyle, yükleme yaparken uzantı kontrolü yapmayı unutmayını
  • Dosya adlarının çakışmaması için md5(micro_time()) fonksiyonlardan faydalanabilirsiniz.
(0) Comments    Read More