RE: [PHP-DB] Re: Problem with query

2013-06-25 Thread OJFR
Yeah, Jim, please explain what u mean by Per the manual, associative arrays using string indices should always use ' ' around them. They work (as mentioned in the manual) but are wrong. As long as I remember I could use associative arrays in that way (ex. $_SESSION['Cust_Num']). There's another

Re: [PHP-DB] Re: Problem with query

2013-06-25 Thread Toby Hart Dyke
What Jim means is here in the manual: http://www.php.net/manual/en/language.types.array.php#language.types.array.donts In a nutshell: Always use quotes around a string literal array index. For example, /$foo['bar']/ is correct, while /$foo[bar]/ is not. The reason is that without the

Re: [PHP-DB] Re: Problem with query

2013-06-25 Thread Michael Oki
I'm sorry I've not been following the last three responses. In a nutshell, what EXACTLY does the poster of this issue want? On 25 June 2013 11:06, Toby Hart Dyke t...@hartdyke.com wrote: What Jim means is here in the manual: http://www.php.net/manual/en/**language.types.array.php#**

Re: [PHP-DB] Re: Problem with query

2013-06-25 Thread Jim Giner
On 6/25/2013 6:06 AM, Toby Hart Dyke wrote: What Jim means is here in the manual: http://www.php.net/manual/en/language.types.array.php#language.types.array.donts In a nutshell: Always use quotes around a string literal array index. For example, /$foo['bar']/ is correct, while /$foo[bar]/

Re: [PHP-DB] Re: Problem with query

2013-06-25 Thread Toby Hart Dyke
The original post is here: http://news.php.net/php.db/48751 On 6/25/2013 1:02 PM, Michael Oki wrote: I'm sorry I've not been following the last three responses. In a nutshell, what EXACTLY does the poster of this issue want? On 25 June 2013 11:06, Toby Hart Dyke t...@hartdyke.com wrote:

Re: [PHP-DB] Re: Problem with query

2013-06-25 Thread Jim Giner
On 6/25/2013 2:32 AM, OJFR wrote: Yeah, Jim, please explain what u mean by Per the manual, associative arrays using string indices should always use ' ' around them. They work (as mentioned in the manual) but are wrong. As long as I remember I could use associative arrays in that way (ex.

Re: [PHP-DB] Problem with query

2013-06-25 Thread Karl DeSaulniers
Im going to play devils advocate here and say, why is it the one who's helping that needs to be polite and respectful? Isn't it also the newbies responsibility to respect and be polite to those taking time out of their day to help them and not be so stubborn as to not take the advice given

Re: [PHP-DB] Problem with query

2013-06-23 Thread Matijn Woudt
On Sun, Jun 23, 2013 at 8:31 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - There is an error in my query, and I cannot find it. This fails: $_SESSION['Cust_Num'] = $_REQUEST['cnum']; $_SESSION['CustNum'] = $_REQUEST['cnum']; echo sessionbr /; //this has

Re: [PHP-DB] Re: Problem with query

2013-06-23 Thread Richard Quadling
On 23 June 2013 21:37, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: On 6/23/2013 2:31 PM, Ethan Rosenberg, PhD wrote: Dear List - There is an error in my query, and I cannot find it. This fails: $_SESSION['Cust_Num'] = $_REQUEST['cnum']; $_SESSION['CustNum'] =

Re: [PHP-DB] Problem wkith Query

2013-06-23 Thread Ethan Rosenberg, PhD
On 23 June 2013 21:37, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: On 6/23/2013 2:31 PM, Ethan Rosenberg, PhD wrote: Dear List - There is an error in my query, and I cannot find it. This fails: $_SESSION['Cust_Num'] =

Re: [PHP-DB] Problem wkith Query

2013-06-23 Thread Richard Quadling
Turn on error reporting/logging/displaying and what errors are you getting? And as you said ... $result10 = mysqli_query($cxn, $sql10); var_dump($result1); // this returns NULL is your actual code, maybe ... ?php $a = 'set variable a to this message'; var_dump($b); ? gives you a

Re: [PHP-DB] excec / query on Sqlite3

2013-05-20 Thread Matijn Woudt
On Mon, May 20, 2013 at 2:35 PM, Gilles g...@live.fr wrote: Hello, I'm not sure if it's a bug : $o_sqlite3=new SQLite3('test.sqlite'); $r=$o_sqlite3-exec(''); echo'pre';var_dump($r);echo'**/pre'; // bool(true) $r=$o_sqlite3-query(''); echo'pre';var_dump($r);echo'**/pre'; //

Re: [PHP-DB] Sorting a PHP array

2013-05-18 Thread Richard Quadling
I have an inline result set sorting function (array_multisort_by_columns() sort of thing) as array_multisort wants the data in columns for sorting. I can supply it if anyone wants it. On 16 May 2013 12:57, Jim Giner jim.gi...@albanyhandball.com wrote: On 5/15/2013 1:38 PM, Bastien wrote:

Re: [PHP-DB] Sorting a PHP array

2013-05-16 Thread Jim Giner
On 5/15/2013 1:38 PM, Bastien wrote: Bastien Koert On 2013-05-15, at 12:32 PM, Charlie Lewis charlie.le...@honest-it.com wrote: I have a bookseller database list read into a PHP array with dimensions [row][field]. There are 32 fields in each record/row and up to 500 records. What is the

Re: [PHP-DB] Sorting a PHP array

2013-05-15 Thread Matt Pelmear
I would use ORDER BY in your query and let the database do the work, assuming you're using a standard relational database (like MySQL or Postgresql). Otherwise, if you MUST do it in PHP, you could look at usort(), or uasort() using your own custom sorting function. I would, however,

Re: [PHP-DB] Sorting a PHP array

2013-05-15 Thread Bastien
Bastien Koert On 2013-05-15, at 12:32 PM, Charlie Lewis charlie.le...@honest-it.com wrote: I have a bookseller database list read into a PHP array with dimensions [row][field]. There are 32 fields in each record/row and up to 500 records. What is the neatest way to sort the array by

Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread David Robley
Ethan Rosenberg, PhD wrote: On 05/06/2013 12:48 AM, tamouse mailing lists wrote: On Sun, May 5, 2013 at 11:22 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I apologize if I offended some of you. I will see that it does not repeat. I am trying to center a

Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread Karl DeSaulniers
I would suggest googling your problem. In this case centering an HTML form. Hth, Best, Karl DeSaulniers Design Drumm http://designdrumm.com On May 6, 2013, at 12:00 AM, Ethan Rosenberg, PhD wrote: On 05/06/2013 12:48 AM, tamouse mailing lists wrote: On Sun, May 5, 2013 at 11:22 PM,

Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread Jim Giner
Centering a form is a simple process - as you stated about your first example form. So - obviously the problem is in all that other crap you presented to us, expecting us to do your debugging. I still don't know what you want to do - perhaps you could have given us a para on what it is

Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread Gu®u
Hi, Check if you have created a class in which you have already mentioned the font size. If that so look it and change it inside the class. Also, check if you have created or mentioned the font size in CSS. I hope this will help you. On Mon, May 6, 2013 at 6:30 PM, Jim Giner

Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread Ethan Rosenberg, PhD
On 05/06/2013 09:35 AM, OJFR wrote: Ethan, to center your form you just need to chance a little bit its structure as follows: div class=to_center/div div id=frm form name=poster method=post action= input type=text name=cnum hidden=hidden/input input

Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread Ethan Rosenberg, PhD
On 05/06/2013 02:03 AM, David Robley wrote: Ethan Rosenberg, PhD wrote: On 05/06/2013 12:48 AM, tamouse mailing lists wrote: On Sun, May 5, 2013 at 11:22 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I apologize if I offended some of you. I will see that it

Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread Ethan Rosenberg, PhD
On 05/06/2013 02:03 AM, David Robley wrote: Ethan Rosenberg, PhD wrote: On 05/06/2013 12:48 AM, tamouse mailing lists wrote: On Sun, May 5, 2013 at 11:22 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I apologize if I offended some of you. I will see that it

Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread Matt Pelmear
On 05/05/2013 10:00 PM, Ethan Rosenberg, PhD wrote: On 05/06/2013 12:48 AM, tamouse mailing lists wrote: What you're asking about has nothing to do with PHP. You want help with HTML and CSS, and front-end design. You are absolutely correct. I meant to label the post as HTML - Placing a

Re: [PHP-DB] Placing a form on a page

2013-05-05 Thread tamouse mailing lists
On Sun, May 5, 2013 at 11:22 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I apologize if I offended some of you. I will see that it does not repeat. I am trying to center a form on the top of a page. Here is the form: What you're asking about has nothing to do

Re: [PHP-DB] Placing a form on a page

2013-05-05 Thread Ethan Rosenberg, PhD
On 05/06/2013 12:48 AM, tamouse mailing lists wrote: On Sun, May 5, 2013 at 11:22 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I apologize if I offended some of you. I will see that it does not repeat. I am trying to center a form on the top of a page. Here is

Re: [PHP-DB] PDO Exceptions

2013-04-25 Thread Niel Archer
Greetings, I am new to this list. I have a question about which functions need to be included in a try block. Of new PDO, prepare, bindParam, execute, fetch, and query, it seems that bindParam is the only one that throws an exception. So is this the only that needs to be put into a

Re: [PHP-DB] PDO Exceptions

2013-04-25 Thread Jim Giner
On 4/25/2013 6:49 AM, Niel Archer wrote: Greetings, I am new to this list. I have a question about which functions need to be included in a try block. Of new PDO, prepare, bindParam, execute, fetch, and query, it seems that bindParam is the only one that throws an exception. So is this the

Re: [PHP-DB] Re: PDO Exceptions

2013-04-24 Thread Lars Nielsen
On 4/22/2013 11:55 AM, Onatawahtaw wrote: Greetings, I am new to this list. I have a question about which functions need to be included in a try block. Of new PDO, prepare, bindParam, execute, fetch, and query, it seems that bindParam is the only one that throws an exception. So is this

Re: [PHP-DB] Re: PDO Exceptions

2013-04-24 Thread Jim Giner
On 4/24/2013 9:43 AM, Lars Nielsen wrote: On 4/22/2013 11:55 AM, Onatawahtaw wrote: Greetings, I am new to this list. I have a question about which functions need to be included in a try block. Of new PDO, prepare, bindParam, execute, fetch, and query, it seems that bindParam is the only one

Re: [PHP-DB] Re: PDO Exceptions

2013-04-24 Thread Lars Nielsen
On 4/24/2013 9:43 AM, Lars Nielsen wrote: On 4/22/2013 11:55 AM, Onatawahtaw wrote: Greetings, I am new to this list. I have a question about which functions need to be included in a try block. Of new PDO, prepare, bindParam, execute, fetch, and query, it seems that bindParam is the only

Re: [PHP-DB] Re: PDO Exceptions

2013-04-24 Thread Jim Giner
On 4/24/2013 10:04 AM, Lars Nielsen wrote: On 4/24/2013 9:43 AM, Lars Nielsen wrote: On 4/22/2013 11:55 AM, Onatawahtaw wrote: Greetings, I am new to this list. I have a question about which functions need to be included in a try block. Of new PDO, prepare, bindParam, execute, fetch, and

Re: [PHP-DB] Probleme upper accents

2013-04-05 Thread Toby Hart Dyke
It looks similar to this bug: http://bugs.php.net/bug.php?id=54379 - possibly fixed in a later version? Your PHP is pretty elderly. Toby On 4/5/2013 1:38 PM, André LAGADEC wrote: Hi, On my application PHP with Oracle database, all work fine with Oracle9i client, but when I test with

Re: [PHP-DB] Probleme upper accents

2013-04-05 Thread Matijn Woudt
On Fri, Apr 5, 2013 at 3:19 PM, Toby Hart Dyke t...@hartdyke.com wrote: It looks similar to this bug: http://bugs.php.net/bug.php?**id=54379http://bugs.php.net/bug.php?id=54379- possibly fixed in a later version? Your PHP is pretty elderly. Toby I would suggest to upgrade the full

Re: [PHP-DB] Probleme upper accents

2013-04-05 Thread Christopher Jones
On 4/5/13 7:23 AM, Matijn Woudt wrote: On Fri, Apr 5, 2013 at 3:19 PM, Toby Hart Dyke t...@hartdyke.com wrote: It looks similar to this bug: http://bugs.php.net/bug.php?**id=54379http://bugs.php.net/bug.php?id=54379- possibly fixed in a later version? Your PHP is pretty elderly. Toby

Re: [PHP-DB] enabled PDO driver for MySQL and other database server

2013-04-01 Thread Dian Syarif Nasution
hi iccsi, make sure your configure file php.ini unmark the pdo_mysql On Mon, Apr 1, 2013 at 2:53 AM, iccsi inu...@gmail.com wrote: I tried to run PHP Report, Reporttico, and I got PDO Driver MySQL not found I do some research on Google learn that PHP deliver with PDO driver and tried to

RE: [PHP-DB] Undefined variables in update query

2013-03-27 Thread VanderHart, Robert
, Robert Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Undefined variables in update query On Tue, Mar 26, 2013 at 10:57 AM, VanderHart, Robert robert.vanderh...@umassmed.edu wrote: I appreciate the replies I've received already; thanks! Sorry for not catching my simple errors before sending out

Re: [PHP-DB] Undefined variables in update query

2013-03-26 Thread Přemysl
Hi, it appears to me that you have some strange input[name] attribute. instead of input type=\text\ name=\$row[department]\ value=\$row[department]\... try input type=\text\ name=department value=\$row[department]\... In php you are not initializing variables. That means $department

RE: [PHP-DB] Undefined variables in update query

2013-03-26 Thread VanderHart, Robert
...@umassmed.edu -Original Message- From: Přemysl [mailto:premysl.fi...@lim.cz] Sent: Tuesday, March 26, 2013 11:46 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Undefined variables in update query Hi, it appears to me that you have some strange input[name] attribute. instead of input type

Re: [PHP-DB] Undefined variables in update query

2013-03-26 Thread tamouse mailing lists
On Tue, Mar 26, 2013 at 10:57 AM, VanderHart, Robert robert.vanderh...@umassmed.edu wrote: I appreciate the replies I've received already; thanks! Sorry for not catching my simple errors before sending out that message. No worries, no one I have met yet begins life knowing this stuff! If

Re: [PHP-DB] Saving Image in mySQL

2013-03-20 Thread Gavin Chalkley
I am with Karl on this. Storing an image in the db is very heavy on lpad times. Upload the image to a folder with name saved with location On Mar 19, 2013 11:12 PM, Karl DeSaulniers k...@designdrumm.com wrote: Hey Ron, I don't know how others feel, but I say save yourself a headache and dont

Re: [PHP-DB] Saving Image in mySQL

2013-03-20 Thread Karl DeSaulniers
Ron, If your hell bent on storing the image data. :P I would say base64 the data and use a blob or text then read it out using something like.. $image = 'img src=data:'.$image_data.' /'; echo($image); I would also say your individual image max size should be 50k or less. If your storing product

Re: [PHP-DB] Saving Image in mySQL

2013-03-20 Thread Toby Hart Dyke
You're right - you're pulling $file out of thin air. Once uploaded, the file is stored in $_FILES['file']['tmp_name'], and you need to manually read the data into $file yourself. Something like: file_get_contents($_FILES['file']['tmp_name']) Toby On 3/19/2013 8:15 PM, Ron Piggott

Re: [PHP-DB] Saving Image in mySQL

2013-03-20 Thread Jim Giner
Absolutely - do not store any images in a db. Makes no sense. The data (the image) is static, basically safe from alteration or changing in any way, so what is the need? Save the location/name of the image only and store all of them in one (or more) secured folders on the server. No db

Re: [PHP-DB] Saving Image in mySQL

2013-03-20 Thread Jim Giner
On 3/20/2013 8:43 AM, Toby Hart Dyke wrote: You're right - you're pulling $file out of thin air. Once uploaded, the file is stored in $_FILES['file']['tmp_name'], and you need to manually read the data into $file yourself. Something like: file_get_contents($_FILES['file']['tmp_name'])

Re: [PHP-DB] Saving Image in mySQL

2013-03-19 Thread Karl DeSaulniers
Hey Ron, I don't know how others feel, but I say save yourself a headache and dont store the image data, just the url to the image on the server. image_url – VARCHAR 100 Best, Karl On Mar 19, 2013, at 3:15 PM, Ron Piggott wrote: Hi All I don’t understand how to save an image to a mySQL

Re: [PHP-DB] My Comments

2013-02-22 Thread Jim Giner
Ethan, I've spent several hours - at least 7-8 - working with you on this latest project. As you know it has morphed from one problem to another in the course of days. Yes - miscommunication on your part which you took responsibility for. That happens. I even had a whole new pair of

Re: [PHP-DB] Ajax

2013-02-21 Thread Jim Giner
On 2/21/2013 2:34 AM, Karl DeSaulniers wrote: Hi Ethan, With all due respect, I really wish I could help, but your structure of how your doing your html and php and javascript mix doesn't make sense enough for me to understand what it is your doing or how to help you. I copied and pasted your

Re: [PHP-DB] My Comments

2013-02-21 Thread Karl DeSaulniers
On Feb 21, 2013, at 3:08 PM, Ethan Rosenberg, PhD wrote: Dear List - Correction William N. Lipscomb, Jr. Ethan Dear List - I feel, and correct me if I am wrong, that a list as this or similar, should be devoted to help and not sarcasm. I try to be quiet and to not toot my

Re: [PHP-DB] My Comments

2013-02-21 Thread Matijn Woudt
On Thu, Feb 21, 2013 at 10:08 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I feel, and correct me if I am wrong, that a list as this or similar, should be devoted to help and not sarcasm. I try to be quiet and to not toot my horn, but as events have

Re: [PHP-DB] My Comments

2013-02-21 Thread Karl DeSaulniers
On Feb 21, 2013, at 3:08 PM, Ethan Rosenberg, PhD wrote: Dear List - Correction William N. Lipscomb, Jr. Ethan Dear List - I feel, and correct me if I am wrong, that a list as this or similar, should be devoted to help and not sarcasm. I try to be quiet and to not toot

Re: [PHP-DB] Re: AJAX/Javascript??

2013-02-11 Thread Michael Oki
Create a form and add a submit button that will run a php file. The SQL query in the php file will have something like SELECT custName FROM table WHERE lname='$lname'; This will come after you have retrieved the data from a form like this $lname = $_POST['lname']; On 10 February 2013 15:45, Jim

Re: [PHP-DB] Re: AJAX/Javascript??

2013-02-11 Thread Jim Giner
On 2/11/2013 10:08 AM, Michael Oki wrote: Create a form and add a submit button that will run a php file. The SQL query in the php file will have something like SELECT custName FROM table WHERE lname='$lname'; This will come after you have retrieved the data from a form like this $lname =

Re: [PHP-DB] Re: Processing Account Login

2013-02-07 Thread Karl DeSaulniers
Ron, got you covered.. ;) This is a good script to start from. May be exactly what you need to build yours around. Worked for me. You will have to study up on securing your info and make adjustments where needed. https://github.com/ivannovak/jpmaster77-s-Login-System- Best, Karl On Feb

Re: [PHP-DB] Query will not work - SOLVED

2013-02-02 Thread Karl DeSaulniers
$sql13 = UPDATE `Customers` SET `Lname` = 'Barnet', `City` = 'Lakewood', `State` = 'NJ' WHERE `Cust_Num` = 1089; $result13 = mysqli_query($cxn, $sql13); if(mysqli_num_rows($result13) 0) { $row_cnt = mysqli_num_rows($result13); echo row count result13 is $row_cntbr /; } else { echo Ouch

Re: [PHP-DB] Query will not work - SOLVED

2013-02-02 Thread tamouse mailing lists
On Sat, Feb 2, 2013 at 8:08 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: I must be missing something fundamental!! Yes. I was using the worker@localhost, which did not have the Update privilege. Added the privilege that, and everything worked. Please explain why you are

Re: [PHP-DB] pdo ?

2013-01-25 Thread Jim Giner
On 1/24/2013 7:07 PM, Matt Pelmear wrote: On 01/24/2013 04:02 PM, Jim Giner wrote: I took my 6 line override php.ini file and replicated (with a script) into all of my possible folders under my web root. NOt exactly an elegant solution, but with the script, easy to maintain. Honestly, you

Re: [PHP-DB] pdo ?

2013-01-25 Thread Jim Giner
On 1/25/2013 10:56 AM, Jim Giner wrote: On 1/24/2013 7:07 PM, Matt Pelmear wrote: On 01/24/2013 04:02 PM, Jim Giner wrote: I took my 6 line override php.ini file and replicated (with a script) into all of my possible folders under my web root. NOt exactly an elegant solution, but with the

Re: [PHP-DB] pdo ?

2013-01-24 Thread Matt Pelmear
http://stackoverflow.com/questions/5801951/does-php-auto-escapes-quotes-in-string-which-is-passed-by-get-or-post Every pro has this feature (magic_quotes_gpc) turned off. If you understand SQL Injection vulnerabilities, and properly bind things into your queries, I would recommend disabling

Re: [PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
On 1/24/2013 12:05 PM, Matt Pelmear wrote: http://stackoverflow.com/questions/5801951/does-php-auto-escapes-quotes-in-string-which-is-passed-by-get-or-post Every pro has this feature (magic_quotes_gpc) turned off. If you understand SQL Injection vulnerabilities, and properly bind things into

Re: [PHP-DB] pdo ?

2013-01-24 Thread Matt Pelmear
On 01/24/2013 09:23 AM, Jim Giner wrote: On 1/24/2013 12:05 PM, Matt Pelmear wrote: http://stackoverflow.com/questions/5801951/does-php-auto-escapes-quotes-in-string-which-is-passed-by-get-or-post Every pro has this feature (magic_quotes_gpc) turned off. If you understand SQL Injection

Re: [PHP-DB] pdo ?

2013-01-24 Thread Richard Quadling
On 24 January 2013 17:48, Matt Pelmear mjpelm...@gmail.com wrote: On 01/24/2013 09:23 AM, Jim Giner wrote: On 1/24/2013 12:05 PM, Matt Pelmear wrote: http://stackoverflow.com/questions/5801951/does-php-auto-escapes-quotes-in-string-which-is-passed-by-get-or-post Every pro has this feature

Re: [PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
On 1/24/2013 1:41 PM, Richard Quadling wrote: On 24 January 2013 17:48, Matt Pelmear mjpelm...@gmail.com wrote: On 01/24/2013 09:23 AM, Jim Giner wrote: On 1/24/2013 12:05 PM, Matt Pelmear wrote:

Re: [PHP-DB] pdo ?

2013-01-24 Thread Matt Pelmear
On 01/24/2013 12:00 PM, Jim Giner wrote: On 1/24/2013 1:41 PM, Richard Quadling wrote: On 24 January 2013 17:48, Matt Pelmear mjpelm...@gmail.com wrote: On 01/24/2013 09:23 AM, Jim Giner wrote: On 1/24/2013 12:05 PM, Matt Pelmear wrote:

Re: [PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
If you are using another web server or running PHP as FastCGI you may need to consider other options (changing the setting globally or doing a require_once() of your config changes?, or see the FastCGI example here: http://www.askapache.com/php/php-htaccess-tips-tricks.html) -Matt It sounds

Re: [PHP-DB] pdo ?

2013-01-24 Thread Karl DeSaulniers
On Jan 24, 2013, at 2:15 PM, Matt Pelmear wrote: On 01/24/2013 12:00 PM, Jim Giner wrote: On 1/24/2013 1:41 PM, Richard Quadling wrote: On 24 January 2013 17:48, Matt Pelmear mjpelm...@gmail.com wrote: On 01/24/2013 09:23 AM, Jim Giner wrote: On 1/24/2013 12:05 PM, Matt Pelmear wrote:

Re: [PHP-DB] pdo ?

2013-01-24 Thread Matt Pelmear
On 01/24/2013 01:37 PM, Karl DeSaulniers wrote: On Jan 24, 2013, at 2:15 PM, Matt Pelmear wrote: On 01/24/2013 12:00 PM, Jim Giner wrote: On 1/24/2013 1:41 PM, Richard Quadling wrote: On 24 January 2013 17:48, Matt Pelmear mjpelm...@gmail.com wrote: On 01/24/2013 09:23 AM, Jim Giner wrote:

Re: [PHP-DB] pdo ?

2013-01-24 Thread Matt Pelmear
On 01/24/2013 01:34 PM, Jim Giner wrote: If you are using another web server or running PHP as FastCGI you may need to consider other options (changing the setting globally or doing a require_once() of your config changes?, or see the FastCGI example here:

Re: [PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
On 1/24/2013 4:37 PM, Karl DeSaulniers wrote: On Jan 24, 2013, at 2:15 PM, Matt Pelmear wrote: On 01/24/2013 12:00 PM, Jim Giner wrote: On 1/24/2013 1:41 PM, Richard Quadling wrote: On 24 January 2013 17:48, Matt Pelmear mjpelm...@gmail.com wrote: On 01/24/2013 09:23 AM, Jim Giner wrote:

Re: [PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
On 1/24/2013 6:03 PM, Matt Pelmear wrote: On 01/24/2013 01:37 PM, Karl DeSaulniers wrote: On Jan 24, 2013, at 2:15 PM, Matt Pelmear wrote: On 01/24/2013 12:00 PM, Jim Giner wrote: On 1/24/2013 1:41 PM, Richard Quadling wrote: On 24 January 2013 17:48, Matt Pelmear mjpelm...@gmail.com

Re: [PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
On 1/24/2013 6:09 PM, Matt Pelmear wrote: On 01/24/2013 01:34 PM, Jim Giner wrote: If you are using another web server or running PHP as FastCGI you may need to consider other options (changing the setting globally or doing a require_once() of your config changes?, or see the FastCGI example

Re: [PHP-DB] pdo ?

2013-01-24 Thread Matt Pelmear
On 01/24/2013 04:02 PM, Jim Giner wrote: I took my 6 line override php.ini file and replicated (with a script) into all of my possible folders under my web root. NOt exactly an elegant solution, but with the script, easy to maintain. Honestly, you would be better off just putting those 6

Re: [PHP-DB] Firebird return wrong value

2013-01-18 Thread Lester Caine
vbe...@mail.com wrote: result: Array ( [0] = Array ( [COST] = -0.00 ) ) As a starting point ... can you look at the database using Flamerobin and check what it shows has been stored. I don't see anything wrong with what you have done except that 'cost' should perhaps be -1.0, so once we know

Re: [PHP-DB] Firebird return wrong value

2013-01-18 Thread Matijn Woudt
On Fri, Jan 18, 2013 at 12:49 PM, vbe...@mail.com wrote: Dear List! i have a strange problem. I have a Firebird database (dialect 3). Firebird server: 2.0.6 I create a table, and insert a row like that: CREATE TABLE PRICE ( ID INTEGER NOT NULL, NAME VARCHAR(10), COST NUMERIC(15,

Re: [PHP-DB] Firebird return wrong value

2013-01-18 Thread Berko Bubu
INSERT INTO PRICE (ID, NAME, COST) You should not use double quotes around column names. Try to use backtick operator instead: INSERT INTO `PRICE` (`ID`, `NAME`, `COST`) Don't know if that solves the problem, but it's atleast good practice. Second, do you really need firebird database?

Re: [PHP-DB] Firebird return wrong value

2013-01-18 Thread Lester Caine
Matijn Woudt wrote: Dear List! i have a strange problem. I have a Firebird database (dialect 3). Firebird server: 2.0.6 I create a table, and insert a row like that: CREATE TABLE PRICE ( ID INTEGER NOT NULL, NAME VARCHAR(10), COST NUMERIC(15, 2)); INSERT INTO PRICE (ID, NAME, COST)

Re: [PHP-DB] Firebird return wrong value

2013-01-18 Thread Lester Caine
Berko Bubu wrote: INSERT INTO PRICE (ID, NAME, COST) You should not use double quotes around column names. Try to use backtick operator instead: INSERT INTO `PRICE` (`ID`, `NAME`, `COST`) Don't know if that solves the problem, but it's atleast good practice. Second, do you really need

Re: [PHP-DB] SQL syntax

2013-01-15 Thread Amit Tandon
SELECT orderid FROM ORDERS_TABLE WHERE orderstatus IN ( 'Cancelled', 'New', 'Denied', 'Expired' , 'Failed' , 'Pending' , 'Refunded' , 'Reversed' , 'Under Review' , 'Voided') AND orderdate '.mysqli_real_escape_string($ yesterday); Another option would be to use

Re: [PHP-DB] SQL syntax

2013-01-15 Thread Karl DeSaulniers
On Jan 15, 2013, at 5:25 AM, Amit Tandon wrote: SELECT orderid FROM ORDERS_TABLE WHERE orderstatus IN ( 'Cancelled', 'New', 'Denied', 'Expired' , 'Failed' , 'Pending' , 'Refunded' , 'Reversed' , 'Under Review' , 'Voided') AND orderdate

Re: [PHP-DB] Re: SQL syntax

2013-01-15 Thread Karl DeSaulniers
On Jan 15, 2013, at 5:31 AM, David Robley wrote: Karl DeSaulniers wrote: Hello Everyone, Hope your 2013 is treating you well. Quick question and apologies if it is a stupid question. Is this a viable syntax? $sql = SELECT orderid FROM ORDERS_TABLE WHERE orderstatus = 'Cancelled' OR

Re: [PHP-DB] Re: SQL syntax

2013-01-15 Thread Bastien
Try It And See Bastien Koert On 2013-01-15, at 7:43 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Jan 15, 2013, at 5:31 AM, David Robley wrote: Karl DeSaulniers wrote: Hello Everyone, Hope your 2013 is treating you well. Quick question and apologies if it is a stupid question.

Re: [PHP-DB] Re: SQL syntax

2013-01-15 Thread Karl DeSaulniers
True, I guess it never hurts to try. Busy making orders and hadn't tested just yet. I just wanted a professional opinion on if the syntax was common to use, mostly. Didn't want to get a Jr PHP job and use it and have everyone looking at me sideways.. :P Thanks all, Best, Karl On Jan 15,

Re: [PHP-DB] PDO ?

2013-01-15 Thread Kapu®
On 15. 1. 2013 18:25, Jim Giner wrote: Doing some conversion - looking for a solution. Currently I do something like this: while (list($var1,$var2) = mysql_fetch_array($qrslts)) { handle the vars } Is there something in the PDO functions that emulates this same ability? Some of my uses

Re: [PHP-DB] Programs not running - Mystery SOLVED

2013-01-08 Thread tamouse mailing lists
On Tue, Jan 8, 2013 at 1:12 AM, Matt Pelmear mjpelm...@gmail.com wrote: I personally *never* set the error reporting level in the code, and during code reviews I reject code that does so. It is much cleaner to manage this in php.ini. I tend to agree -- settings like this are environment (dev,

Re: [PHP-DB] Netbeans

2013-01-08 Thread Bastien
Bastien Koert On 2013-01-08, at 1:00 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - Does anyone know how to set up Netbeans? I've tried and am unsuccessful. Thanks Ethan It's a simple installer for the OS you're running. Bastien -- PHP Database

Re: [PHP-DB] Error Checking

2013-01-08 Thread tamouse mailing lists
On Tue, Jan 8, 2013 at 11:54 AM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - 1] What function(s) do you use for error checking? 2] What are the settings for the parameter(s) in the functions? 3] Do you have different php.ini files for development and production?

Re: [PHP-DB] Programs not running

2013-01-07 Thread Karl DeSaulniers
On Jan 6, 2013, at 9:09 PM, tamouse mailing lists wrote: On Sun, Jan 6, 2013 at 2:14 PM, Karl DeSaulniers k...@designdrumm.com wrote: Unfortunately, I am still working on an old G4 Powerbook trying to finish a website of mine. Adobe GoLive was the program I imprinted on and it stuck. Sadly

Re: [PHP-DB] Preventing repetition of a Form

2013-01-07 Thread Karl DeSaulniers
On Jan 7, 2013, at 6:00 PM, Ethan Rosenberg, PhD wrote: Dear list - I have a program [*pseudo code*]: if(!isset($_REQUEST[welcome_already_seen])) { initialize variables } $errors_array = array(); if($_REQUEST[welcome_already_seen]==

Re: [PHP-DB] Programs not running

2013-01-07 Thread Matt Pelmear
On 01/06/2013 07:09 PM, tamouse mailing lists wrote: Actually, you might find netbeans just all that for writing the HTML, CSS and JS stuff, too. I used Dreamweaver when it first came out and compared to the other sorts of things available at the time, it was pretty spiffy. But time has

Re: [PHP-DB] Programs not running - Mystery SOLVED

2013-01-07 Thread Matt Pelmear
This is a *very* common problem, so don't feel too bad :-) I personally *never* set the error reporting level in the code, and during code reviews I reject code that does so. It is much cleaner to manage this in php.ini. Glad you solved your problem. -Matt On 01/07/2013 08:49 AM, Ethan

Re: [PHP-DB] Programs not running

2013-01-06 Thread tamouse mailing lists
On Sun, Jan 6, 2013 at 1:21 AM, Karl DeSaulniers k...@designdrumm.com wrote: I likey.. :) Thanks! Best, Karl On Jan 5, 2013, at 10:05 PM, Bastien wrote: Get net beans. It's free and a great IDE with debuggers and other stuff Bastien Koert netbeans is pretty awesome; I haven't used it

Re: [PHP-DB] Programs not running

2013-01-06 Thread Karl DeSaulniers
On Jan 6, 2013, at 4:55 AM, tamouse mailing lists wrote: On Sun, Jan 6, 2013 at 1:21 AM, Karl DeSaulniers k...@designdrumm.com wrote: I likey.. :) Thanks! Best, Karl On Jan 5, 2013, at 10:05 PM, Bastien wrote: Get net beans. It's free and a great IDE with debuggers and other stuff

RE: [PHP-DB] Programs not Running - SOLVED

2013-01-06 Thread Brad
Permissions? -Original Message- From: Ethan Rosenberg, PhD [mailto:erosenb...@hygeiabiomedical.com] Sent: Sunday, January 06, 2013 8:18 PM To: PHP Database List Subject: [PHP-DB] Programs not Running - SOLVED Dear List - Thanks to all for your help. The problem was in this piece of

Re: [PHP-DB] Programs not running

2013-01-06 Thread tamouse mailing lists
On Sun, Jan 6, 2013 at 2:14 PM, Karl DeSaulniers k...@designdrumm.com wrote: Unfortunately, I am still working on an old G4 Powerbook trying to finish a website of mine. Adobe GoLive was the program I imprinted on and it stuck. Sadly it has gone away now and Dreamweaver is the replacement. I

Re: [PHP-DB] Re: Programs not Running - SOLVED

2013-01-06 Thread tamouse mailing lists
On Sun, Jan 6, 2013 at 6:32 PM, Jim Giner jim.gi...@albanyhandball.com wrote: On 1/6/2013 7:17 PM, Ethan Rosenberg, PhD wrote: The problem was in this piece of code: require '/var/www/pass.inc'; $db = Store; $cxn = mysqli_connect($host,$user,$password,$db);

Re: [PHP-DB] Programs not running

2013-01-05 Thread tamouse mailing lists
On Sat, Jan 5, 2013 at 12:48 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Jan 4, 2013, at 8:00 PM, tamouse mailing lists wrote: On Fri, Jan 4, 2013 at 6:09 PM, Matt Pelmear mjpelm...@gmail.com wrote: On 01/04/2013 01:40 PM, tamouse mailing lists wrote: One should be able to solve

Re: [PHP-DB] Programs not running

2013-01-05 Thread Karl DeSaulniers
On Jan 5, 2013, at 8:52 AM, tamouse mailing lists wrote: On Sat, Jan 5, 2013 at 12:48 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Jan 4, 2013, at 8:00 PM, tamouse mailing lists wrote: On Fri, Jan 4, 2013 at 6:09 PM, Matt Pelmear mjpelm...@gmail.com wrote: On 01/04/2013 01:40 PM,

Re: [PHP-DB] Programs not running

2013-01-05 Thread Karl DeSaulniers
I likey.. :) Thanks! Best, Karl On Jan 5, 2013, at 10:05 PM, Bastien wrote: Get net beans. It's free and a great IDE with debuggers and other stuff Bastien Koert On 2013-01-05, at 7:14 PM, Karl DeSaulniers k...@designdrumm.com wrote: On Jan 5, 2013, at 8:52 AM, tamouse mailing

Re: [PHP-DB] Programs not running

2013-01-04 Thread Jim Giner
On 01/03/2013 08:54 PM, Ethan Rosenberg, PhD wrote: = I can't answer because I do not understand. ?php phpinfo(); ? gives the correct output. Ethan - whatever do you mean the phpinfo gives the correct output? Do you mean that you compared every line and found them to match

Re: [PHP-DB] Programs not running

2013-01-04 Thread Jim Giner
Is the failing one a .php file? jg On Jan 3, 2013, at 11:54 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: On 01/03/2013 10:14 PM, Matt Pelmear wrote: In addition to Jim's comments, Have you checked to see whether the permissions on all files are appropriate on

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