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 =

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

2013-02-10 Thread Jim Giner
On 2/9/2013 10:51 PM, Ethan Rosenberg, PhD wrote: I know that this might be an Ajax/Javascript question. Hopefully you can help. I do not know of any other source for good info. I would like to be able to click on one field in a table, and retrieve the data in another field. Here is the

[PHP-DB] AJAX/Javascript??

2013-02-09 Thread Ethan Rosenberg, PhD
I know that this might be an Ajax/Javascript question. Hopefully you can help. I do not know of any other source for good info. I would like to be able to click on one field in a table, and retrieve the data in another field. Here is the information: The table is:

[PHP-DB] Re: Processing Account Login

2013-02-07 Thread Jim Giner
On 2/6/2013 8:01 PM, Ron Piggott wrote: Hi Everyone When I login to PayPal a total of 3 web pages are used: 1 – A screen for the user to type in their user name password 2 – A screen saying “ Logging in “* 3 – My Welcome / Personalized Account Summary Screen * During the 2nd web page my PHP

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

[PHP-DB] Processing Account Login

2013-02-06 Thread Ron Piggott
Hi Everyone When I login to PayPal a total of 3 web pages are used: 1 – A screen for the user to type in their user name password 2 – A screen saying “ Logging in “* 3 – My Welcome / Personalized Account Summary Screen * During the 2nd web page my PHP script is going to be accessing the mySQL

[PHP-DB] Re: Processing Account Login

2013-02-06 Thread David Robley
Ron Piggott wrote: Hi Everyone When I login to PayPal a total of 3 web pages are used: 1 ? A screen for the user to type in their user name password 2 ? A screen saying ? Logging in ?* 3 ? My Welcome / Personalized Account Summary Screen * During the 2nd web page my PHP script is

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

2013-02-03 Thread David Robley
Ethan Rosenberg, PhD wrote: What am I doing wrong?? Not checking the errors that mysql returns? -- Cheers David Robley Tennis in the Bible: Moses served in Pharaoh's court... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Query will not work - SOLVED

2013-02-02 Thread Ethan Rosenberg, PhD
I must be missing something fundamental!! Here is a code snippet: $sql13 = UPDATE Customers SET Lname = 'Barnet', City = 'Lakewood', State = 'NJ' WHERE Cust_Num = 1089; $result13 = mysqli_query($cxn, UPDATE Customers SET Lname = 'Bleich', City = 'Lakewood', State = 'NJ' WHERE Cust_Num

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

[PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
ok - new to using pdo functions, but I thought I had a handle on it. I'm writing out to my page an input tag with the following value in it: 49'ers I can confirm it by using my browser's view source to see that is exactly how it exists in the page. When I hit a submit button and my script

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

[PHP-DB] Firebird return wrong value

2013-01-18 Thread vberko
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) VALUES (2, 'my price2',

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

[PHP-DB] SQL syntax

2013-01-15 Thread Karl DeSaulniers
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 (orderstatus = ('New' OR 'Denied' OR 'Expired' OR 'Failed'

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

[PHP-DB] Re: SQL syntax

2013-01-15 Thread David Robley
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 (orderstatus = ('New' OR 'Denied' OR 'Expired' OR

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,

[PHP-DB] PDO ?

2013-01-15 Thread Jim Giner
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 of the sql syntax have many more vars

[PHP-DB] Re: SQL syntax

2013-01-15 Thread Frank Flynn
Or is there a better way to check multiple options against an enum inside your select statement? IN for example: orderstatus IN ( 'Cancelled', 'New', 'Denied', 'Expired') However this is not exactly what you are doing. You want different orderdate $yesterday depending on the orderstatus.

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

[PHP-DB] Re: PDO ?

2013-01-15 Thread Jim Giner
Never Mind A little careful re-reading of the docs told me what I was doing wrong. I always use PDO::FETCH_ASSOC in my fetch statements. Discovered that I have to have numerical array results in order to utilize the List command. Voila! -- PHP Database Mailing List

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,

[PHP-DB] Error Checking

2013-01-08 Thread Ethan Rosenberg, PhD
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? Thank you. Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Netbeans

2013-01-08 Thread Ethan Rosenberg, PhD
Dear List - Does anyone know how to set up Netbeans? I've tried and am unsuccessful. Thanks Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

[PHP-DB] Programs not running - Mystery SOLVED

2013-01-07 Thread Ethan Rosenberg, PhD
Dear list - Boy, Do I make STUPID MISTAKES! The show_errors was turned off in the program in question!! When I ran another program, that displayed errors, is threw the correct error message. My apologies for running everyone around numerous trees. Ethan -- PHP Database Mailing List

[PHP-DB] Another Apology

2013-01-07 Thread Ethan Rosenberg, PhD
Dear list - My humble apologies for listing my complete signature. It is pretentious and should not have happened! The eml is coming from my business account [my home computer is down]. The PhD is in chemistry, not computer science. When I communicate with other scientists I have no

[PHP-DB] Preventing repetition of a Form

2013-01-07 Thread Ethan Rosenberg, PhD
Dear list - I have a program [*pseudo code*]: if(!isset($_REQUEST[welcome_already_seen])) { initialize variables } $errors_array = array(); if($_REQUEST[welcome_already_seen]== already_seen) { check_data();

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]==

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

2013-01-07 Thread Jim Giner
On 1/7/2013 7: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

[PHP-DB] Programs not Running - SOLVED

2013-01-06 Thread Ethan Rosenberg, PhD
Dear List - Thanks to all for your help. The problem was in this piece of code: require '/var/www/pass.inc'; $db = Store; $cxn = mysqli_connect($host,$user,$password,$db); if ( !$cxn ) { die( 'connect error: '.mysqli_connect_error() ); } I

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

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

2013-01-06 Thread Jim Giner
On 1/6/2013 7:17 PM, Ethan Rosenberg, PhD wrote: Dear List - Thanks to all for your help. The problem was in this piece of code: require '/var/www/pass.inc'; $db = Store; $cxn = mysqli_connect($host,$user,$password,$db); if ( !$cxn ) { die(

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

Re: [PHP-DB] Programs not running

2013-01-04 Thread tamouse mailing lists
On Fri, Jan 4, 2013 at 12:37 AM, Matt Pelmear mjpelm...@gmail.com wrote: In my experience, the problem you are experiencing is caused by one of two issues: 1) A major parsing problem (sometimes no error is displayed-- you just get no output.) One should be able to solve parsing problems

Re: [PHP-DB] Programs not running

2013-01-04 Thread Matt Pelmear
On 01/04/2013 01:40 PM, tamouse mailing lists wrote: One should be able to solve parsing problems without resorting to using a web server. Every time I save a php file, I have my editor set to run it through php -l. Saves lots of angst when I get to the web testing stage. This is a good

Re: [PHP-DB] Programs not running

2013-01-04 Thread tamouse mailing lists
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 parsing problems without resorting to using a web server. Every time I save a php file, I have my editor set to run it through php -l. Saves

Re: [PHP-DB] Programs not running

2013-01-04 Thread Matt Pelmear
On 01/04/2013 06: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 parsing problems without resorting to using a web server. Every time I save a php file,

Re: [PHP-DB] Programs not running

2013-01-04 Thread Karl DeSaulniers
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 parsing problems without resorting to using a web server. Every time I save a

[PHP-DB] Programs not running

2013-01-03 Thread Ethan Rosenberg, PhD
Dear List - I am running sid on my Lenovo desktop and squeeze on my Dell laptop. The php.ini files are the same. The programs are the same except foro the locatioln of the password file and of a file to be read for parameters. The programs run beautifully on the desktop, but refuse to run

[PHP-DB] Re: Programs not running

2013-01-03 Thread Jim Giner
On 1/3/2013 7:35 PM, Ethan Rosenberg, PhD wrote: Dear List - I am running sid on my Lenovo desktop and squeeze on my Dell laptop. The php.ini files are the same. The programs are the same except foro the locatioln of the password file and of a file to be read for parameters. The programs run

Re: [PHP-DB] Programs not running

2013-01-03 Thread Matt Pelmear
In addition to Jim's comments, Have you checked to see whether the permissions on all files are appropriate on the environment where this doesn't work? Are you running this in a web environment or CLI? If web, are you 100% sure the web server configuration is correct? -Matt On 01/03/2013

Re: [PHP-DB] Programs not running

2013-01-03 Thread Matt Pelmear
Ethan, I'm not sure this conversation is appropriate for this mailing list. This question has probably been answered 1000 times on the general php list. In my experience, the problem you are experiencing is caused by one of two issues: 1) A major parsing problem (sometimes no error is

[PHP-DB] mysqldump

2013-01-01 Thread Ethan Rosenberg, PhD
Dear List - I am using the following command: mysqldump -u root -p Store StoreBkup.sql; to backup the database called Store. Mysql insists on giving a syntax error. Advice and help, please. Thanks. Ethan -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] mysqldump

2013-01-01 Thread Matijn Woudt
On Wed, Jan 2, 2013 at 12:50 AM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I am using the following command: mysqldump -u root -p Store StoreBkup.sql; to backup the database called Store. Mysql insists on giving a syntax error. Advice and help, please.

[PHP-DB] Re: mysqldump

2013-01-01 Thread Frank Flynn
mysqldump is a separate program (it runs outside of the mysql shell). I noticed you have ; at the end and perhaps you are trying to run it inside MySQL client. The ; by itself is not a problem for the OS shell (bash or whatever) but you don't need it unless you are running multiple commands

[PHP-DB] Shopping Cart Discount System

2012-12-31 Thread Karl DeSaulniers
Hello Everyone, Hope all are well. Quick and hopefully painless question. Is there any examples on how to build a discount system into your shopping cart out there that anyone knows of? I am using MySQL and PHP. I have built one of my own so far, but am having trouble making sense of what goes

[PHP-DB] Re: [PHP] Shopping Cart Discount System

2012-12-31 Thread Ashley Sheridan
Karl DeSaulniers k...@designdrumm.com wrote: Hello Everyone, Hope all are well. Quick and hopefully painless question. Is there any examples on how to build a discount system into your shopping cart out there that anyone knows of? I am using MySQL and PHP. I have built one of my own so far, but

[PHP-DB] Re: [PHP] Shopping Cart Discount System

2012-12-31 Thread tamouse mailing lists
On Mon, Dec 31, 2012 at 2:31 AM, Karl DeSaulniers k...@designdrumm.com wrote: Hello Everyone, Hope all are well. Quick and hopefully painless question. Is there any examples on how to build a discount system into your shopping cart out there that anyone knows of? I am using MySQL and PHP. I

Re: [PHP-DB] Re: [PHP] Shopping Cart Discount System

2012-12-31 Thread Karl DeSaulniers
On Dec 31, 2012, at 3:36 AM, Ashley Sheridan wrote: Karl DeSaulniers k...@designdrumm.com wrote: Hello Everyone, Hope all are well. Quick and hopefully painless question. Is there any examples on how to build a discount system into your shopping cart out there that anyone knows of? I am

[PHP-DB] Re: [PHP] Shopping Cart Discount System

2012-12-31 Thread Karl DeSaulniers
On Dec 31, 2012, at 3:51 PM, tamouse mailing lists wrote: On Mon, Dec 31, 2012 at 2:31 AM, Karl DeSaulniers k...@designdrumm.com wrote: Hello Everyone, Hope all are well. Quick and hopefully painless question. Is there any examples on how to build a discount system into your shopping cart

[PHP-DB] Prepared Statements - Search

2012-12-03 Thread Ethan Rosenberg, PhD
Dear List - I am trying to use prepared statements with the following code: $allowed_fields = array ('Cust_Num' = 'i', 'Fname' = 's', 'Lname' = 's', 'Street' = 's','City'= 's', 'State' = 's', 'Zip' = 'i', 'Phone' = 'i', 'Notes' =

[PHP-DB] Re: Prepared Statements - Search

2012-12-03 Thread Jim Giner
On 12/3/2012 2:30 PM, Ethan Rosenberg, PhD wrote: Dear List - I am trying to use prepared statements with the following code: $allowed_fields = array ('Cust_Num' = 'i', 'Fname' = 's', 'Lname' = 's', 'Street' = 's','City'= 's', 'State' = 's', 'Zip' =

[PHP-DB] Re: Prepared Statements - Search

2012-12-03 Thread Jim Giner
On 12/3/2012 2:30 PM, Ethan Rosenberg, PhD wrote: Dear List - I am trying to use prepared statements with the following code: $allowed_fields = array ('Cust_Num' = 'i', 'Fname' = 's', 'Lname' = 's', 'Street' = 's','City'= 's', 'State' = 's', 'Zip' =

Re: [PHP-DB] Re: Prepared Statements - Search

2012-12-03 Thread tamouse mailing lists
On Mon, Dec 3, 2012 at 3:34 PM, Jim Giner jim.gi...@albanyhandball.com wrote: On 12/3/2012 2:30 PM, Ethan Rosenberg, PhD wrote: $stmt = mysqli_stmt_init($cxn); mysqli_stmt_prepare( $stmt, $sql12 ); The search fails. So, you got us down to where you prepare

[PHP-DB] Gnome Desktop Button

2012-11-27 Thread Ethan Rosenberg, PhD
Dear list - Maybe this fell thru the cracks, so here it is again. Is there a way to have a button in the tray that will minimize all the windows and show the desktop? Thanks. Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Gnome Desktop Button

2012-11-27 Thread Daniel Brown
On Tue, Nov 27, 2012 at 5:31 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear list - Maybe this fell thru the cracks, so here it is again. Is there a way to have a button in the tray that will minimize all the windows and show the desktop? Well, it's neither a

Re: [PHP-DB] Re: Formatting

2012-11-26 Thread Karl DeSaulniers
Ethan, is this valid PHP? What is the ampersand for? What is it doing? Just curious. $args[] = $_POST[$k]; // Note the addition of the ampersand here Karl On Nov 26, 2012, at 12:14 AM, Matt Pelmear wrote: FYI, this really is not the appropriate mailing list for these types of questions.

RE: [PHP-DB] Re: Formatting

2012-11-26 Thread Ford, Mike
-Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: 26 November 2012 08:48 To: php-db@lists.php.net Subject: Re: [PHP-DB] Re: Formatting Ethan, is this valid PHP? What is the ampersand for? What is it doing? Just curious. $args[] = $_POST[$k]; // Note

[PHP-DB] Formatting - Solved

2012-11-26 Thread Ethan Rosenberg, PhD
Dear list Here is the answer ORIGINAL centerbSearch Results/b/centerbr / center !-- This is the block that prints about one screen full down bellow the Search Results header -- table border=4 cellpadding=5 cellspacing=55 rules=all frame=box style=table-layout: fixed; tr

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