[PHP-DB] Re: mysql query

2013-08-22 Thread Jim Giner
On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+

[PHP-DB] Re: mysql query

2013-08-22 Thread Jim Giner
On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+

[PHP-DB] Re: mysql query

2013-08-22 Thread Jim Giner
On 8/22/2013 9:52 AM, Jim Giner wrote: On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra |

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Vinay Kannan
Jim, I know this is a stupid question to be asking this far into PHP Development, maybe was a bit lazy, or just got too used to Notepad++, which editor for PHP are you using? The feature which you mentioned for a good php editor, sounds exciting, offcourse i would be looking only at the free ones

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Toby Hart Dyke
Notepad++ will do syntax highlighting. Go to Language P PHP with a PHP file open, and see the colours change! It should be automatic - are you using something other than 'php' as a file extension? Toby On 8/22/2013 5:27 PM, Vinay Kannan wrote: Jim, I know this is a stupid question to

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Vinay Kannan
Thanks Toby, Using Notepad ++ with the language selected to PHP, the syntax coloring is on On Thu, Aug 22, 2013 at 11:00 PM, Toby Hart Dyke t...@hartdyke.com wrote: Notepad++ will do syntax highlighting. Go to Language P PHP with a PHP file open, and see the colours change! It should

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Lester Caine
Vinay Kannan wrote: Jim, I know this is a stupid question to be asking this far into PHP Development, maybe was a bit lazy, or just got too used to Notepad++, which editor for PHP are you using? The feature which you mentioned for a good php editor, sounds exciting, offcourse i would be looking

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Ethan Rosenberg, PhD
On 08/22/2013 09:51 AM, Jim Giner wrote: On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra |

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Ethan Rosenberg
On 08/22/2013 11:54 AM, Jim Giner wrote: On 8/22/2013 9:52 AM, Jim Giner wrote: On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Ethan Rosenberg
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 wrote: On 08/22/2013 11:54 AM, Jim Giner wrote:

[PHP-DB] Bluefish for PHP

2013-08-22 Thread Ethan Rosenberg
Dear List - How do I configure Bluefish for PHP? I am running version 2.2.4 of Bluefish. TIA Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql query

2013-08-21 Thread Ethan Rosenberg
Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | UPC | varchar(14) | YES | |

Re: [PHP-DB] mysql query

2013-08-21 Thread Toby Hart Dyke
1) What is the error message? 2) This has an error: values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk) Missing '$' in front of 'odrpt'. Toby On 8/22/2013 12:48 AM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory;

Re: [PHP-DB] mysql query

2013-08-21 Thread Ethan Rosenberg
On 08/21/2013 07:52 PM, Toby Hart Dyke wrote: 1) What is the error message? 2) This has an error: values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk) Missing '$' in front of 'odrpt'. Toby On 8/22/2013 12:48 AM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql

Re: [PHP-DB] mysql query

2013-08-21 Thread Daniel Krook
Ethan, It's hard to tell from the code formatting in your email what the exact problem might be, but a few reasons that this might fail in PHP rather than when sent to MySQL with hardcoded values: 1. var_dump/print_r $_POST to see what you're getting as input is what you expect (and

Re: [PHP-DB] mysql query

2013-08-21 Thread Daniel Krook
Ethan, What about: $result2 = mysqli_query(cxn, $sql2); Doesn't look like you're sending it a connection link as a variable ($cxn) and that's passed through as a literal? Thanks, Daniel Krook Software Engineer, Advanced Cloud Solutions, GTS IBM Senior Certified IT Specialist - L3

[PHP-DB] chmod

2013-08-19 Thread Emiliano Boragina
Hello everyone, I try to use chmod 0777, but the JPG file in my localhost I cant view. I must enter in the windows properties of the JPG file, add the user with full permission, and them i can view it. I use this: move_uploaded_file($file_tmp,$desired_dir/.$file_name);

Re: [PHP-DB] chmod

2013-08-19 Thread Matt Pelmear
Emiliano, This question is totally out of scope for this mailing list. It has nothing to do with databases at all. Also, you should _almost never_ use 0777 for permissions. You probably want 0644. (Owner can read/write, all others can read.) Regarding your question in general, it sounds like

[PHP-DB] PHP 5.3 and mariadb 5.5.32 pam auth problem.

2013-08-16 Thread Rafał Radecki
Hi All. I have: - one devel application server with php53-mysql-5.3.27-1 MariaDB-compat-5.5.32-1.x86_64 MariaDB-common-5.5.32-1.x86_64 MariaDB-shared-5.5.32-1.x86_64 MariaDB-client-5.5.32-1.x86_64 - one devel database server with MariaDB-compat-5.5.30-1.x86_64 MariaDB-server-5.5.30-1.x86_64

Re: [PHP-DB] Re: One query, different tables?

2013-08-10 Thread Jorge
As someone else say, is problem of DB design, probably you can do all the necessary queries in only one transaction. Un saludo, Jorge. 2013/8/9 Karl DeSaulniers k...@designdrumm.com Probably with separate queries I would say. Query store 1, move to truck then query truck and move to store 2.

[PHP-DB] One query, different tables?

2013-08-09 Thread Karl-Arne Gjersøyen
Hello. I am newbie in this and need som basic help. I have a form witch checkbox'es with different serialnumbers. The serialnumbers reflect different products and every product category have their own tables. I can transfer items from store to truck but can't transfer them back to store. I have

[PHP-DB] Re: One query, different tables?

2013-08-09 Thread Jim Giner
On 8/9/2013 10:56 AM, Karl-Arne Gjersøyen wrote: Hello. I am newbie in this and need som basic help. I have a form witch checkbox'es with different serialnumbers. The serialnumbers reflect different products and every product category have their own tables. I can transfer items from store to

Re: [PHP-DB] One query, different tables?

2013-08-09 Thread Niel Archer
Hello. I am newbie in this and need som basic help. I have a form witch checkbox'es with different serialnumbers. The serialnumbers reflect different products and every product category have their own tables. This sounds like a database design question more than a PHP one. I can

Re: [PHP-DB] One query, different tables?

2013-08-09 Thread Bastien Koert
Why do you have to tables with products? Couldn't you have a type or category column and then have to only query one table? Bastien On Fri, Aug 9, 2013 at 11:52 AM, Niel Archer n...@chance.now wrote: Hello. I am newbie in this and need som basic help. I have a form witch checkbox'es

Re: [PHP-DB] Re: One query, different tables?

2013-08-09 Thread Karl DeSaulniers
Probably with separate queries I would say. Query store 1, move to truck then query truck and move to store 2. Best, Karl Sent from losPhone On Aug 9, 2013, at 10:13 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 8/9/2013 10:56 AM, Karl-Arne Gjersøyen wrote: Hello. I am newbie in

Re: [PHP-DB] I'm So Confused . . .

2013-07-09 Thread Kris
Hi, Andrew! On Mon, 8 Jul 2013 11:17:14 -0400, andrew.jar...@gmail.com (Andrew Jarcho) wrote: 1) You're not stupid Let's hope. :-D 2) You're not too old to accomplish what you want to accomplish. A couple of good books (preferably fairly short ones) by people who know what they're talking

[PHP-DB] I'm So Confused . . .

2013-07-08 Thread Kris
All of my PHP/MySQL stuff was done years ago, and I used good practices at the time. Things have changed, and it's past time to get up to speed on mysqli, PDO, sessions, etc. All my projects to date have been private, hobby things that outsiders didn't have access to. That's about to change --

Re: [PHP-DB] I'm So Confused . . .

2013-07-08 Thread Andrew Jarcho
1) You're not stupid 2) You're not too old to accomplish what you want to accomplish. A couple of good books (preferably fairly short ones) by people who know what they're talking about *and* know how to write should help a great deal. Like you, I cut my programming teeth in BASIC stored on

[PHP-DB] oncurrence problem with PEAR:MDB2 + msqli driver in forked CLI environment

2013-07-04 Thread Toni Moreno
Hi. I have a found a very strange and big concurrence problem after develop a CLI tool which parallelizes data processing by using pcntrl_fork, ( If we run the same executions sequentially the result is correct) The trouble appears when some of the child processes die while trying to access

Re: [PHP-DB] oncurrence problem with PEAR:MDB2 + msqli driver in forked CLI environment

2013-07-04 Thread Matijn Woudt
On Thu, Jul 4, 2013 at 6:09 PM, Toni Moreno toni.mor...@gmail.com wrote: Hi. I have a found a very strange and big concurrence problem after develop a CLI tool which parallelizes data processing by using pcntrl_fork, ( If we run the same executions sequentially the result is correct)

Re: [PHP-DB] Mysql PDO statement with params in HAVING problem

2013-06-28 Thread Tamara Temple
Alexander Pletnev pletnev.rusa...@gmail.com wrote: Hi everyone, im new here, so please correct me if i created or formated topic incorrectly. I found a problem. I have a simple query for my needs: $stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as full_name,t.* FROM

[PHP-DB] Mysql PDO statement with params in HAVING problem

2013-06-27 Thread Alexander Pletnev
Hi everyone, im new here, so please correct me if i created or formated topic incorrectly. I found a problem. I have a simple query for my needs: $stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as full_name,t.* FROM `specialists` `t` HAVING full_name like '%john%');

Re: [PHP-DB] Mysql PDO statement with params in HAVING problem

2013-06-27 Thread Vinay Kannan
$stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as full_name,t.* FROM `specialists` `t` HAVING full_name like '%:query%'); How about '%:$query%' instead of '%:query%' ? Does that solve the problem? Thanks, On Thu, Jun 27, 2013 at 5:21 PM, Alexander Pletnev

[PHP-DB] Re: Mysql PDO statement with params in HAVING problem

2013-06-27 Thread Jim Giner
On 6/27/2013 7:51 AM, Alexander Pletnev wrote: Hi everyone, im new here, so please correct me if i created or formated topic incorrectly. I found a problem. I have a simple query for my needs: $stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as full_name,t.* FROM

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

[PHP-DB] Problem with query

2013-06-23 Thread Ethan Rosenberg, PhD
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 the proper values print_r($_SESSION); $sql10 = select Balance, Payments, Charges, Date from Charges

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

[PHP-DB] Re: Problem with query

2013-06-23 Thread Jim Giner
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'] = $_REQUEST['cnum']; echo sessionbr /; //this has the proper values print_r($_SESSION); $sql10 =

[PHP-DB] Re: Problem with query

2013-06-23 Thread Ethan Rosenberg, PhD
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'] = $_REQUEST['cnum']; echo sessionbr /; //this has the proper values print_r($_SESSION); $sql10 =

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

[PHP-DB] Wanted : Solid/documented/tests Nested Set Model class for mySQL.

2013-06-06 Thread Richard Quadling
Hi. I'm looking for a class that implements nested sets, ideally using ZF (1 or 2) or PEAR, or, if standalone, clear enough documentation. My data is essentially social referral and will be nested very deep, so this would seem to be a perfect match for this sort of work, but I'm being a little

[PHP-DB] excec / query on Sqlite3

2013-05-20 Thread Gilles
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'; // bool(false) $r=$o_sqlite3-exec(false); echo'pre';var_dump($r);echo'/pre'; //

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'; //

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

2013-05-20 Thread B. Aerts
On 20/05/13 14:35, Gilles wrote: Hello, I'm not sure if it's a bug : No, it's not - it's PHP code :-) $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

[PHP-DB] Sorting a PHP array

2013-05-15 Thread Charlie Lewis
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 any of the fields, such as author or title? I know I should just search for a manual on this, but

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,

[PHP-DB] Re: Sorting a PHP array

2013-05-15 Thread Jim Giner
On 5/15/2013 12:32 PM, Charlie Lewis 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 any of the fields, such as author or title? I know I

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

[PHP-DB] Placing a form on a page

2013-05-05 Thread Ethan Rosenberg, PhD
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: div id=frm form name=poster method=post action= input type=text name=cnum hidden=hidden /input input type='hidden'

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

[PHP-DB] Re: PDO Exceptions

2013-04-24 Thread Jim Giner
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 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

[PHP-DB] PDO Exceptions

2013-04-22 Thread Onatawahtaw
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 try

[PHP-DB] Probleme upper accents

2013-04-05 Thread André LAGADEC
Hi, On my application PHP with Oracle database, all work fine with Oracle9i client, but when I test with Oracle11gR2 client I get warning with PDO driver. *Warning*: PDOStatement::fetch() [function.PDOStatement-fetch http://vanves23/function.PDOStatement-fetch]: column 0 data was too large

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

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

2013-03-31 Thread iccsi
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 enable it using IIS, but I could not make it work. I would like to know how to enable PDO driver for the database servers. I use Windows

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

2013-03-27 Thread VanderHart, Robert
Many thanks for this great advice! Definitely worth keeping and putting into practice! Any way to write cleaner and more concise code is always worth learning. Best regards, Robert -- Robert J. Vander Hart Electronic Resources Librarian | Lamar Soutter Library University of Massachusetts

[PHP-DB] Undefined variables in update query

2013-03-26 Thread VanderHart, Robert
Hi, I'm pretty new to PHP and to this discussion list. I have a web form to update some fields in a data table. I'm getting undefined variable notices in my error logs when I submit the form and the table row doesn't get updated. Here's the code for the form page: ?php include

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

2013-03-26 Thread Jim Giner
On 3/26/2013 11:19 AM, VanderHart, Robert wrote: Hi, I'm pretty new to PHP and to this discussion list. I have a web form to update some fields in a data table. I'm getting undefined variable notices in my error logs when I submit the form and the table row doesn't get updated. Here's the

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
Premek, Thanks for the reply. I actually found that silly mistake after I sent out my message. You're absolutely right that I need to hardcode the field name into the input name attribute. Even a newbie like me should have realized that one; even though I'm new to PHP I've used other

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'])

[PHP-DB] Saving Image in mySQL

2013-03-19 Thread Ron Piggott
Hi All I don’t understand how to save an image to a mySQL table based on the following form. I am trying to do this using Prepared Statements. All the fields except the image file itself save in the database. Right now I have $file as the variable when binding the values. What should it be?

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

[PHP-DB] Probleme accents

2013-03-03 Thread ANDRE LAGADEC
Hi, On my application PHP with Oracle database, all work fine but sometimes the caracters like 'éèàù' become 'eau' or '?', and after make apachectl stop/start it become normal. Here are my configuration : - Apache2.2.21 - Php-5.2.13 with PDO Oracle - Client Oracle 11.2.0.1 - Base

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

[PHP-DB] My Comments

2013-02-21 Thread Ethan Rosenberg, PhD
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 horn, but as events have progressed, I feel I must. As you

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