Re: [PHP-DB] Re: www-data file

2014-08-26 Thread Jim Giner
On 8/26/2014 11:26 AM, Matt Pelmear wrote: fopen() can create files if they don't exist. I should have read the manual b4 replying. :( -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Writing Problems

2014-08-26 Thread Ethan Rosenberg
Dear List - I can't figure this one out. 1] Straighten out ownership ethan@meow:/var/www$ rm receipt.txt ethan@meow:/var/www$ touch receipt.txt ethan@meow:/var/www$ ls -l receipt.txt -rw-r--r-- 1 ethan ethan 0 Aug 26 19:31 receipt.txt ethan@meow:/var/www$ chmod 766 receipt.txt

Re: [PHP-DB] Writing Problems

2014-08-26 Thread Matt Pelmear
Do you check whether $fh2 is a resource after you fopen()? btw, a better way than: $ chown ethan:ethan filename.txt Might be: $ chown ethan:www-data filename.txt $ chmod 664 filename.txt This way you own the file, the server can write to it (assuming your server has group www-data), and it is

[PHP-DB] www-data file

2014-08-25 Thread Ethan Rosenberg
Dear list - When I use fopen, the file owner and group are both www-data. How can I ensure that the owner and group will be ethan? TIA Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] www-data file

2014-08-25 Thread Aziz Saleh
On Tue, Aug 26, 2014 at 12:20 AM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: Dear list - When I use fopen, the file owner and group are both www-data. How can I ensure that the owner and group will be ethan? TIA Ethan -- PHP Database Mailing List (http://www.php.net/)

Re: [PHP-DB] www-data file

2014-08-25 Thread Karl DeSaulniers
On Aug 25, 2014, at 11:20 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: Dear list - When I use fopen, the file owner and group are both www-data. How can I ensure that the owner and group will be ethan? TIA Ethan Are we talking about file permissions? Best, Karl

Re: [PHP-DB] www-data file

2014-08-25 Thread Matt Pelmear
Another, safer, thing to consider would be setting a sticky bit on whatever directory the files will be in: http://computernetworkingnotes.com/managing-file-system-security/sticky-bit.html I've used sticky bits in a number of situations with multiple groups and users co-habiting environments

[PHP-DB] Re: UPPER(AES_DECRYPT(...)) bug?

2014-08-13 Thread pushkar
Hi Philip Thompson, You better use SELECT UPPER('just a lower case string') AS `UPPER_STRING`, UPPER(CONVERT(AES_DECRYPT(AES_ENCRYPT('Bob Frapples', '1234ABCD'), '1234ABCD')USING latin1)) AS `UPPER_NAME`; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Query does not work

2014-07-02 Thread Lester Caine
On 02/07/14 04:43, Ethan Rosenberg, PhD wrote: while ($row31 = mysqli_fetch_row($result31)) { printf (%s %s %s %s %s\n, $row31[0], $row31[1], $row31[2], $row31[3]); Try print_r( $row31 ); } // no output How can I loose a db connection in the middle of a program? This is not showing

Re: [PHP-DB] Query does not work

2014-07-02 Thread Jim Giner
Once again you have provided the group with RANDOM pieces of code, completely out of context since you have already shown me that your query and db connection are being used in a function, hence your loss of $cxn. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: Query does not work

2014-07-01 Thread Jim Giner
How about just showing us the section of code instead of disjoint pieces that WE cannot be sure are applied correctly? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Query does not work

2014-07-01 Thread Aziz Saleh
On Tue, Jul 1, 2014 at 10:02 AM, Jim Giner jim.gi...@albanyhandball.com wrote: How about just showing us the section of code instead of disjoint pieces that WE cannot be sure are applied correctly? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Re: Query does not work

2014-07-01 Thread Jim Giner
On 7/1/2014 10:26 AM, Aziz Saleh wrote: On Tue, Jul 1, 2014 at 10:02 AM, Jim Giner jim.gi...@albanyhandball.com wrote: How about just showing us the section of code instead of disjoint pieces that WE cannot be sure are applied correctly? -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Re: Query does not work

2014-07-01 Thread Jim Giner
Ethan - is error checking turned on as I showed you how to do EXACTLY last time you posted -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] What is my Mistake?

2014-06-24 Thread Karl DeSaulniers
On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: Dear List - I know I have a mistake here, but I cannot find it. This is a part of a switch. The switch is fed with a formatted phone number [123-456-7890], which is then tested for validity, and if

Re: [PHP-DB] What is my Mistake?

2014-06-24 Thread Karl DeSaulniers
On Jun 24, 2014, at 2:46 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: Dear List - I know I have a mistake here, but I cannot find it. This is a part of a switch. The switch is fed with a

Re: [PHP-DB] What is my Mistake?

2014-06-24 Thread Karl DeSaulniers
On Jun 24, 2014, at 2:53 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Jun 24, 2014, at 2:46 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: Dear List - I know I have a mistake here, but I

[PHP-DB] Re: What is my Mistake?

2014-06-24 Thread Jim Giner
Ethan - You say your script stops here : echo 'here3'; To be sure, you mean that the script DOES echo out 'here3' or does NOT get there? I'm going to guess that it does get to that echo statement but the very next one is going to kill you because you cannot echo out a resource. ONCE AGAIN

Re: [PHP-DB] Re: What is my Mistake?

2014-06-24 Thread Jim Giner
I don't recognize your error reporting configuration. Try this instead: error_reporting(E_ALL | E_NOTICE); ini_set('display_errors','1'); As for php startup errors, if you are not running your own installation, you don't need that. So - if 'here3' is never echoed, then your code does NOT

Re: [PHP-DB] Re: What is my Mistake?

2014-06-24 Thread Jim Giner
Looking at your code again, I think that your query failed and your lack of error reporting isn't showing the error that occurred when you tried to access a property of the result which is not a resource but merely a value of 'false'. One should ALWAYS check the result of operations before

Re: [PHP-DB] Re: What is my Mistake?

2014-06-24 Thread Ethan Rosenberg, PhD
On 06/24/2014 08:12 PM, Ethan Rosenberg, PhD wrote: On 06/24/2014 01:55 PM, Jim Giner wrote: Looking at your code again, I think that your query failed and your lack of error reporting isn't showing the error that occurred when you tried to access a property of the result which is not a

[PHP-DB] What is my Mistake?

2014-06-23 Thread Ethan Rosenberg
Dear List - I know I have a mistake here, but I cannot find it. This is a part of a switch. The switch is fed with a formatted phone number [123-456-7890], which is then tested for validity, and if valid the results of the query are displayed. I cannot get to the display part. Here is the

Re: [PHP-DB] VAR_DUMP INTO PHP VARIABLES

2014-06-19 Thread Karl DeSaulniers
Sent from losPhone On Jun 19, 2014, at 12:40 AM, Oriole Computing oriolecomput...@gmail.com wrote: dear List, we have the following var_dump output from a soap response array(1) { [return]= array(3) { [responseCode]= string(1) 3 [responseMessage]= string(39)

Re: [PHP-DB] VAR_DUMP INTO PHP VARIABLES

2014-06-19 Thread Toby Hart Dyke
If you have the response in a variable, $response: $responseCode = $response[return]['responsecode']; $responseMessage = $response[return]['responseMessage']; $transactionID = $response[return]['transactionID']; This isn't really the right list to ask this question - nothing to do with

Re: [PHP-DB] VAR_DUMP INTO PHP VARIABLES

2014-06-19 Thread Oriole Computing
Hi Toby, my response is in variable $result so i run the code as below $responseCode = $result[return]['responsecode']; but getting this error: PHP Parse error: syntax error, unexpected T_RETURN, expecting '] Warm Regards *SUPPORT TEAMORIOLE COMPUTING* *1938 B1 MUNGWI ROAD*

Re: [PHP-DB] VAR_DUMP INTO PHP VARIABLES

2014-06-19 Thread Toby Hart Dyke
My error! This: $responseCode = $result[return]['responsecode']; should have been $responseCode = $result['return']['responsecode']; The other responses have been rather more elegant, though I think my solution is a little more readable - i.e., I had to think about what was happening for

Re: [PHP-DB] VAR_DUMP INTO PHP VARIABLES

2014-06-19 Thread Aziz Saleh
On Thu, Jun 19, 2014 at 10:09 AM, Toby Hart Dyke t...@hartdyke.com wrote: My error! This: $responseCode = $result[return]['responsecode']; should have been $responseCode = $result['return']['responsecode']; The other responses have been rather more elegant, though I think my

Re: [PHP-DB] VAR_DUMP INTO PHP VARIABLES

2014-06-19 Thread Oriole Computing
Now it says PHP Notice: Undefined index: responsecode Warm Regards *SUPPORT TEAMORIOLE COMPUTING* *1938 B1 MUNGWI ROAD* *LUSAKAZAMBIA* *Skype:* oriolecomputing | *Url:* oriolecomputing.blogspot.com http://generalcomputing.blogspot.com/ On Thu, Jun 19, 2014 at 4:09 PM, Toby Hart Dyke

Re: [PHP-DB] VAR_DUMP INTO PHP VARIABLES

2014-06-19 Thread Oriole Computing
Sorry team, i guess am in the wrong mailing list. The good news is that it has now worked thanks to Toby's solution.. the error was my typing problem ... Thanx Tobby!!! Warm Regards *SUPPORT TEAMORIOLE COMPUTING* *1938 B1 MUNGWI ROAD* *LUSAKAZAMBIA* *Skype:* oriolecomputing | *Url:*

Re: [PHP-DB] Newbie Question $2

2014-06-18 Thread Jim Giner
On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote: On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote: Hi Ethan, Here are some things to clean up your code: Your line: $phn = $_POST[phone]; should use quotations as follows: $phn = $_POST['phone']; Your line: $sql1 ='select Lname, Fname

Re: [PHP-DB] Newbie Question $2

2014-06-18 Thread Karl DeSaulniers
Sent from losPhone On Jun 18, 2014, at 7:56 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote: On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote: Hi Ethan, Here are some things to clean up your code: Your line: $phn =

Re: [PHP-DB] Newbie Question $2

2014-06-18 Thread Aziz Saleh
On Wed, Jun 18, 2014 at 2:13 PM, Karl DeSaulniers k...@designdrumm.com wrote: Sent from losPhone On Jun 18, 2014, at 7:56 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote: On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote: Hi

Re: [PHP-DB] Newbie Question $2

2014-06-18 Thread Jim Giner
On 6/18/2014 2:16 PM, Aziz Saleh wrote: On Wed, Jun 18, 2014 at 2:13 PM, Karl DeSaulniers k...@designdrumm.com wrote: Sent from losPhone On Jun 18, 2014, at 7:56 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote: On 06/17/2014 12:02

Re: [PHP-DB] Newbie Question $2

2014-06-18 Thread Michael Stowe
Can we kill this thread? Or can you guys continue the conversation between yourselves. We now have 8 emails pertaining to the technical question, and 8 emails ranting about him asking it. I understand that some people do not believe this is the appropriate forum for that question - but personal

[PHP-DB] VAR_DUMP INTO PHP VARIABLES

2014-06-18 Thread Oriole Computing
dear List, we have the following var_dump output from a soap response array(1) { [return]= array(3) { [responseCode]= string(1) 3 [responseMessage]= string(39) Duplicate RequestID, Transaction failed [transactionID]= string(21) 104454061823201453721 } } could you

[PHP-DB] Re: Newbie Question $2

2014-06-17 Thread Jim Giner
We're all so eager to help out poor Ethan (who many of you know is NOT a newbie) but nowhere does Ethan say what difficulty he is having. The suggestions made so far are great but what are we solving? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: Newbie Question $2

2014-06-17 Thread Jim Giner
Finally figured out what the question was! Here's a better version of your code Ethan: $phn = $_POST['phone']; // note the quotes on the index if (strlen($phn) 10) { echo Error in phone number entry - must be 10 digits; exit(); } $phn = mysqli_real_escape_string($cxn,$phn);

Re: [PHP-DB] Re: Newbie Question $2

2014-06-17 Thread Lester Caine
On 17/06/14 15:04, Jim Giner wrote: We're all so eager to help out poor Ethan (who many of you know is NOT a newbie) but nowhere does Ethan say what difficulty he is having. The suggestions made so far are great but what are we solving? I see you have spotted the original question :) The

Re: [PHP-DB] Re: Newbie Question $2

2014-06-17 Thread Jim Giner
On 6/17/2014 10:51 AM, Lester Caine wrote: On 17/06/14 15:04, Jim Giner wrote: We're all so eager to help out poor Ethan (who many of you know is NOT a newbie) but nowhere does Ethan say what difficulty he is having. The suggestions made so far are great but what are we solving? I see you

Re: [PHP-DB] Re: Newbie Question $2

2014-06-17 Thread Aziz Saleh
IMO a newbie is someone who read the docs and understood them (at least in theory) before they attempt to write code, which doesn't seem to be the case. On Tue, Jun 17, 2014 at 10:04 AM, Jim Giner jim.gi...@albanyhandball.com wrote: We're all so eager to help out poor Ethan (who many of you

Re: [PHP-DB] Newbie Question $2

2014-06-17 Thread onatawah...@yahoo.ca
Hi Ethan, Here are some things to clean up your code: Your line: $phn = $_POST[phone]; should use quotations as follows: $phn = $_POST['phone']; Your line: $sql1 ='select Lname, Fname from Customers where Phone = $Phn '; Should use double quotes if you need the variable to be

Re: [PHP-DB] Newbie Question $2

2014-06-17 Thread Ethan Rosenberg, PhD
On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote: Hi Ethan, Here are some things to clean up your code: Your line: $phn = $_POST[phone]; should use quotations as follows: $phn = $_POST['phone']; Your line: $sql1 ='select Lname, Fname from Customers where Phone = $Phn '; Should use

[PHP-DB] Newbie Question $2

2014-06-16 Thread Ethan Rosenberg
Dear List - I have the following code: The input from the form is a 10 digit string [1234567890] which is converted to phone number format [123-456-7890] $phn = $_POST[phone]; $phn = (string)$phn; $dsh = '-'; $Phn =

Re: [PHP-DB] Newbie Question $2

2014-06-16 Thread Karl DeSaulniers
On Jun 16, 2014, at 9:58 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: Dear List - I have the following code: The input from the form is a 10 digit string [1234567890] which is converted to phone number format [123-456-7890] $phn = $_POST[phone]; $phn = (string)$phn;

Re: [PHP-DB] Newbie Question $2

2014-06-16 Thread Aziz Saleh
On Mon, Jun 16, 2014 at 10:58 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: Dear List - I have the following code: The input from the form is a 10 digit string [1234567890] which is converted to phone number format [123-456-7890] $phn = $_POST[phone]; $phn = (string)$phn;

Re: [PHP-DB] Newbie Question $2

2014-06-16 Thread Karl DeSaulniers
On Jun 16, 2014, at 10:05 PM, Karl DeSaulniers k...@designdrumm.com wrote: On Jun 16, 2014, at 9:58 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: Dear List - I have the following code: The input from the form is a 10 digit string [1234567890] which is converted to phone

Re: [PHP-DB] Newbie Question $2

2014-06-16 Thread Mike Stowe
Oh a few quick things. First, you can use substr to break up the phone instead of grabbing characters- might be a little easier to read long term. Secondly, mysql_real_escape_string will return the cleaned string, but doesn't change the original variable. So you'll need $phn =

Re: [PHP-DB] MS Access Connection with database password

2014-06-06 Thread Kjell Hansen
Hi again, It's an Access 2000 database and I've changed the password to a single a, still no show :( The database is downloaded on a regular basis and I need to extract some data from it, so I have no control over version or password. Thanks a lot /Kjell Richard Quadling skrev i

Re: [PHP-DB] MS Access Connection with database password

2014-06-06 Thread Karl DeSaulniers
I think the code you translated might be for the .accdb file. In your translated code I noticed .mdb so per that page, this apples for .mdb With database password (mdb file) This is the connection string to use when you have an Access 97 - 2003 database protected with a password using the Set

Re: [PHP-DB] MS Access Connection with database password

2014-06-05 Thread Richard Quadling
Did you read the notes regarding password length, password content and Access version issues? Do any of these apply to you? I suspect one of them does. On 4 June 2014 21:48, Kjell Hansen kj...@kejpa.com wrote: Hi, I'm trying to connect to a MS Access database that has a database password

RE: [PHP-DB] MS Access Connection with database password

2014-06-05 Thread Kjell Hansen
No, I haven't found them :( Please direct me... Password lenght and content is not a problem (I guess!) since I tried changing it to a simple small a without any further success. Thanks a bunch! /Kjell From: Richard Quadling rquadl...@gmail.com Sent: Thu, 5.6.2014 10:06 To: Kjell Hansen

[PHP-DB] Re: What Does God Look For In Our Heart?

2014-06-05 Thread Jim Giner
Really? Do we go around proselytizing about our particular concerns , broadcast them to you when you are doing something completely unrelated? Do you have no sense of propriety? How about the maxim of keeping your religion to yourself and let others keep theirs? Religious zealots (as

[PHP-DB] MS Access Connection with database password

2014-06-04 Thread Kjell Hansen
Hi, I'm trying to connect to a MS Access database that has a database password set. According to http://www.connectionstrings.com/access/ you use the folowing as a connection string in such cases: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb; Jet OLEDB:Database

[PHP-DB] What Does God Look For In Our Heart?

2014-04-26 Thread Ken MD
What Does God look for in our heart? How does God give everyone from the beginning of time an equal opportunity to be saved? The scriptures teach us God wants everyone to be saved ( 1 Tim 2:4 http://biblehub.com/context/1_timothy/2-3.htm ), and that he is Just ( Deuteronomy 32:4

[PHP-DB] PDO::ATTR_TIMEOUT with unixODBC not working the way I expect?

2014-04-11 Thread Rob Crowell
I'm connecting to a closed-source database called Vertica via unixODBC and PDO. Everything is working great but I am having trouble getting PDO::ATTR_TIMEOUT attribute working when I create a connection via: $this-conn = new PDO($dsn, $user, $password,

Re: [PHP-DB] Popular website search engines

2014-03-14 Thread Bastien Koert
wordpress has a built in search as well. It depends on what you what you are wanting to do On Thu, Mar 13, 2014 at 2:46 PM, Matt Pelmear mjpelm...@gmail.com wrote: Besides the usual suspects that are 3rd party, a common solution I've seen is Solr/Lucene: https://lucene.apache.org/solr/

[PHP-DB] Popular website search engines

2014-03-13 Thread Olivier Austina
Hi, I am new to website search engine area.I would like to do a survey of popular search engine used for a website. I found some search engine like FreeFind. http://www.freefind.com/ I know also that Google is used as search engine for some websites. Any suggestion on how website search engine

Re: [PHP-DB] Popular website search engines

2014-03-13 Thread Matt Pelmear
Besides the usual suspects that are 3rd party, a common solution I've seen is Solr/Lucene: https://lucene.apache.org/solr/ -Matt On 03/13/2014 11:44 AM PT, Olivier Austina wrote: Hi, I am new to website search engine area.I would like to do a survey of popular search engine used for a

Re: [PHP-DB] Workout Schedule Calendar

2014-03-01 Thread Lester Caine
Vinay Kannan wrote: I am getting stuck at the DB structuring part for this. 1) I can have all the different types of workouts entered into the DB with the number of days / sessions thats included in a particular package. 2) and then when a member pays the fees eg: for 3 months (12 sessions) so

[PHP-DB] Workout Schedule Calendar

2014-02-28 Thread Vinay Kannan
Hi Experts, A very good morning to you guys! I need your help with something that I am working on currently, its a web application for Workouts, I've been asked to include a work out schedule calendar and I am not very sure as to how to proceed on the same. *Scenario:* Lets say there are about

Re: [PHP-DB] Transactions with PDO_INFORMIX

2014-01-15 Thread Rahul Priyadarshi2
If any query failed inside a transaction then PDO will not issue a rollback, It will left the decision on you that you want to ignore the failed query it or want a rollback. You can find the examples of handing of query failure inside a transaction at

[PHP-DB] Transactions with PDO_INFORMIX

2014-01-14 Thread Neomi TR
Hi, I use the PDO functions PDO::beginTransaction, PDO::commit and PDO::rollBack to begin, commit and rollback transactions. I also check that we are in active or no active transaction with 'PDO::inTransaction'. System info: PHP 5.3.28 INFORMIX 11.70 PDO_INFORMIX-1.3.0 Lately we have

[PHP-DB] PDO Connection problem

2014-01-10 Thread Jim Giner
History: I'm trying to help a friend who is hosting his domain with the same company that I use. I've been using this company for several years and have used a certain 'connection' script all the time. Part of it looks like this:

Re: [PHP-DB] PDO Connection problem

2014-01-10 Thread Aziz Saleh
On Fri, Jan 10, 2014 at 10:13 AM, Jim Giner jim.gi...@albanyhandball.comwrote: History: I'm trying to help a friend who is hosting his domain with the same company that I use. I've been using this company for several years and have used a certain 'connection' script all the time. Part of it

Re: [PHP-DB] Billing Module in PHP

2014-01-09 Thread Lester Caine
Vinay Kannan wrote: Currently the DB structure stores the following : 1) Customer details. 2) Membership ID and the payment paid at the time of signing up (I am thinking i might not need the signing up amount to be stored in the customer DB in the first place, and have them seperate in a table

[PHP-DB] Billing Module in PHP

2014-01-08 Thread Vinay Kannan
I am working on an appplication with a Billing Module. The customers will pay in the following manner. 1) Signing up Fees, at this time they will choose they payment intervals, monthly, quaterly, 6 months or annual. 2) A customer can also change the billing type at a later time, Eg: after paying

[PHP-DB] please help..new problems php. 5.5.7.tar.bz2 and iis 5.1

2013-12-14 Thread Fred Silsbee
downloaded php 5.5.7.tar.bz2 see attached screenshot I did an Add and the dialog requested a suffix (php) and a filename where is the file name and where might it be found I did this same task about 3 years ago and it worked -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] Calculating Past Dates In A Different Time Zone

2013-11-10 Thread Ron Piggott
Hi Everyone I need help knowing how to calculate midnight “X” days ago in whatever time zone the user has selected. - The context of this is creating a report - An Example: I am want to base the report on records created between 2013-11-01 00:00:00 and 2013-11-07 23:59:59 in the users time

Re: [PHP-DB] Calculating Past Dates In A Different Time Zone

2013-11-10 Thread Matt Pelmear
Ron, You could use the same technique here if you want to do the work in PHP: === php code === assert( convertToGMT('2013-11-01 00:00:00') == '2013-11-01 04:00:00' ); // EST offset by four hours assert( convertToGMT('2013-11-07 23:59:59') == '2013-11-08 04:59:59' ); // EDT offset by five

Re: [PHP-DB] Calculating Past Dates In A Different Time Zone

2013-11-10 Thread Tamara Temple
On Nov 10, 2013, at 10:26 AM, Ron Piggott ron.pigg...@actsministries.org wrote: I normally use the following code to convert between time zones. But I don’t know how to calculate what time it is in GMT time zone when it is midnight in the users time zone X days ago, or midnight on

Re: [PHP-DB] Calculating Past Dates In A Different Time Zone

2013-11-10 Thread Ron Piggott
A suggestion I was given is to use the mySQL CONVERT_TZ command with the PHP time zone names. But when I do: SELECT CONVERT_TZ( `journal_entry`.`occurance_date` , 'GMT', 'America/Bahia' ) FROM `journal_entry` I am receiving NULL as the resulting date. Does mySQL accept PHP time zone

Re: [PHP-DB] Calculating Past Dates In A Different Time Zone

2013-11-10 Thread Matt Pelmear
Typically, yes. It is possible you don't have the time zone tables populated. America/Bahia works for me, so I suspect that is the case. The relevant manual page to load this data (assuming your server is running in a unix environment) is here:

[PHP-DB] joints - extracting common results from comparing 2 tables

2013-10-23 Thread Taco Mathijs Hillenaar-Meerveld
Good afternoon, i haven't done much with php and Mysql the past 2 years so my knowledge is not really up-to-date. i'm not a hero when it comes to math. actually, it's a weakness but trying to fix that. i made a query where i compare 2 tables against eachother and then i want to see a table that

[PHP-DB] Re: joints - extracting common results from comparing 2 tables

2013-10-23 Thread Jim Giner
On 10/23/2013 8:15 AM, Taco Mathijs Hillenaar-Meerveld wrote: Good afternoon, i haven't done much with php and Mysql the past 2 years so my knowledge is not really up-to-date. i'm not a hero when it comes to math. actually, it's a weakness but trying to fix that. i made a query where i

Re: [PHP-DB] Subject Matter

2013-08-27 Thread Daniel Brown
On Fri, Aug 23, 2013 at 4:21 AM, Matijn Woudt tijn...@gmail.com wrote: The problem is: there is no maintainer;) Sure there is. -- /Daniel P. Brown Network Infrastructure Manager http://www.php.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Subject Matter

2013-08-27 Thread Matijn Woudt
Op 27 aug. 2013 18:06 schreef Daniel Brown danbr...@php.net het volgende: On Fri, Aug 23, 2013 at 4:21 AM, Matijn Woudt tijn...@gmail.com wrote: The problem is: there is no maintainer;) Sure there is. -- /Daniel P. Brown Network Infrastructure Manager http://www.php.net/ Uh,

Re: [PHP-DB] Subject Matter

2013-08-27 Thread Daniel Brown
On Tue, Aug 27, 2013 at 12:10 PM, Matijn Woudt tijn...@gmail.com wrote: Uh, you're right. I meant moderator.. Yeah, as far as moderation, we only do in extreme circumstances. -- /Daniel P. Brown Network Infrastructure Manager http://www.php.net/ -- PHP Database Mailing List

Re: [PHP-DB] Subject Matter

2013-08-26 Thread Thomas Rudy
There are a lot of off topic emails sent. But there is far more whining and complaining. Good grief! On Fri, Aug 23, 2013 at 2:40 PM, Tamara Temple tamouse.li...@gmail.comwrote: On Aug 23, 2013, at 7:32 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 8/23/2013 4:52 AM, Matt Pelmear

Re: [PHP-DB] Subject Matter

2013-08-26 Thread Michael Stowe
*There are a lot of off topic emails sent. But there is far more whining and **complaining. Good grief! +1* Let's remember that not everyone on the list is an expert programmer or someone with years of DBA experience. The purpose of the list (IMHO) is to HELP others with their PHP/DB questions,

Re: [PHP-DB] Subject Matter

2013-08-26 Thread Karl DeSaulniers
On Aug 26, 2013, at 11:19 AM, Michael Stowe wrote: *There are a lot of off topic emails sent. But there is far more whining and **complaining. Good grief! +1* Let's remember that not everyone on the list is an expert programmer or someone with years of DBA experience. The purpose of

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Lester Caine
Ethan Rosenberg wrote: I'm probably wrong, but in some contexts; eg, sql query, $ signs are not used. I tried and added the incorrect $ sign, and Netbeans did not complain. If anyone knows of an editor that will able to spot this kind of error, please inform the list. You do need to take a

Re: [PHP-DB] Bluefish for PHP

2013-08-23 Thread Michael Oki
Simply install wamp server and save yourself from separate installation of MySQL,PHP,Apache server,phpMyAdmin and sqlite. Check the link below. http://wampserver.com On 23 August 2013 01:29, Ethan Rosenberg erosenb...@hygeiabiomedical.comwrote: Dear List - How do I configure Bluefish for

Re: [PHP-DB] Bluefish for PHP

2013-08-23 Thread Lester Caine
Ethan Rosenberg wrote: Dear List - How do I configure Bluefish for PHP? I am running version 2.2.4 of Bluefish. I'd forgotten about bluefish. You should not need to do anything. PHP files are just processed as PHP? But it's more an HTML editor and geared to producing and verifying HTML so

Re: [PHP-DB] Bluefish for PHP

2013-08-23 Thread Michael Oki
Install Komodo IDE or Adobe Dreamweaver. They'll highlight errors and warnings. On 23 August 2013 08:20, Lester Caine les...@lsces.co.uk wrote: Ethan Rosenberg wrote: Dear List - How do I configure Bluefish for PHP? I am running version 2.2.4 of Bluefish. I'd forgotten about bluefish.

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Karl DeSaulniers
If your on a PC I would just get Eclipse. But if you have netbeans, you can set the syntax highlighting for the different scripts you write in the preferences. PHP, java, javascript, etc... Best, Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List

Re: [PHP-DB] Bluefish for PHP

2013-08-23 Thread Karl DeSaulniers
Komodo is very nice. Karl DeSaulniers Design Drumm http://designdrumm.com On Aug 23, 2013, at 2:58 AM, Michael Oki wrote: Install Komodo IDE or Adobe Dreamweaver. They'll highlight errors and warnings. On 23 August 2013 08:20, Lester Caine les...@lsces.co.uk wrote: Ethan Rosenberg

[PHP-DB] Subject Matter

2013-08-23 Thread Matt Pelmear
Hello all, I am subscribed to this list because of my interest in PHP's database integration. At this point only a small percentage of the messages are related to that. I am not sure who runs the list, whether they care about off-topic posts, or whether anyone else cares about it. I, however,

Re: [PHP-DB] Subject Matter

2013-08-23 Thread Matijn Woudt
On Fri, Aug 23, 2013 at 10:15 AM, Matt Pelmear mjpelm...@gmail.com wrote: Hello all, I am subscribed to this list because of my interest in PHP's database integration. At this point only a small percentage of the messages are related to that. I am not sure who runs the list, whether they

Re: [PHP-DB] Bluefish for PHP

2013-08-23 Thread Lester Caine
Michael Oki wrote: Install Komodo IDE or Adobe Dreamweaver. They'll highlight errors and warnings. Last time I looked neither were free? Eclipse has served me well for many years and while it has it's problems often someone comes up with a new plugin to sort it. My problem is dealing with the

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Lester Caine
Karl DeSaulniers wrote: If your on a PC I would just get Eclipse. But if you have netbeans, you can set the syntax highlighting for the different scripts you write in the preferences. PHP, java, javascript, etc... But the problem tha5 has been identified will never be flagged by simple

Re: [PHP-DB] Subject Matter

2013-08-23 Thread Lester Caine
Matt Pelmear wrote: I am not sure who runs the list, whether they care about off-topic posts, or whether anyone else cares about it. The php lists are only loosely moderated, but comments like yours usually bring things under control. I'd refer you to my recent post thought as to why the

Re: [PHP-DB] Subject Matter

2013-08-23 Thread Matt Pelmear
On 08/23/2013 04:36 PM, Lester Caine wrote: Matt Pelmear wrote: I am not sure who runs the list, whether they care about off-topic posts, or whether anyone else cares about it. The php lists are only loosely moderated, but comments like yours usually bring things under control. I'd refer

Re: [PHP-DB] Subject Matter

2013-08-23 Thread Lester Caine
Matt Pelmear wrote: On 08/23/2013 04:36 PM, Lester Caine wrote: Matt Pelmear wrote: I am not sure who runs the list, whether they care about off-topic posts, or whether anyone else cares about it. The php lists are only loosely moderated, but comments like yours usually bring things under

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Jim Giner
On 8/22/2013 8:08 PM, Ethan Rosenberg wrote: Ethan Rosenberg, PhD /Pres/CEO/ *Hygeia Biomedical Research, Inc* 2 Cameo Ridge Road Monsey, NY 10952 T: 845 352-3908 F: 845 352-7566 erosenb...@hygeiabiomedical.com On 08/22/2013 06:56 PM, Jim Giner wrote: On 8/22/2013 4:14 PM, Ethan Rosenberg

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Jim Giner
On 8/23/2013 4:32 AM, Lester Caine wrote: Karl DeSaulniers wrote: If your on a PC I would just get Eclipse. But if you have netbeans, you can set the syntax highlighting for the different scripts you write in the preferences. PHP, java, javascript, etc... But the problem tha5 has been

Re: [PHP-DB] Subject Matter

2013-08-23 Thread Jim Giner
On 8/23/2013 4:52 AM, Matt Pelmear wrote: On 08/23/2013 04:36 PM, Lester Caine wrote: Matt Pelmear wrote: I am not sure who runs the list, whether they care about off-topic posts, or whether anyone else cares about it. The php lists are only loosely moderated, but comments like yours usually

[PHP-DB] PHP5 with Solid 3.0

2013-08-23 Thread Renze Munnik
Hi all, We really seem to have a problem: We have an old server running PHP4 and a Solid database 3.0. That combination still works fine after so many years. Unfortunately the hardware it's running on starts to let us down. On quite short notice we need to have a stable solution. We hired

Re: [PHP-DB] Subject Matter

2013-08-23 Thread Tamara Temple
On Aug 23, 2013, at 7:32 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 8/23/2013 4:52 AM, Matt Pelmear wrote: On 08/23/2013 04:36 PM, Lester Caine wrote: Matt Pelmear wrote: I am not sure who runs the list, whether they care about off-topic posts, or whether anyone else cares about

Re: [PHP-DB] mysql query

2013-08-22 Thread Michael Oki
Try the insertion like this: $sql2 = mysql_query(insert into Inventory (`UPC` , `quant`, `manuf`, `item`, `orderpt`, `ordrpt_flag`, `stock`) .values ('$upc', $qnt,'$mnf','$itm', '$odrpt', '0', '$stk') ) or die(mysql_error()); On 22 August 2013 05:10, Daniel Krook

Re: [PHP-DB] mysql query

2013-08-22 Thread Vinay Kannan
$sql2 = insert into Inventory (UPC, quant, manuf, item, orderpt, ordrpt_flag, stock) values ('$upc', '$qnt','$mnf','$itm', '$odrpt', 0, $stk); Looks like, you have the ' ' missing for $qnt and odrpt had the $ and the '' missing. The above query should work, I haven't tested it though. Also for

<    1   2   3   4   5   6   7   8   9   10   >