Re: [PHP-DB] Backups, best practices
you can get command line zip/compression packages for windows, although for *some* reason, as far as i know, not a command line version of winzip - the big one! err.. please correct me if I'm wrong, but isn't pkzip exactly that? or more exactly, winzip is a windows interface to it? it certainly uses the same compression anywho, all of those should be able to be scheduled using the at command from DOS (good old DOS... the closest a microsoft weenie will come to heaven (*nix) :P) HTH Beau // -Original Message- // From: Dan Brunner [mailto:[EMAIL PROTECTED]] // Sent: Friday, 7 September 2001 2:33 AM // To: Jacob Singh // Cc: [EMAIL PROTECTED] // Subject: Re: [PHP-DB] Backups, best practices // // // Hey Hey Hey!!! // // That depends on what system your running!?!?!? // // I run LinuxPPC and use 3 ways // // 1. Bru Tape back system // // 2. At 12:00 AM the shell script runs and copies the files.. // // 3. Once a month I manually copy the files to a zip. // // // Dan // // // // PS WindowsGood luck. // // // On Thursday, September 6, 2001, at 09:22 AM, Jacob Singh wrote: // // Hello, // //I'm just wondering how everyone manages their MySQL backups, I'm //looking for a better solution than manual. any scripts // or example //would be especially appreciated. tnks // // -- // Best regards, // Jacob Singh // Pajama Design // (413)582-9342 // 2 Belanger Pl. // Northampton, MA 01060 // // mailto:[EMAIL PROTECTED] // // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, e-mail: [EMAIL PROTECTED] // For additional commands, e-mail: [EMAIL PROTECTED] // To contact the list administrators, e-mail: // [EMAIL PROTECTED] // // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, e-mail: [EMAIL PROTECTED] // For additional commands, e-mail: [EMAIL PROTECTED] // To contact the list administrators, e-mail: // [EMAIL PROTECTED] // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Backups, best practices
// you can get command line zip/compression packages for // windows, although // for // *some* reason, as far as i know, not a command line // version of winzip - // the // big one! // // err.. please correct me if I'm wrong, but isn't pkzip // exactly that? or more // exactly, winzip is a windows interface to it? it certainly // uses the same // compression nope - you're right, i forgot about pkzip, but i was just saying that it's pretty strange that winzip is the biggest compression program used for windoze machines and they haven't released their own command-line version... last i heard it was still in the piplelines. pkzip is made by a different company i think -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Stored Procedure
On Tue, Sep 04, 2001 at 07:44:42AM -0800, [EMAIL PROTECTED] wrote: Hello everyboby! this is my first time on this list and I writing to ask for help on SP. I have the following code calling a Procedure: ? $c=OCILogon(SYSTEM,manager); $x =0; $cpf=10001628852; $sth = OCIParse ($c, begin CPF_ORA(:cpf);end; ); OCIBindByName ( $sth, :cpf, $cpf,32); $cpf=12; OCIExecute ($sth ); re, tc ? and I having this error message: Fatal error: Only variables can be passed by reference in c:\program files\apache group\apache\htdocs\testes\procedure5.php on line 10 can aybody help me? thanks Bona __ Visite http://www.trama.com.br -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] RE: bizarre ocilogon problem
On Wed, Sep 05, 2001 at 10:24:28AM -0500, Brian Mauter wrote: Are you running out of logons? You should only need the client libraries on the machine with the PHP pages. You do not need them anywhere else. (That's the beauty of the web!) Make sure you have ocilogoff in your PHP page when you're done. Even better (for performance reasons) create a session. Then ONLY the first time that any of your pages load, run your ocilogon. After that just reuse the logon. From then on, just make a new statement everytime you need to query the database. Lastly, when I used PHP/Apache/Linux to talk to Oracle/NT4, I was getting stray defunct oracle processes hanging around on my Linux box. The effect was that pages would work from one client PC, but not from another. I think everytime I created a connection, it created the process. The only way I could find to get around that was to recompile PHP with --enable-sigchild. This is PHP's own signal handler and it will clean up the stray oracle processes. Good luck, Brian -Original Message- From: Galvin, Max [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 10:07 AM To: '[EMAIL PROTECTED]' Subject: bizarre ocilogon problem Hi, I have a page that retrieves info from an Oracle database and which works fine when I view it. When I switch to another PC with the same OS/browser (NT/IE5) I get an error: call to unsupported or undefined function ocilogon() We have the client libs installed but it's only on one or two machines that this fails. Any ideas why? you donÄt have oracle-oci support in you php! please configure php using --with-oci8. re, tc -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Checkboxes with mySQL
I have a database with articles from which I can make a selection of which articles to show. This selection is made by a form with checkboxes. In the mysql table is a field called pr. If there's a 1 in this field, the article should be shown for print, if there's a 0, it shouldn't. In the code I generate a form with all the titles and checkboxes. The checkbox values are the id's from the titles. When I click the button, I want to see my selection. The problem is this: What sql query can be used to proces the information from the checkboxes? At the moment I use in order to change the values in the database according to the checkbox selections: $query = mysql_query(UPDATE articles SET pr='1' WHERE id='$p[id]'); But it does nothing! How can I insert multiple values (from the checkbox array) at one time in a database? Cilfa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Checkboxes with mySQL
Cilfa [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... $query = mysql_query(UPDATE articles SET pr='1' WHERE id='$p[id]'); But it does nothing! How can I insert multiple values (from the checkbox array) at one time in a database? UPDATE articles SET pr='1' WHERE id IN ( ...list... ) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Checkboxes with mySQL
You have to check each checkbox value in you selection criteria. Somthing like: $query = UPDATE articles SET pr=1 WHERE 0; # assume $nbr is size of array $p for($i=0; $i$nbr;$i++) { if( isset($p[$i]) ) { $query .= || id=$p[$i] ; } This will construct a query that looks like: UPDATE articles SET pr=1 WHERE 0 || id=1 || id=3 || id=4 The 0 in the WHERE clause is just a place holder; it saves a little coding. Hope this helps rick -Original Message- From: Cilfa [mailto:[EMAIL PROTECTED]] Sent: Friday, September 07, 2001 7:38 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Checkboxes with mySQL I have a database with articles from which I can make a selection of which articles to show. This selection is made by a form with checkboxes. In the mysql table is a field called pr. If there's a 1 in this field, the article should be shown for print, if there's a 0, it shouldn't. In the code I generate a form with all the titles and checkboxes. The checkbox values are the id's from the titles. When I click the button, I want to see my selection. The problem is this: What sql query can be used to proces the information from the checkboxes? At the moment I use in order to change the values in the database according to the checkbox selections: $query = mysql_query(UPDATE articles SET pr='1' WHERE id='$p[id]'); But it does nothing! How can I insert multiple values (from the checkbox array) at one time in a database? Cilfa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Don't Leave Any Tracks Behind...
FFA Posting Engine..This email address was used to post to our site ! Removal Instructions at the bottom of this page ! Don't Leave Any Tracks Behind... WARNING: Your Computer tracks all of your internet activity and all of the actions performed on it... If your computer is not secure,anyone can find out what you have been doing on the internet ! ARE YOU AND YOUR COMPUTER SAFE FROM POTENTIAL PROBLEM ? CLEAN YOUR TRACKS with Clean Browser ! it permantly cleans your computer, getting rid of cookies, cache, history, browser settings, Auto Fill Forms, index.dat file and more ! MAINTAIN YOUR PRIVACY ! CLICK HERE ! site: cleanbrowser url: http://www.cleanbrowser.com/ft=sb435/ site: isupercharger url: http://www.isupercharger.com/ft=sb435/ site: softwarebucks url: http://www.softwarebucks.com/ref=sb435/ Probably the Best Source of Internet Marketing Resources on the net ! Join Free !...Take a Test Drive ! Check it out : http//hop.clickbank.net/hop.cgi?overscaig/ysopro Thank you . Sincerely , john wild * NOTE: You are receiving this message because you visited our HIGH TRAFFIC FFA page , and posting your link at http://thelinkpost.cjb.net and you agreed to receive our mailings ! if this is not the case, or you wish to remove yourself from list, PLEASE follow a link below and remove your email address ! http://bulklite.com/remove.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP linux interbase Apache
Thank you very much everything work fine now steph Meir Kriheli a écrit : On Thursday 06 September 2001 18:47, Stephane MOREL wrote: Thank you for your answer Interbase is installed in /opt/interbase. I don't use --with-apxs. What I need now is to eanble connection to interbase through PHP. It seems to me I only need to compile PHP with the --with-interbase=/opt/interbase to create the file interbase.so.But I guess I'm wrong Thank you for your help It all depends on how you install PHP (assuming you're using Apache) --with-apache : static PHP compiled into apache (needs to cmpile Apache) --with-apxs: dynamic apache module (no need to compile Apache) without any of them : compiled as a standalone cgi executable As for compiling with interbase: --with-interbase=/opt/interbase won't create the interbase.so file, but rather compile PHP with interbase support built into it. If you want the shared interbase module (.so) you should compile with: --with-interbase=shared,/opt/interbase and modify your php.ini I suggest you read the relevant pages in the manual. Find them at http://www.php.net/manual/en/install.unix.php http://www.php.net/manual/en/install.configure.php -- Meir Kriheli steph Paul Cooper a écrit : On Thu, Sep 06, 2001 at 03:38:18PM +0100, Stephane MOREL wrote: Thank you for your answer after a glance on the net I have found I need interbase.so. This is not present on my disk do you how can I retrieve it steph How and where did you intsall interbase - it's been a while so I forget. I think the rpm version installs itself in /opt/interbase (you can check with rpm -ql interbase). If that is the case then you need to configure with ./configure --with-apxs=/path/to/apxs --with-interbase=/opt/interbase --enable-track-vars Paul Meir Kriheli a écrit : On Thursday 06 September 2001 13:31, Stephane MOREL wrote: Hi all I'm new on PHP. I've installed PHP interbase Apache correctly. But I would like to connect Interbase database through PHP. So I enable interbase support for php by doing this : ./configure --with-interbase --with-apache --enabled-track-vars if you compile with --with-apache, you'll have to recompile apache too. You can compile it as a shared module --with-apxs=path to your apxs. Note: you'll need Apache development stuff (Depends on your distro). Any way after running make install make sure you've restarted Apache. make make install Evreything works fine When I do this : ? $conn=ibase_connect(192.168.2.2:/opt/interbase/examples/employee.g db, SYSDBA, masterkey); if (!$conn) { echo Access Denied!; exit; } ? my browser say :Call to undifined function :ibase_connect. I understood that I must enable the extension in php.ini. I think the extension was automatically added to my php.ini but I can not find any entry in php.ini for interbase. If someone could help TIA Steph -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- - Paul Cooper | Tel: 0121 331 7858 Senior Programmer and Database Engineer | Fax: 0121 331 7859 UCEcom | mailto:[EMAIL PROTECTED] University of Central England | http://www.ucecom.com Birmingham, B4 7DX | - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] problem with dbase connections using ODBC
Windows NT 4.0 workstation Apache PHP 4 the following code works fine and returns the correct results... ? $connect = odbc_connect(partner,,); $query = SELECT company FROM listing; $result = odbc_exec($connect, $query); while(odbc_fetch_row($result)){ print odbc_result($result, company) . br; } odbc_close($connect); ? --- but if someone else is accessing the table (not exclusively) i get the error message. -- Warning: SQL error: [Microsoft][ODBC dBase Driver] The Microsoft Jet database engine cannot open the file 'N:\listing.DBF'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLExecDirect in c:\Program Files\Apache Group\Apache\htdocs/test.php on line 6 -- Is there a work around for this or a fix? I need to give internet access for this older internal database at the same time local users are accessing it. I've tried using ASP and PWS and it works but I really want to use PHP ; thanks in advance don -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] DB design question (so maybe a little OT)
Hey all, I have 4 database tables, that each describe some sort of 'person' (transporting company, truck-driver, ..) and have almost exactly the same fields. Is this the best way of storing this, or does this make more sense: One table, with all the same fields + 1 extra, noting the type of person (that could come from yet another table). Any suggestions, 'cause this really bothers me. :) ad. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] DB design question (so maybe a little OT)
On Fri, 7 Sep 2001, Alexander Deruwe wrote: I have 4 database tables, that each describe some sort of 'person' (transporting company, truck-driver, ..) and have almost exactly the same fields. Is this the best way of storing this, Nope... or does this make more sense: One table, with all the same fields + 1 extra, noting the type of person (that could come from yet another table). Correct, and another table person_type perhaps, with an id and a description, add another field to your person table with a foreign key to something in the person_type table. Justin Buist Trident Technology, Inc. 4700 60th St. SW, Suite 102 Grand Rapids, MI 49512 Ph. 616.554.2700 Fx. 616.554.3331 Mo. 616.291.2612 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: DB design question (so maybe a little OT)
I'm thinking that you should get all the common fields among the different types of people: F. Name, L. Name, Address, CC Number And then create a different table containing additional information that only pertains to certain types of people. Then join them using an id. - Jonathan Alexander Deruwe [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hey all, I have 4 database tables, that each describe some sort of 'person' (transporting company, truck-driver, ..) and have almost exactly the same fields. Is this the best way of storing this, or does this make more sense: One table, with all the same fields + 1 extra, noting the type of person (that could come from yet another table). Any suggestions, 'cause this really bothers me. :) ad. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]