Re: [PHP-DB] Re: PHP 7 and sqlsrv

2015-04-11 Thread Şəhriyar İmanov
Php 6 was cancelled back 2009 or 2011... Language i18n failed. On Apr 11, 2015 1:21 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 4/10/2015 4:03 PM, John Hermsen wrote: I was wondering if there is anyone who manager to compile the sqlsrv driver for php 7. I have tried, but I haven't

[PHP-DB] PHP 7 and sqlsrv

2015-04-10 Thread John Hermsen
I was wondering if there is anyone who manager to compile the sqlsrv driver for php 7. I have tried, but I haven't been able to get it compiled yet. Thanks, John

[PHP-DB] Re: PHP 7 and sqlsrv

2015-04-10 Thread Jim Giner
On 4/10/2015 4:03 PM, John Hermsen wrote: I was wondering if there is anyone who manager to compile the sqlsrv driver for php 7. I have tried, but I haven't been able to get it compiled yet. Thanks, John php 7?? I didn't even see php 6 go past me! -- PHP Database Mailing List

Re: [PHP-DB] Re: PHP 7 and sqlsrv

2015-04-10 Thread christopher jones
On 4/10/15 3:20 PM, Jim Giner wrote: On 4/10/2015 4:03 PM, John Hermsen wrote: I was wondering if there is anyone who manager to compile the sqlsrv driver for php 7. I have tried, but I haven't been able to get it compiled yet. Thanks, John php 7?? I didn't even see php 6 go past me!

Re: [PHP-DB] Waiting for localhost

2015-04-02 Thread Karl DeSaulniers
My apology to the list. That was meant for Ethan's email only. I hit reply all when I though I just hit reply. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Apr 2, 2015, at 2:18 PM, Karl DeSaulniers k...@designdrumm.com wrote: Bro. Pick a SQL. mysql_ or mysqli_. Best,

Re: [PHP-DB] Waiting for localhost

2015-04-02 Thread Richard
Original Message Date: Thursday, April 02, 2015 00:18:45 -0400 From: Ethan Rosenberg erosenb...@hygeiabiomedical.com To: php-db@lists.php.net Cc: Subject: Re: [PHP-DB] Waiting for localhost On 04/01/2015 11:41 PM, Karl DeSaulniers wrote: Question to list, since

Re: [PHP-DB] Waiting for localhost

2015-04-02 Thread Karl DeSaulniers
Bro. Pick a SQL. mysql_ or mysqli_. Best, Karl Sent from losPhone On Apr 2, 2015, at 12:48 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: On 04/02/2015 06:17 AM, Richard wrote: snip Here are some hints service apache2 restart [] Restarting web server:

Re: [PHP-DB] Waiting for localhost

2015-04-02 Thread Richard
Original Message Date: Thursday, April 02, 2015 13:48:06 -0400 From: Ethan Rosenberg erosenb...@hygeiabiomedical.com To: php-db@lists.php.net Subject: Re: [PHP-DB] Waiting for localhost On 04/02/2015 06:17 AM, Richard wrote: snip Here are some hints

Re: [PHP-DB] Waiting for localhost

2015-04-02 Thread Ethan Rosenberg
On 04/02/2015 06:17 AM, Richard wrote: snip Here are some hints service apache2 restart [] Restarting web server: apache2AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress

Re: [PHP-DB] Waiting for localhost

2015-04-01 Thread Richard
Original Message Date: Wednesday, April 01, 2015 00:05:29 -0400 From: Ethan Rosenberg erosenb...@hygeiabiomedical.com To: php-db@lists.php.net Richard - As we saw in the Apache list, the problem lies in PHP/MySQL To quote -- Date: Tuesday, March 31,

Re: [PHP-DB] Waiting for localhost

2015-04-01 Thread Ethan Rosenberg
On 04/01/2015 07:34 AM, Richard wrote: Original Message Date: Wednesday, April 01, 2015 00:05:29 -0400 From: Ethan Rosenberg erosenb...@hygeiabiomedical.com To: php-db@lists.php.net Richard - As we saw in the Apache list, the problem lies in PHP/MySQL snip

Re: [PHP-DB] Waiting for localhost

2015-04-01 Thread Karl DeSaulniers
Question to list, since I have not had to venture to the mysqli territory just yet, but is it proper to use mysql_error() with mysqli transactions? This may be what your missing Ethan. mysql_error() looks for a mysql_ transactions doesn't it? Or are they interchangeable? Best, Karl

Re: [PHP-DB] Waiting for localhost

2015-04-01 Thread Ethan Rosenberg
On 04/01/2015 11:41 PM, Karl DeSaulniers wrote: Question to list, since I have not had to venture to the mysqli territory just yet, but is it proper to use mysql_error() with mysqli transactions? This may be what your missing Ethan. mysql_error() looks for a mysql_ transactions doesn't it? Or

Re: [PHP-DB] Waiting for localhost

2015-03-31 Thread Ethan Rosenberg
On 03/27/2015 06:16 AM, Richard wrote: snip Original Message These errors look odd to me. In many years of working with apache on a range of *nix OSs, I don't remember a (properly installed) apache instance that didn't have defaults that worked out of the box. They may

Re: [PHP-DB] Waiting for localhost

2015-03-27 Thread Richard
Original Message Date: Friday, March 27, 2015 01:29:49 -0400 From: Ethan Rosenberg erosenb...@hygeiabiomedical.com On 03/18/2015 07:51 AM, Richard wrote: Original Message Date: Wednesday, March 18, 2015 00:23:00 -0400 From: Ethan

Re: [PHP-DB] Waiting for localhost

2015-03-26 Thread Ethan Rosenberg
On 03/18/2015 07:51 AM, Richard wrote: Original Message Date: Wednesday, March 18, 2015 00:23:00 -0400 From: Ethan Rosenberg erosenb...@hygeiabiomedical.com To: Karl DeSaulniers k...@designdrumm.com, PHP Database List php-db@lists.php.net Subject: Re: [PHP-DB]

Re: [PHP-DB] Waiting for localhost

2015-03-18 Thread Richard
Original Message Date: Wednesday, March 18, 2015 00:23:00 -0400 From: Ethan Rosenberg erosenb...@hygeiabiomedical.com To: Karl DeSaulniers k...@designdrumm.com, PHP Database List php-db@lists.php.net Subject: Re: [PHP-DB] Waiting for localhost Karl - Thanks to

Re: [PHP-DB] Waiting for localhost

2015-03-18 Thread Ethan Rosenberg
On 03/18/2015 07:51 AM, Richard wrote: Original Message Date: Wednesday, March 18, 2015 00:23:00 -0400 From: Ethan Rosenberg erosenb...@hygeiabiomedical.com To: Karl DeSaulniers k...@designdrumm.com, PHP Database List php-db@lists.php.net Subject: Re: [PHP-DB]

Re: [PHP-DB] Waiting for localhost

2015-03-17 Thread Ethan Rosenberg, PhD
On 03/16/2015 12:08 AM, Karl DeSaulniers wrote: Is this a weight that is entered in by your friend or a weight that is grabbed from a database or a scale per chance? If it is the latter, you don't need this form, just store the value some other way and incorporate into your other script that

Re: [PHP-DB] Waiting for localhost

2015-03-17 Thread Karl DeSaulniers
No, can't say I do. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Mar 17, 2015, at 11:48 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Karl - Thanks to you and all others that have replied. With a little bit of patience [which I should have used

Re: [PHP-DB] Waiting for localhost

2015-03-17 Thread Ethan Rosenberg
On 03/16/2015 12:08 AM, Karl DeSaulniers wrote: Is this a weight that is entered in by your friend or a weight that is grabbed from a database or a scale per chance? If it is the latter, you don't need this form, just store the value some other way and incorporate into your other script that

Re: [PHP-DB] Waiting for localhost

2015-03-16 Thread Jim Giner
On 3/16/2015 12:02 AM, Ethan Rosenberg wrote: I have this in the program -- echo form method= 'post' action='HandleWeight.php'; echo centerstronginput type = 'submit' value= 'WEIGH'/strong/center; echo /form; I'm testing from a form, which previously worked perfectly - TIA Ethan How

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Jason Pruim
If you load up handleweight.php outside of the script does it load normally? Trying to pin down where the actual problem is. Jason Pruim 352.359.0002 On Mar 14, 2015, at 10:17 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: On 03/09/2015 08:27 AM, Ethan Rosenberg, PhD

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Jason Pruim
It could be a bad variable, or lack of access to an include file possibly? Put some echo statements in right before and right after some major blocks of code... It will help narrow down the problem since it will show you where it's holding up. The. You can concentrate on fixing just that part

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Ethan Rosenberg
On 03/15/2015 09:44 AM, Jason Pruim wrote: If you load up handleweight.php outside of the script does it load normally? Trying to pin down where the actual problem is. Jason Pruim 352.359.0002 On Mar 14, 2015, at 10:17 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: On

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Karl DeSaulniers
Also, if it is a matter of calling this script. Maybe try curl instead of echoing a javascript file? Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Mar 15, 2015, at 8:25 PM, Karl DeSaulniers k...@designdrumm.com wrote: Why are you not calling a database for the weight? Or is

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Ethan Rosenberg
On 03/15/2015 02:57 PM, Jason Pruim wrote: It could be a bad variable, or lack of access to an include file possibly? Put some echo statements in right before and right after some major blocks of code... It will help narrow down the problem since it will show you where it's holding up. The.

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Karl DeSaulniers
Is this a weight that is entered in by your friend or a weight that is grabbed from a database or a scale per chance? If it is the latter, you don't need this form, just store the value some other way and incorporate into your other script that directs to this form. Also, I noticed you spelt

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Karl DeSaulniers
Why are you not calling a database for the weight? Or is that what the handleweight.php does? If it is a matter of echoing the results from this page, can it's code be merged into the current? Then instead of echoing the script you just echo the results. Best, Karl DeSaulniers Design Drumm

Re: [PHP-DB] Waiting for localhost

2015-03-14 Thread Karl DeSaulniers
Fresh out of ideas. Sorry Ethan. Maybe try an different approach to calling that file? Seems like your trying to fit a square peg in a hexagon hole. Might get it in there but it wont be a perfect fit. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Mar 14, 2015, at 9:17 PM,

Re: [PHP-DB] Waiting for localhost

2015-03-14 Thread Ethan Rosenberg
On 03/09/2015 08:27 AM, Ethan Rosenberg, PhD wrote: On 03/09/2015 06:55 AM, Karl DeSaulniers wrote: Don't know what to tell you bub. Time for the books? I think that it has to do with php parsing or not parsing the echo because its echoing a script. Can't remember off the top, but along those

[PHP-DB] SQL injection attempt

2015-03-11 Thread Lester Caine
Been a while since I've had a concerted hacker attempt, but over night this has appeared in the logs. 'sort_mode' = 'last_modified_desc\' and(/**/sElEcT 1 /**/fRoM(/**/sElEcT count(*),/**/cOnCaT((/**/sElEcT(/**/sElEcT

Re: [PHP-DB] Waiting for localhost

2015-03-09 Thread Ethan Rosenberg, PhD
On 03/09/2015 06:55 AM, Karl DeSaulniers wrote: Don't know what to tell you bub. Time for the books? I think that it has to do with php parsing or not parsing the echo because its echoing a script. Can't remember off the top, but along those lines I would search. GL, Best, Karl DeSaulniers

Re: [PHP-DB] Code Security

2015-03-09 Thread Bastien Koert
Cloud computing is just another computer in a remote network. If you have a website with some host somewhere, you are cloud computing. Just run your site from a secure host On Sun, Mar 8, 2015 at 1:04 AM Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: On 02/16/2015 12:10 AM, Mark Murphy

Re: [PHP-DB] Waiting for localhost

2015-03-08 Thread Ethan Rosenberg
On 03/08/2015 01:40 AM, Karl DeSaulniers wrote: Ethan, Open a new window (window.open) inside itself (_self)? Try window.location for opening a url inside the same window. Use windlow.open to open a new window (ie: pop-up window). Also, I would take at least a month and learn basic html and

Re: [PHP-DB] Waiting for localhost

2015-03-08 Thread Ethan Rosenberg
On 03/08/2015 01:50 AM, Karl DeSaulniers wrote: Shit! — Half Price Books! Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Mar 8, 2015, at 12:49 AM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: On 03/08/2015 01:43 AM, Karl DeSaulniers wrote: The Dummies series is

Re: Fwd: [PHP-DB] Waiting for localhost

2015-03-08 Thread Ethan Rosenberg
On 03/08/2015 07:00 PM, Karl DeSaulniers wrote: Sorry, missed a parenthesis. if($row7[0] === 1) { echo('script type=text/javascriptwindow.location = HandleWeight.php;/script'); } Best, Karl DeSaulniers Design Drumm http://designdrumm.com http://designdrumm.com/ Begin forwarded message:

Re: [PHP-DB] Code Security

2015-03-07 Thread Ethan Rosenberg
On 02/16/2015 12:10 AM, Mark Murphy wrote: How do you prevent access to the second partition? What good is a second partition going to do? Both partitions are visible to the OS. If you only have a single OS, then both the client and the server are running on the same OS, and there is only one

[PHP-DB] Waiting for localhost

2015-03-07 Thread Ethan Rosenberg
Dear List - I am getting the message - waiting for localhost. Here are some diagnostic steps I have tried root@meow:/home/ethan# cat /var/www/cgi-bin/httpd.conf ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/jkj ServerName 127.0.0.1:80 Listen xx.xx.xx.xx:80 Listen 127.0.0.1:80

Re: [PHP-DB] Lost data after space in PHP variables

2015-02-19 Thread Richard Quadling
On 17 February 2015 at 20:36, Charlie Lewis charlie.le...@honest-it.com wrote: I'm not sure that this is entirely the group for my question, so apologise if it is. I'm losing data in variables that use the assignment of $_POST[]. Any variable with a space in the $_POST[] loses everything

Re: [PHP-DB] Lost data after space in PHP variables

2015-02-18 Thread Bastien Koert
Generally input names shouldn't have spaces, use underscores if needed On Tue Feb 17 2015 at 4:34:55 PM rahul bhola rb1223334...@gmail.com wrote: Can you post some code snippet here cheers Rahul

Re: [PHP-DB] Re: Code Security

2015-02-18 Thread Richard
But the fault here isn't with PHP. Ethan couldn't do what he wants, the way he seemingly has things set up, with any programming language. Compiled code might let him obscure things a little, and also potentially help hide the credentials used to access the db, but it would still be a totally

Re: [PHP-DB] Re: Code Security

2015-02-18 Thread Taco Mathijs Hillenaar-Meerveld
Sorry if i misread and put my reply in a wrong context. but from how i read this question it is all about preventing a user to open a terminal window. if Mr. Nice is logged in then i assume he has all rights as the topic starter is afraid Mr. ugly can look at his code. as far as i know it is not

Re: [PHP-DB] Re: Code Security

2015-02-18 Thread Mark Murphy
@Taco, Read back through the whole thread and you will understand. Ethan just can't do what he wants to with PHP. On Feb 18, 2015 9:59 AM, Taco Mathijs Hillenaar-Meerveld tm.hillen...@gmail.com wrote: Sorry if i misread and put my reply in a wrong context. but from how i read this question it

[PHP-DB] Lost data after space in PHP variables

2015-02-17 Thread Charlie Lewis
I'm not sure that this is entirely the group for my question, so apologise if it is. I'm losing data in variables that use the assignment of $_POST[]. Any variable with a space in the $_POST[] loses everything after the space. Is it that I need to enclose the data with ' or ? I've tried all

Re: [PHP-DB] Lost data after space in PHP variables

2015-02-17 Thread rahul bhola
Can you post some code snippet here cheers Rahul

Re: [PHP-DB] Code Security

2015-02-13 Thread Ethan Rosenberg
On 02/13/2015 02:58 AM, Karl DeSaulniers wrote: Prevent THIS from ever happening. On Feb 12, 2015, at 11:03 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: He asks Mr.[naive]Nice if he could look at the computer while it is logged in. Otherwise, I would say an external key that

RE: [PHP-DB] Code Security

2015-02-13 Thread Arneson, Joshua
Ethan, It seems like you're looking for a programmatic solution to a physical security problem. In the end, your most viable solution will likely be to train Mr. Goodguy to remove the key the same way he needs to remember his ATM card after a withdrawal. I've seen programmatic work-arounds

[PHP-DB] Re: Code Security

2015-02-13 Thread erosenberg
Ethan, It seems like you're looking for a programmatic solution to a physical security problem. In the end, your most viable solution will likely be to train Mr. Goodguy to remove the key the same way he needs to remember his ATM card after a withdrawal. I've seen programmatic work-arounds to

[PHP-DB] Re: php-db Digest 13 Feb 2015 05:03:55 -0000 Issue 5067

2015-02-13 Thread Geoffrey Pitman
...so unfucking-secure that this should never see the light of day... Do you have a pseudonym named Bastian Koert? :-) On Feb 13, 2015 12:04 AM, php-db-digest-h...@lists.php.net wrote: php-db Digest 13 Feb 2015 05:03:55 - Issue 5067 Topics (messages 48953 through 48953): Re: Code

Re: [PHP-DB] Code Security

2015-02-13 Thread Karl DeSaulniers
And in the same way, don't let him withdraw money from your account while your logged into the ATM. I mean it sounds like mr. Nice shouldn't have a business. At all. Best, Karl Sent from losPhone On Feb 13, 2015, at 8:17 AM, Arneson, Joshua joshua.arne...@mssm.edu wrote: Ethan,

Re: [PHP-DB] Re: Code Security

2015-02-13 Thread Guru
Put a redirect code in www folder to your index page. On Feb 13, 2015 10:55 PM, Karl DeSaulniers k...@designdrumm.com wrote: Set up a password or a salt that Mr. Nice has to call you to get and expires on logout. Lol Best, Karl Sent from losPhone On Feb 13, 2015, at 8:47 AM,

Re: [PHP-DB] Re: Code Security

2015-02-13 Thread Karl DeSaulniers
Set up a password or a salt that Mr. Nice has to call you to get and expires on logout. Lol Best, Karl Sent from losPhone On Feb 13, 2015, at 8:47 AM, erosenb...@hygeiabiomedical.com wrote: Ethan, It seems like you're looking for a programmatic solution to a physical security

Re: [PHP-DB] Code Security

2015-02-12 Thread Ethan Rosenberg
On 02/06/2015 02:45 PM, Bastien Koert wrote: Hold on, so you've written a point of sale app that exists on the client machine as whole? Does this take credit card data? If so, its so un-fucking-secure that this should never see the light of day. The CC companies won't accept this at all and

Re: [PHP-DB] Code Security

2015-02-12 Thread Karl DeSaulniers
Prevent THIS from ever happening. On Feb 12, 2015, at 11:03 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: He asks Mr.[naive]Nice if he could look at the computer while it is logged in. Otherwise, I would say an external key that has a salt stored on it that the user has to

[PHP-DB] PHP 5.6 OpenSSL changes and mysqli

2015-02-09 Thread Chupaka
Hello. Since 5.6, all encrypted client streams now enable peer verification by default. The problem I faced is with MySQL connection: we're connecting to old MySQL server with self-signed certificate, and are using simple SSL connection without certificates: mysql_connect(address, user,

Re: [PHP-DB] Code Security

2015-02-06 Thread Bastien Koert
Hold on, so you've written a point of sale app that exists on the client machine as whole? Does this take credit card data? If so, its so un-fucking-secure that this should never see the light of day. The CC companies won't accept this at all and would remove any ability to accept CCs by the

Re: [PHP-DB] Code Security

2015-02-06 Thread Richard
Original Message On Feb 5, 2015, at 8:24 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: On 02/05/2015 11:04 AM, Bastien Koert wrote: I'm with the two Richard's on this, those users shouldn't have telnet access to the host server at all. Users should

Re: [PHP-DB] Code Security

2015-02-05 Thread Felicia Case
Hi Ethan, If the user is to neither write nor use the code then why do they have access in the first place? Just wondering. F On Feb 5, 2015, at 8:24 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: On 02/05/2015 11:04 AM, Bastien Koert wrote: I'm with the two Richard's

Re: [PHP-DB] Code Security

2015-02-05 Thread Ethan Rosenberg
On 02/05/2015 11:04 AM, Bastien Koert wrote: I'm with the two Richard's on this, those users shouldn't have telnet access to the host server at all. Users should be using the browser to access your site. Other than that, the most important thing you can do is to regularly back up your code and

Re: [PHP-DB] Code Security

2015-02-05 Thread Richard Quadling
On 5 February 2015 at 05:52, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: How do I prevent someone from opening a terminal window, going to /var/www and stealing all my code? 1 - Don't allow terminal access to your box. 2 - Use a PHP byte code encoder (IonCube, Zend Guard) - not

Re: [PHP-DB] Code Security

2015-02-05 Thread Richard
Original Message Date: Thursday, February 05, 2015 13:10:51 + From: Richard Quadling rquadl...@gmail.com To: E Rosenberg erosenb...@hygeiabiomedical.com Cc: PHP Database List php-db@lists.php.net Subject: Re: [PHP-DB] Code Security On 5 February 2015 at

Re: [PHP-DB] Code Security

2015-02-05 Thread Bastien Koert
I'm with the two Richard's on this, those users shouldn't have telnet access to the host server at all. Users should be using the browser to access your site. Other than that, the most important thing you can do is to regularly back up your code and database to another location so that if

Re: [PHP-DB] Code Security

2015-02-05 Thread Omar Muhsin
You forgot this one keep the box OFFLINE ... best security :-D On 05-02-15 14:10, Richard Quadling wrote: 1 - Don't allow terminal access to your box. 2 - Use a PHP byte code encoder (IonCube, Zend Guard) - not perfect as they can be reversed to access the code in a form. 3 - Don't use PHP.

[PHP-DB] Gifts and Handicrafts

2015-02-04 Thread Prosperity Crafts
Hello! We are Prosperity Arts Crafts Co., Limited in China. We supply Crafts Gifts with high quality and competitive price. Home Garden Decors Holiday Gifts Ornaments Religious Items Kitchen Accessories DIY Promotional items Pls visit our website at

[PHP-DB] Code Security

2015-02-04 Thread Ethan Rosenberg
Dear List - How do I prevent someone from opening a terminal window, going to /var/www and stealing all my code? TIA Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Arrays from forms....

2015-01-07 Thread Ohmster
Gary E. Terry terry at quickinet.net writes: OK.. I am a moron.. Forgot that I had changed the name of the field in the form, and got sidetracked and didn't change it in the php... But, still not working correctly. Yes Mr. Terry, you are a moron. Of course it is still not working correctly,

Re: [PHP-DB] Re: [PHP] SESSIONS - SOLVED

2015-01-02 Thread Bastien Koert
No worries, Ethan. Sometimes we all try to outsmart ourselves by doing something new. Can I ask why you're opening a new window? Could the script not simply be included in the original PHP code and avoid the window open? I ask because pop up blockers may inhibit the functionality required. Or

[PHP-DB] Re: [PHP] SESSIONS

2015-01-01 Thread Ethan Rosenberg, PhD
David - Thanks. Besides running from the terminal which won't set a session since the browser controls cookies and stuff Bad wording What is displayed on the monitor. TIA. Ethan --- On 01/01/2015 07:39 PM, David OBrien wrote: On Thursday, January 1, 2015, Stuart Dallas

[PHP-DB] Re: [PHP] SESSIONS - SOLVED

2015-01-01 Thread Ethan Rosenberg
Bastein - Correct 100%. I feel rather stupid. A POST or GET will cause session variables to be transferred. From another post to the UNIX list, this works. script type=text/JavaScript !-- window.open(HandleFood.php,_self) //--\ /script and the SESSION variables transfer. Sorry for

[PHP-DB] Error fetching a second row from a result set (mysql)

2014-11-14 Thread Mark Murphy
Windows 7 SP1; php 5.3.29; Apache 2.4.9; MySQL 5.6.17 $isr = mysql_unbuffered_query ( $is, $link_id ); if ($isr === false) { ... } if ($isr) { $booking_id = ''; while ( $isv = mysql_fetch_assoc ( $isr ) ) { $result ['id'] = $isv ['id']; ... Second time through this loop I get the following

[PHP-DB] Re: Error fetching a second row from a result set (mysql)

2014-11-14 Thread Jim Giner
On 11/14/2014 1:46 PM, Mark Murphy wrote: Problem is that for the resource, the type is changed to Unknown by a different mysql_query within the loop. Any idea what will cause this? Maybe show us the whole code so we can see what you are telling us? -- PHP Database Mailing List

[PHP-DB] MariaDB Database / Table Structure

2014-11-04 Thread Ron Piggott
Hi Everyone. I am wondering if there are database queries that would a: produce the result of all the tables with a database * b: produce the result of all the columns with the specified database table * * I don't want any other details than these names. I am trying to build a WHILE loop

Re: [PHP-DB] MariaDB Database / Table Structure

2014-11-04 Thread Roberto Spadim
with mariadb/mysql: 2014-11-05 4:20 GMT-02:00 Ron Piggott ron.pigg...@actsministries.org: Hi Everyone. I am wondering if there are database queries that would SHOW DATABASES; - return all databases a: produce the result of all the tables with a database * SHOW TABLES FROM

[PHP-DB] ANN: PHP Generator 14.10 released

2014-11-04 Thread SQL Maestro Group
Hi! SQL Maestro Group announces the release of PHP Generator 14.10, a family of GUI frontends for Windows that allow you to generate feature-rich CRUD web applications for your databases. There are versions for MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite, Firebird, DB2, SQL Anywhere and

Re: [PHP-DB] MariaDB Database / Table Structure

2014-11-04 Thread Ron Piggott
This is extremely helpful. Thank you very much. SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='.$val.' * where $val is a database On Wednesday November 5 2014 2:14 AM, Roberto Spadim wrote: with mariadb/mysql: 2014-11-05 4:20 GMT-02:00 Ron Piggott

[PHP-DB] mysql and auth plugins

2014-10-21 Thread Roberto Spadim
Hi guys, i'm with a doubt about mysql and connect with a mariadb server using a dialog auth plugin (server side) i didn't found functions to execute dialog with server a full example of what i want but using heidisql can be found here: http://www.heidisql.com/forum.php?t=9752 any help is

[PHP-DB] Re: mysql and auth plugins

2014-10-21 Thread Roberto Spadim
here the php files (download only .php files): https://github.com/rspadim/server/blob/otp_plugin/plugin/auth_otp/ here the today output using mysql_connect: (using otp_auth_example.php php file) == MYSQL_CONNECT: PHP Warning: mysql_connect(): The server requested

Re: [PHP-DB] MySQLi

2014-09-15 Thread Jasper Kips
Op 15 sep. 2014 om 01:08 heeft Karl DeSaulniers k...@designdrumm.com het volgende geschreven: Procedural php. Haven't had a chance to learn OOP. Would love to though. : / I think I may be moling it a bit too. Guess I was hoping for an easy fix, don't judge me.. :P Thanks for all your

Re: [PHP-DB] MySQLi

2014-09-15 Thread Karl DeSaulniers
On Sep 15, 2014, at 11:51 AM, Jasper Kips jas...@planetkips.nl wrote: Op 15 sep. 2014 om 01:08 heeft Karl DeSaulniers k...@designdrumm.com het volgende geschreven: Procedural php. Haven't had a chance to learn OOP. Would love to though. : / I think I may be moling it a bit too. Guess I

Re: [PHP-DB] MySQLi

2014-09-14 Thread Lester Caine
On 14/09/14 04:57, Karl DeSaulniers wrote: Awesome, thanks for the link. I know even less about PDO then I do regular MySQL however. I am hoping MySQLi isn't too far off a shoot. Just need to sit down with it all and figure out a path. PDO is still a bit of a grey area. It was intended to

Re: [PHP-DB] MySQLi

2014-09-14 Thread Karl DeSaulniers
Procedural php. Haven't had a chance to learn OOP. Would love to though. : / I think I may be moling it a bit too. Guess I was hoping for an easy fix, don't judge me.. :P Thanks for all your responses everyone. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Sep 14, 2014, at

[PHP-DB] MySQLi

2014-09-13 Thread Karl DeSaulniers
Hello All, Hope this message finds you well. Quick question about MySQLi and PHP. I have a website that was built back in 2012 that is still on PHP 5.2 and MySQL and I am wanting to update it to PHP 5.7 with MySQLi without headaches. I am dreading this like a spoonful of molasses. Is there any

Re: [PHP-DB] MySQLi

2014-09-13 Thread Lester Caine
On 13/09/14 11:40, Karl DeSaulniers wrote: Hope this message finds you well. Quick question about MySQLi and PHP. I have a website that was built back in 2012 that is still on PHP 5.2 and MySQL and I am wanting to update it to PHP 5.7 with MySQLi without headaches. I am dreading this like a

Re: [PHP-DB] MySQLi

2014-09-13 Thread Karl DeSaulniers
On Sep 13, 2014, at 7:40 AM, Lester Caine les...@lsces.co.uk wrote: On 13/09/14 11:40, Karl DeSaulniers wrote: Hope this message finds you well. Quick question about MySQLi and PHP. I have a website that was built back in 2012 that is still on PHP 5.2 and MySQL and I am wanting to update

Re: [PHP-DB] MySQLi

2014-09-13 Thread Aziz Saleh
On Sat, Sep 13, 2014 at 8:55 PM, Karl DeSaulniers k...@designdrumm.com wrote: On Sep 13, 2014, at 7:40 AM, Lester Caine les...@lsces.co.uk wrote: On 13/09/14 11:40, Karl DeSaulniers wrote: Hope this message finds you well. Quick question about MySQLi and PHP. I have a website that was

Re: [PHP-DB] MySQLi

2014-09-13 Thread Karl DeSaulniers
Awesome, thanks for the link. I know even less about PDO then I do regular MySQL however. I am hoping MySQLi isn't too far off a shoot. Just need to sit down with it all and figure out a path. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Sep 13, 2014, at 10:52 PM, Aziz

[PHP-DB] Duplicate Writes

2014-09-13 Thread Ethan Rosenberg
Dear List - I seem to be getting dual writes causing a dual insert into the database, and I cannot figure out why. Database mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra |

[PHP-DB] Number of Lines in Table. SOLVED

2014-09-06 Thread Ethan Rosenberg
Dear List - This works: mysql describe Purchases; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | indx | smallint(6) | NO | PRI | NULL|

[PHP-DB] Number of Lines in Table.

2014-09-02 Thread Ethan Rosenberg
Dear List - This works: mysql describe Purchases; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | indx | smallint(6) | NO | PRI | NULL|

Re: [PHP-DB] Number of Lines in Table.

2014-09-02 Thread Matt Pelmear
See : http://stackoverflow.com/questions/14682448/how-to-get-the-total-row-count-with-mysqli Matt On Sep 2, 2014 7:38 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: Dear List - This works: mysql describe Purchases; +---+-+--+-+-++

Re: [PHP-DB] Number of Lines in Table.

2014-09-02 Thread Karl DeSaulniers
On Sep 2, 2014, at 9:37 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: Dear List - This works: mysql describe Purchases; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra |

Re: [PHP-DB] Number of Lines in Table.

2014-09-02 Thread Karl DeSaulniers
Whoops, this should be.. print_r('Results { '.$rowarray.' }'); Karl DeSaulniers Design Drumm http://designdrumm.com On Sep 2, 2014, at 11:57 PM, Karl DeSaulniers k...@designdrumm.com wrote: print_r('Results { '.$row.' }'); -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Number of Lines in Table.

2014-09-02 Thread Matt Pelmear
Karl, This works for small datasets, but when you have a large amount of data (either in terms of storage or row count) it is no longer practical. This is why people typically use the SQL row count instead of transferring all of the data to php and doing the work there. It is much more efficient.

Re: [PHP-DB] Number of Lines in Table.

2014-09-02 Thread Karl DeSaulniers
I see. Ok thanks Matt. Will look into that if I start working with those size databases. My apology Ethan, wasn't aware of the scope. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Sep 3, 2014, at 12:09 AM, Matt Pelmear mjpelm...@gmail.com wrote: Karl, This works for

Re: [PHP-DB] Number of Lines in Table.

2014-09-02 Thread Karl DeSaulniers
On Sep 3, 2014, at 12:13 AM, Karl DeSaulniers k...@designdrumm.com wrote: Dear List - This works: mysql describe Purchases; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra |

Re: [PHP-DB] Writing Problems

2014-08-27 Thread Matt Pelmear
/***/ $fp = fopen('filename.txt', 'a+'); // The correct thing to do is: if (! $fp) throw new Exception( 'Something went wrong opening the file' ); // Otherwise, you can also check with: if (! is_resource($fp)) throw new Exception( 'Something went

[PHP-DB] Re: www-data file

2014-08-26 Thread Jim Giner
On 8/26/2014 12:20 AM, Ethan Rosenberg wrote: Dear list - When I use fopen, the file owner and group are both www-data. How can I ensure that the owner and group will be ethan? TIA Ethan Why should ownership be a concern when you are simply opening a file? AFAIK permissions are set at

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

2014-08-26 Thread Matt Pelmear
On 08/26/2014 06:21 AM, Jim Giner wrote: On 8/26/2014 12:20 AM, Ethan Rosenberg wrote: Dear list - When I use fopen, the file owner and group are both www-data. How can I ensure that the owner and group will be ethan? TIA Ethan Why should ownership be a concern when you are simply

Re: [PHP-DB] www-data file

2014-08-26 Thread Jasper Kips
What are you trying to achieve? Or to put it more clearly, why do you need the filw owner to be ethan? Jasper Verstuurd vanaf mijn iPad Op 26 aug. 2014 om 06:20 heeft Ethan Rosenberg erosenb...@hygeiabiomedical.com het volgende geschreven: Dear list - When I use fopen, the file

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