/Users/andrea/_magisterarbeit/korpus/clean/trainkorpus/27/file4.html NN ----------------------------------------- : downloads NNS documentation NN faq JJ getting VVG help NN mailing NN lists VVZ reporting VVG bugs NNS php NN . SENT net JJ sites NNS links VVZ my PP$ php NN . SENT net JJ search NN for IN in IN the DT PHP NP Manual NP FAQ NP General NP Information NP Mailing NN lists NNS Obtaining VVG PHP NP Database NN issues NNS Installation NN Build VVP Problems NP Using VVG PHP NP PHP NP and CC HTML NP PHP NP and CC COM NN PHP NP and CC other JJ languages NNS Migrating VVG from IN PHP NP 2 CD to TO PHP NP 3 CD Migrating VVG from IN PHP NP 3 CD to TO PHP NP 4 CD Migrating VVG from IN PHP NP 4 CD to TO PHP NP 5 CD Miscellaneous JJ Questions NNS Obtaining VVG PHPInstallation NN view VVP the DT version NN of IN this DT pageLast NN updated VVN . SENT Wed VVN , , 06 CD Jul NN 2005 CD Chapter NN 67 CD . SENT Database NN issues NNS This DT section NN holds VVZ common JJ questions NNS about IN relation NN between IN PHP NP and CC databases NNS . SENT Yes UH , , PHP NP can MD access VV virtually RB any DT database NN available JJ today NN . SENT 1 LS . SENT I PP heard VVD it's NNS possible JJ to TO access VV Microsoft NP SQL NP Server NP from IN PHP NP . SENT How WRB . SENT 2 LS . SENT Can MD I PP access VV Microsoft NP Access NP databases NNS . SENT 3 LS . SENT I PP upgraded VVD to TO PHP NP 4 CD , , and CC now RB mysql NN keeps VVZ telling VVG me PP Warning NP . SENT MySQL NP . SENT Unable JJ to TO save VV result NN set VVN in IN . SENT . SENT . SENT . SENT What's NNS up RB . SENT 4 LS . SENT PHP NP 5 CD no RB longer JJR bundles NNS MySQL NP client NN libraries NNS , , what WP does VVZ this DT mean VVP to TO me PP . SENT Can MD I PP still RB use VVP MySQL NP with IN PHP NP . SENT I PP try VVP to TO use VV MySQL NP and CC get VV function VV undefined JJ errors NNS , , what WP gives VVZ . SENT 5 LS . SENT After IN installing VVG shared JJ MySQL NP support NN , , Apache NP dumps VVZ core NN as RB soon RB as IN libphp NN 4 CD . SENT so RB is VBZ loaded VVN . SENT Can MD this RB be VB fixed VVN . SENT 6 CD . SENT Why WRB do VVP I PP get VV an DT error NN that WDT looks VVZ something NN like IN this DT . SENT Warning NN . SENT 0 CD is VBZ not RB a DT MySQL NP result NN index NN in IN file NN on IN line NN x NN or CC Warning NP . SENT Supplied VVN argument NN is VBZ not RB a DT valid JJ MySQL NP result NN resource NN in IN file NN on IN line NN x NN . SENT 1 LS . SENT I PP heard VVD it's NNS possible JJ to TO access VV Microsoft NP SQL NP Server NP from IN PHP NP . SENT How WRB . SENT On IN Windows NNS machines NNS , , you PP can MD simply RB use VV the DT included VVN ODBC NP support NN and CC the DT correct JJ ODBC NP driver NN . SENT On IN Unix NP machines NNS , , you PP can MD use VV the DT Sybase NP CT NP driver NN to TO access VV Microsoft NP SQL NP Servers NNS because IN they PP are VBP at IN least JJS mostly RB protocol NN compatible JJ . SENT Sybase NP has VHZ made VVN a DT free JJ version NN of IN the DT necessary JJ libraries NNS for IN Linux NP systems NNS . SENT For IN other JJ Unix NP operating NN systems NNS , , you PP need VVP to TO contact VV Sybase NP for IN the DT correct JJ libraries NNS . SENT Also RB see VV the DT answer NN to TO the DT next JJ question NN . SENT 2 LS . SENT Can MD I PP access VV Microsoft NP Access NP databases NNS . SENT Yes UH . SENT You PP already RB have VHP all PDT the DT tools NNS you PP need VVP if IN you PP are VBP running VVG entirely RB under IN Windows NNS 9 CD x SYM Me PP , , or CC NT NP 2000 CD , , where WRB you PP can MD use VV ODBC NP and CC Microsoft's NP ODBC NP drivers NNS for IN Microsoft NP Access NP databases NNS . SENT If IN you PP are VBP running VVG PHP NP on IN a DT Unix NP box NN and CC want VVP to TO talk VV to TO MS NN Access NP on IN a DT Windows NNS box NN you PP will MD need VV Unix NP ODBC NP drivers NNS . SENT OpenLink NP Software NP has VHZ Unix NP based VVN ODBC NP drivers NNS that WDT can MD do VV this DT . SENT There EX is VBZ a DT free JJ pilot NN program NN where WRB you PP can MD download VV an DT evaluation NN copy NN that IN doesn't NN expire VVP and CC prices NNS start VVP at IN 675 CD for IN the DT commercial JJ supported VVN version NN . SENT Another DT alternative NN is VBZ to TO use VV an DT SQL NP server NN that WDT has VHZ Windows NNS ODBC NP drivers NNS and CC use VV that IN to TO store VV the DT data NNS , , which WDT you PP can MD then RB access VV from IN Microsoft NP Access NP using VVG ODBC NP and CC PHP NP using VVG the DT built VVN in IN drivers NNS , , or CC to TO use VV an DT intermediary JJ file NN format NN that IN Access NP and CC PHP NP both CC understand VV , , such JJ as IN flat JJ files NNS or CC dBase NN databases NNS . SENT On IN this DT point NN Tim NP Hayes NP from IN OpenLink NP software NN writes VVZ . SENT Using VVG another DT database NN as IN an DT intermediary NN is VBZ not RB a DT good JJ idea NN , , when WRB you PP can MD use VV ODBC NP from IN PHP NP straight RB to TO your PP$ database NN i NP . SENT e SYM . SENT with IN OpenLink's NP drivers NNS . SENT If IN you PP do VVP need VV to TO use VV an DT intermediary JJ file NN format NN , , OpenLink NP have VHP now RB released VVN Virtuoso NN a DT virtual JJ database NN engine NN for IN NT NP , , Linux NP and CC other JJ Unix NP platforms NNS . SENT Please UH visit VV our PP$ website NN for IN a DT free JJ download NN . SENT One CD option NN that WDT has VHZ proved VVN successful JJ is VBZ to TO use VV MySQL NP and CC its PP$ MyODBC NP drivers NNS on IN Windows NNS and CC synchronizing VVG the DT databases NNS . SENT Steve NP Lawrence NP writes VVZ . SENT Install VV MySQL NP on IN your PP$ platform NN according VVG to TO instructions NNS with IN MySQL NP . SENT Latest JJS available JJ from IN www NP . SENT mysql NN . SENT com NN get VV it PP from IN your PP$ mirror NN . SENT . SENT No DT special JJ configuration NN required VVN except IN when WRB you PP set VVD up RP a DT database NN , , and CC configure VV the DT user NN account NN , , you PP should MD put VV in IN the DT host NN field NN , , or CC the DT host NN name NN of IN the DT Windows NNS computer NN you PP wish VVP to TO access VV MySQL NP with IN . SENT Make VV a DT note NN of IN your PP$ server NN name NN , , username NN , , and CC password NN . SENT Download NP the DT MyODBC NN for IN Windows NNS driver NN from IN the DT MySQL NP site NN . SENT Latest JJS release NN is VBZ myodbc NN 2 CD 50 CD 19 CD win NN 95 CD . SENT zip NN NT NN available JJ too RB , , as RB well RB as IN source NN code NN . SENT Install VV it PP on IN your PP$ Windows NNS machine NN . SENT You PP can MD test VV the DT operation NN with IN the DT utilities NNS included VVD with IN this DT program NN . SENT Create VV a DT user NN or CC system NN dsn NN in IN your PP$ ODBC NP administrator NN , , located VVN in IN the DT control NN panel NN . SENT Make VV up RP a DT dsn NP name NN , , enter VV your PP$ hostname NN , , user NN name NN , , password NN , , port NN , , etc FW for IN you PP MySQL NP database NN configured VVD in IN step NN 1 CD . SENT Install VV Access NP with IN a DT full JJ install VV , , this DT makes VVZ sure RB you PP get VVP the DT proper JJ add VV ins NNS . SENT . SENT at IN the DT least JJS you PP will MD need VV ODBC NP support NN and CC the DT linked VVN table NN manager NN . SENT Now RB the DT fun NN part NN . SENT Create VV a DT new JJ access NN database NN . SENT In IN the DT table NN window NN right NN click NN and CC select JJ Link NN Tables NP , , or CC under IN the DT file NN menu NN option NN , , select VV Get VV External NP Data NP and CC then RB Link VVP Tables NP . SENT When WRB the DT file NN browser NN box NN comes VVZ up RP , , select VV files NNS of IN type NN . SENT ODBC NP . SENT Select NP System NP dsn NP and CC the DT name NN of IN your PP$ dsn NN created VVN in IN step NN 3 CD . SENT Select VV the DT table NN to TO link VV , , press VV OK UH , , and CC presto RB . SENT You PP can MD now RB open VV the DT table NN and CC add VV delete VV edit VV data NNS on IN your PP$ MySQL NP server NN . SENT You PP can MD also RB build VV queries NNS , , import NN export NN tables NNS to TO MySQL NP , , build VV forms NNS and CC reports NNS , , etc FW . SENT Tips NNS and CC Tricks NNS . SENT You PP can MD construct VV your PP$ tables NNS in IN Access NP and CC export VV them PP to TO MySQL NP , , then RB link VV them PP back RB in IN . SENT That WDT makes VVZ table NN creation NN quick JJ . SENT When WRB creating VVG tables NNS in IN Access NP , , you PP must MD have VH a DT primary JJ key NN defined VVN in IN order NN to TO have VH write VV access NN to TO the DT table NN in IN access NN . SENT Make VV sure JJ you PP create VVP a DT primary JJ key NN in IN MySQL NP before IN linking VVG in IN access NN If IN you PP change VVP a DT table NN in IN MySQL NP , , you PP have VHP to TO re NN link VV it PP in IN Access NP . SENT Go VV to TO tools NNS add VVP ins NNS linked VVN table NN manager NN , , cruise VVP to TO your PP$ ODBC NP DSN NP , , and CC select VV the DT table NN to TO re NN link NN from IN there RB . SENT you PP can MD also RB move VV your PP$ dsn NP source NN around IN there RB , , just RB hit VVD the DT always RB prompt JJ for IN new JJ location NN checkbox NN before IN pressing VVG OK JJ . SENT 3 LS . SENT I PP upgraded VVD to TO PHP NP 4 CD , , and CC now RB mysql NN keeps VVZ telling VVG me PP Warning NP . SENT MySQL NP . SENT Unable JJ to TO save VV result NN set VVN in IN . SENT . SENT . SENT . SENT What's NNS up RB . SENT Most RBS likely RB what WP has VHZ happened VVN is VBZ , , PHP NP 4 CD was VBD compiled VVN with IN the DT with IN mysql NN option NN , , without IN specifying VVG the DT path NN to TO MySQL NP . SENT This DT means VVZ PHP NP is VBZ using VVG its PP$ built VVN in IN MySQL NP client NN library NN . SENT If IN your PP$ system NN is VBZ running VVG applications NNS , , such JJ as IN PHP NP 3 CD as IN a DT concurrent JJ Apache NP module NN , , or CC auth NP mysql NN , , that WDT use VVP other JJ versions NNS of IN MySQL NP clients NNS , , then RB there EX is VBZ a DT conflict NN between IN the DT two CD differing VVG versions NNS of IN those DT clients NNS . SENT Recompiling NP PHP NP 4 CD , , and CC adding VVG the DT path NN to TO MySQL NP to TO the DT flag NN , , with IN mysql NN your PP$ path NN to TO mysql NN usually RB solves VVZ the DT problem NN . SENT 4 LS . SENT PHP NP 5 CD no RB longer JJR bundles NNS MySQL NP client NN libraries NNS , , what WP does VVZ this DT mean VVP to TO me PP . SENT Can MD I PP still RB use VVP MySQL NP with IN PHP NP . SENT I PP try VVP to TO use VV MySQL NP and CC get VV function VV undefined JJ errors NNS , , what WP gives VVZ . SENT Yes UH . SENT There EX will MD always RB be VB MySQL JJ support NN in IN PHP NP of IN one CD kind NN or CC another DT . SENT The DT only JJ change NN in IN PHP NP 5 CD is VBZ that IN we PP are VBP no RB longer RBR bundling VVG the DT client NN library NN itself PP . SENT Some DT reasons NNS in IN no DT particular JJ order NN . SENT Most JJS systems NNS these DT days NNS already RB have VHP the DT client NN library NN installed VVN . SENT Given VVN the DT above JJ , , having VHG multiple JJ versions NNS of IN the DT library NN can MD get VV messy JJ . SENT For IN example NN , , if IN you PP link VVP mod JJ auth NP mysql NN against IN one CD version NN and CC PHP NP against IN another DT , , and CC then RB enable VV both DT in IN Apache NP , , you PP get VVP a DT nice JJ fat JJ crash NN . SENT Also RB , , the DT bundled VVN library NN didn't VVD always RB play VV well RB with IN the DT installed JJ server NN version NN . SENT The DT most RBS obvious JJ symptom NN of IN this DT being JJ disagreement NN over IN where WRB to TO find VV the DT mysql NN . SENT socket NN Unix NP domain NN socket NN file NN . SENT Maintenance NN was VBD somewhat RB lax JJ and CC it PP was VBD falling VVG further RBR and CC further RBR behind IN the DT released VVN version NN . SENT Future JJ versions NNS of IN the DT library NN are VBP under IN the DT GPL NP and CC thus RB we PP don't VVD have VH an DT upgrade JJ path NN since IN we PP cannot NN bundle NN a DT GPL'ed JJ library NN in IN a DT BSD NP Apache NP style NN licensed VVD project NN . SENT A DT clean JJ break NN in IN PHP NP 5 CD seemed VVD like IN the DT best JJS option NN . SENT This DT won't NN actually RB affect VV that IN many JJ people NNS . SENT Unix NP users NNS , , at IN least JJS the DT ones NNS who WP know VVP what WP they PP are VBP doing VVG , , tend VVP to TO always RB build VV PHP NP against IN their PP$ system's JJ libmyqlclient JJ library NN simply RB by IN adding VVG the DT with IN mysql NN usr NN option NN when WRB building VVG PHP NP . SENT Windows NNS users NNS may MD enable VV the DT extension NN php NN mysql NN . SENT dll NP inside JJ php NN . SENT ini NNS . SENT Also RB , , be VB sure JJ libmysql NN . SENT dll NP is VBZ available JJ to TO the DT systems NNS PATH NN . SENT For IN more JJR details NNS on IN how WRB , , read VV the DT FAQ NP on IN setting VVG up RP the DT Windows NNS systems NNS PATH NN . SENT Because IN libmysql NN . SENT dll NP and CC many JJ other JJ PHP NP related JJ files NNS exist VVP in IN the DT PHP NP folder NN , , you'll JJ want VVP to TO add VV the DT PHP NP folder NN to TO your PP$ systems NNS PATH NN . SENT 5 LS . SENT After IN installing VVG shared JJ MySQL NP support NN , , Apache NP dumps VVZ core NN as RB soon RB as IN libphp NN 4 CD . SENT so RB is VBZ loaded VVN . SENT Can MD this RB be VB fixed VVN . SENT If IN your PP$ MySQL NP libs NNS are VBP linked VVN against IN pthreads NNS this DT will MD happen VV . SENT Check VV using VVG ldd NN . SENT If IN they PP are VBP , , grab VV the DT MySQL NP tarball NN and CC compile VV from IN source NN , , or CC recompile NN from IN the DT source NN rpm NN and CC remove VV the DT switch NN in IN the DT spec NN file NN that WDT turns VVZ on IN the DT threaded VVN client NN code NN . SENT Either CC of IN these DT suggestions NNS will MD fix VV this DT . SENT Then RB recompile JJ PHP NP with IN the DT new JJ MySQL NP libs NNS . SENT 6 CD . SENT Why WRB do VVP I PP get VV an DT error NN that WDT looks VVZ something NN like IN this DT . SENT Warning NN . SENT 0 CD is VBZ not RB a DT MySQL NP result NN index NN in IN file NN on IN line NN x NN or CC Warning NP . SENT Supplied VVN argument NN is VBZ not RB a DT valid JJ MySQL NP result NN resource NN in IN file NN on IN line NN x NN . SENT You PP are VBP trying VVG to TO use VV a DT result NN identifier NN that WDT is VBZ 0 CD . SENT The DT 0 CD indicates VVZ that IN your PP$ query NN failed VVD for IN some DT reason NN . SENT You PP need VVP to TO check VV for IN errors NNS after IN submitting VVG a DT query NN and CC before IN you PP attempt VVP to TO use VV the DT returned VVN result NN identifier NN . SENT The DT proper JJ way NN to TO do VV this DT is VBZ with IN code NN similar JJ to TO the DT following NN . SENT . SENT php NN result NN mysql NN query NN SELECT JJ FROM IN tables NNS priv NP . SENT if IN . SENT result NN echo NN mysql NN error NN . SENT exit NN . SENT . SENT or JJ . SENT php NN result NN mysql NN query NN SELECT JJ FROM IN tables NNS priv NP or CC die VV Bad JJ query NN . SENT . SENT mysql NN error NN . SENT . SENT add VV a DT note NN User NP Contributed VVD Notes NP Database NN issues NNS curious JJ 27 CD May NP 2005 CD 06 CD . SENT 35 CD Warning NP . SENT mysqli NN query NN expects VVZ parameter NN 1 CD to TO be VB mysqli JJ , , null NN given VVN in IN c LS . SENT wamp JJ www JJ sanwork NN photo NN config NN . SENT inc NP on IN line NN 35 VVN my PP$ code NN is VBZ like IN this DT con NN mysqli NNS connect VVP localhost NN , , root NN , , , , db NP . SENT if IN . SENT con NN die NN Could MD not RB connect VV to TO mysql NN . SENT query NN INSERT NN INTO IN customer NN SET VVN custid JJ NULL NN , , Name NN Name NN , , address NN address NN , , description NN description NN . SENT result NN mysqli NNS query NN con NN , , query NN . SENT if IN . SENT result NN echo NN mysql NN error NN . SENT else JJ return NN result NN . SENT kontakt NN at IN goran NP martinic NNS dot VVP de NP 19 CD May NP 2005 CD 11 CD . SENT 55 CD I PP had VHD also RB the DT problem NN to TO activate VV the DT mysql NN extension NN to TO php NP 5 CD . SENT x SYM on IN Windows NNS Server NP 2003 CD and CC Apache NP . SENT After IN a DT lot NN of IN internet NN readings NNS this DT site NN too RB , , and CC a DT tons NNS of IN tries NNS , , I PP found VVD a DT very RB simple JJ way NN . SENT Set VV the DT extension NN dir NN directive NN in IN the DT php NN . SENT ini VVG to TO . SENT ext NN and CC it PP will MD work VV . SENT In IN the DT ext NN directory NN of IN the DT php NN distribution NN you PP will MD find VV all DT I PP guess VVP extensions NNS for IN php NN . SENT 20 CD Mar NP 2005 CD 10 CD . SENT 19 CD Just RB a DT quick JJ note NN which WDT may MD help VV Windows NNS users NNS setting VVG up RP PHP NP Apache NP MySQL NP . SENT I PP was VBD receiving VVG these DT two CD error NN messages NNS on IN Apache NP startup NN . SENT 1 LS The DT procedure NN entry NN point NN mysql NN thread NN end NN could MD not RB be VB located VVN in IN the DT dynamic JJ link NN library NN LIBMYSQL NP . SENT dll NP and CC 2 CD PHP NP Startup NP . SENT Unable JJ to TO load VV dynamic JJ library NN my PP$ php NN installation NN dir NN ext NN php NN mysql NN . SENT dll NP The DT specified JJ procedure NN could MD not RB be VB found VVN . SENT After IN checking VVG that DT libmysql NN . SENT dll NP did VVD exist VV in IN my PP$ root NN PHP NP install VVP dir NN , , and CC that IN this DT dir NN was VBD in IN my PP$ path NN , , I PP determined VVD that IN the DT problem NN was VBD an DT older JJR version NN of IN libmysql NN . SENT dll NP . SENT My PP$ solution NN was VBD to TO search VV all DT harddrives NNS for IN this DT file NN I PP found VVD 6 CD copies NNS of IN 5 CD different JJ versions NNS , , and CC rename VV all DT of IN them PP except IN my PP$ PHP NP install VV dir NN copy NN . SENT PHP NP , , Apache NP and CC MySQL NP all DT function NN as IN expected VVN after IN making VVG this DT change NN . SENT knb NN at IN gfz NP potsdam NP dot VVP de NP 11 CD Oct NP 2004 CD 11 CD . SENT 53 CD This NP is VBZ a DT crucial JJ piece NN of IN information NN for IN SYBASE NP users NNS . SENT If IN you PP are VBP using VVG the DT free JJ , , but CC old JJ , , 11 CD . SENT x SYM client NN libs NNS from IN sybase NP , , then RB compile VV with IN option NN with IN sybase NP ct NP SYBASE NP substitute NN SYBASE NP with IN the DT appropriate JJ directory NN name NN . SENT option NN with IN sybase NP without IN ct NP can MD somehow RB be VB used VVN to TO talk VV to TO old JJ MS NN SQL NP servers NNS , , but CC only RB with IN the DT 11 CD . SENT x SYM client NN libs NNS . SENT If IN you PP are VBP using VVG free JJ , , or CC have VHP legally RB obtained VVN , , 12 CD . SENT x SYM client NN libs NNS from IN sybase NP , , then RB compile VV with IN option NN with IN sybase NP ct NP SYBASE NP SYBASE NP OCS NP substitute NN SYBASE NP SYBASE NP OCS NP with IN the DT appropriate JJ directory NN name NN . SENT Simon NP 05 CD Nov NP 2003 CD 01 CD . SENT 38 CD You PP can MD connect VV to TO Microsoft NP SQL NP Server NP from IN PHP NP without IN using VVG ODBC NP . SENT It's NP even RB detailed JJ in IN the DT PHP NP docs NNS . SENT Wow NN . SENT You PP can MD find VV the DT details NNS at IN http NN . SENT www JJ . SENT php NN . SENT net JJ manual JJ en IN ref NN . SENT mssql NN . SENT php NN jastern NN at IN uci NNS dot VVP edu NP 26 CD Sep NN 2002 CD 11 CD . SENT 24 CD i NP made VVD some DT notes NNS of IN trials NNS tribulations NNS setting VVG up RP PHP NP on IN a DT linux NNS redhat NN 7 CD . SENT 3 CD box NN to TO connect VV via IN interbase NP ODBC NP client NN libraries NNS to TO an DT interbase NN server NN on IN another DT machine NN . SENT http NN . SENT www JJ . SENT faqts NNS . SENT com NN knowledge NN base NN view NN . SENT phtml NN aid NN 18951 CD fid NN 679 CD hope VVP it PP helps VVZ someone NN . SENT . SENT michal NP at IN tuxy NNS dot VVP org NP 27 CD Feb NN 2002 CD 08 CD . SENT 22 CD You PP can MD approch VV problem NN with IN mysql NN and CC pthread NN by IN recompiling VVG linking VVG apache NN 1 CD . SENT 3 LS . SENT 2 CD x SYM with IN pthread NN library NN instead RB of IN removing VVG pthread NN from IN mysql NN . SENT This DT solved VVD my PP$ problem NN with IN apache NN dumping VVG core NN with IN php NP 3 CD . SENT 0 CD . SENT 18 CD and CC php NP 4 CD . SENT 1 LS . SENT 1 CD and CC mysql NN . SENT You PP can MD use VV ldd NN to TO check VV if IN apache NN is VBZ compiled VVN with IN pthreads NNS . SENT Hope NN that WDT helps VVZ . SENT add VV a DT note NN Obtaining VVG PHPInstallation NN Last JJ updated VVN . SENT Wed VVN , , 06 CD Jul NN 2005 CD show NN source NN credits NNS sitemap NN contact NN advertising NN mirror NN sites NNS Copyright NN 2001 CD 2005 CD The DT PHP NP GroupAll NP rights NNS reserved VVD . SENT This DT mirror NN generously RB provided VVD by IN . SENT Schlund NP Partner NN Last JJ updated VVN . SENT Tue NP Aug NN 2 CD 23 CD . SENT 17 CD . SENT 34 CD 2005 CD CEST JJS