Re: [PHP-DB] connect to filemaker via odbc
I haven't tried it, but the best solution seems to be the FX.php classes for connecting to FileMaker from PHP by Chris Hansen. For more information and to download, try: http://www.iviking.org/projects/FXdownload.php I believe you'll have to turn on Web Companion on FileMaker for this to work. Hope that helps, Joshua Hoover > Hi, > has anybody experience with connecting to filemaker via odbc. > thanx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] cron job
Hi Jen,
Remove the "WHERE" clause (in your code: WHERE uid={$session["uid"]}) in
your query and that will update all rows in the table.
Hope that helps,
Joshua Hoover
> Ok I have the cron job figured out. The only thing I would like help with is
> how to update all users in a table.
>
> This just updates a spacific user:
> $db["points"]=("UPDATE wt_users set points = points + 1000 WHERE
> uid={$session["uid"]}");
> $result=mysql_query($db["points"]);
>
> How would I use this to update all users.
>
> Any help would be appreciated.
>
> Thanks
> Jen
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] SQL/PHP problem
What format is $expDate in? You'll need to make sure it's in the format your database expects for a date type column. Joshua Hoover > I'm trying to delete rows from a database where the date is older then my > $expDate variable, but for some reason, no matter what I try and what > examples I use for help, I can't get this to work??? I first took the > $expDate string and set the var type to "integer". The datatype for the > "msgCreated" field is "int". > > I first tried: > $sql = "DELETE * FROM Table WHERE msgCreated < '$expDate'"; > > and it didn't work so I then tried it without the single quotes: > > $sql = "DELETE * FROM Table WHERE msgCreated < $expDate"; > > still, it didn't work. Am I missing something fundamental here? Is this one > of those RTFM questions? > > Thanks, > > Brian -- 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] Persistent Connections
According to the docs and everything I've seen with PHP and persistent
connections, you don't have to close the connection since PHP will
simply reuse.
Joshua Hoover
> Howdy--I have a question about persistent connections and their
> behavior:
>
> Apache 1.3.2 / PHP 4.0.6 - as a module
> Win2k
>
> I call the following function:
>
> odbc_pconnect("dsn", "user", "pass");
>
> At the end of the script I do NOT call odbc_close($dbConn);
>
> I was doing some testing and ran into a:
>
> Maximum number of processes exceeded etc.. etc.. etc..
>
> This is in relation to the persistent connections. Now the question
> is, does ODBC_CLOSE really close the connection? Or another way of
> asking is, does ODBC_PCONNECT look for a use an existing connection, or
> does it launch another one?
>
> Should I close the connection and not worry about it?
> Thanks
> RDB
--
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 and MS SQL 2000 Performance
I run SQL Server on my Pentium III 800mhz laptop which also runs IIS 5 and a variety of other services (including the PHP cgi) and have not seen any type of performance problems. First, are you using the mssql.dll to connect or ODBC? Second, are you running PHP as a cgi or ISAPI plug-in? Third, is performance from an ODBC client and/or remote Query Analyzer client slow performing the same queries? Fourth, did you check your SQL Server box and look at the activity on it? Is SQL Server or some other service hogging resources? Thanks, Joshua Hoover > We're only running one database on the system. The sample databases that > come with the software are still on there, but they're not being used at > all - this system is still in the testing stage. We're running an > Athlon > 1.2 GHz processor with 512 MB RAM. > > "Gadam" <[EMAIL PROTECTED]> wrote in message > 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... > MS SQL has generally very slow performance and is consuming a lot of > system resources. Are you running any other databases on the SQL server, > apart from the one you are querying? Could it be that your system has > very small processing power? In any case, these possibilities wouldn't > justify suck a long delay, unless you SQL server is "overcrowded" with > other huge databases that you use... > George > > > > -- > 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] MySQL too many connection problems
There is a setting when you launch MySQL to tell it how many connections it will accept. Read the following to get a better idea on this: http://www.mysql.com/doc/T/o/Too_many_connections.html The default number of connections to MySQL is 100, but can be set much higher if necessary. You need to set the configuration option "max_connections=xxx" (with "xxx" being the number of connections you'd like to try), probably in your my.cnf file. Check out: http://www.mysql.com/doc/O/p/Option_files.html Using persistent connections is a good idea if you don't have a TON of Apache processes running. If you do, then you're going to be opening at least that many connections which will only make your problems worse. Hope that gets you pointed in the right direction. Joshua Hoover > Hi folks-- > > I'm working on an installation of phpshop 0.6x and have started getting > "too many connections to the database" errors whenever I work with it > for any length of time. I have a heavily database-driven and busy site > calling on three databases. Having heard that mysql_pconnect is better > to use than mysql_connect, I thought maybe my other scripts using the > latter were causing the problem so I moved the busiest pages from > mysql_connect to mysql_pconnect. No go. -- 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]
