Re: [PHP-DB] Exporting mySQL to Excel

2011-11-09 Thread Matijn Woudt
On Thu, Nov 10, 2011 at 12:32 AM, Ron Piggott ron.pigg...@actsministries.org wrote: I am wondering how phpmyadmin makes Excel files on the fly --- Is it a class? They used PHPExcel in the past, but they had to remove because of license issues. Don't know what they're currently using, but if

Re: [PHP-DB] Prepared Statements

2011-11-11 Thread Matijn Woudt
On Fri, Nov 11, 2011 at 5:41 PM, Ron Piggott ron.pigg...@actsministries.org wrote: I have two questions about Prepared Statements from the code below: #1: The purpose of the first $query is to determine if the authorization code supplied is both accurate and also live - When the

Re: [PHP-DB] Set Mssql Application name in connection string

2011-12-13 Thread Matijn Woudt
On Tue, Dec 13, 2011 at 1:33 PM, Dan Rowe d...@dracosplace.com wrote: We needed to be able to set the application name in a mssql connection string, but php doesn't current toy support it. This can be very helpful while debugging/profiling php-mssql from the SQL server side of things.

Re: [PHP-DB] Set Mssql Application name in connection string

2011-12-13 Thread Matijn Woudt
On Tue, Dec 13, 2011 at 10:58 PM, Dan Rowe d...@dracosplace.com wrote: Hey Matijn, Thanks for the tip. We did send it there the day we submitted it, so its good to know we were on the right track. Unfortunately it didn't gain any traction or any status updates on the bug tracker. Figured I

Re: [PHP-DB] Multiple Access to Database

2012-01-17 Thread Matijn Woudt
Ethan, you've send the same question a few days ago. There's no point in asking the same question twice. Matijn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php adodb book suggestins

2012-01-26 Thread Matijn Woudt
On Thu, Jan 26, 2012 at 12:06 PM, David McGlone da...@dmcentral.net wrote: On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: David McGlone wrote: can anyone suggest any good up to date books out there on php  adodb. The only documentation on ADOdb is the website

Re: [PHP-DB] Subscription Suspensions

2012-01-31 Thread Matijn Woudt
On Tue, Jan 31, 2012 at 6:35 PM, Ron Piggott ron.pigg...@actsministries.org wrote: Hi Everyone. I manage an e-mail list.  I am trying to add a new function into it: suspensions.  The idea is that someone wouldn’t have to unsubscribe.  Instead there would be a record of their suspension in

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Matijn Woudt
On Wed, Feb 29, 2012 at 3:01 PM, Kranthi Krishna kranthi...@gmail.com wrote: Hi all, Say I have an object like array    schoolName = string    board = array         string         string I generally create  two MySql tables schools: id PRIMARY KEY, SchoolName boards: id FOREGIN KEY

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 1:03 PM, Gu®u nagendra802...@gmail.com wrote: Hi, Please help me with this code. I have 2 different fields in mysql table. What I want is if the field is empty don't show the image. Please look at the code below. I have looked at it. Maybe you should tell what is

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 3:06 PM, Gu®u nagendra802...@gmail.com wrote: The issue is both the images are echoing and no if else statement is working. First of all, please bottom post on this (and probably any) mailing list. You should perhaps provide what the contents of

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 4:53 PM, Gu®u nagendra802...@gmail.com wrote: No Michael, your code is also not working. What you have understood is correct. let me explain it to others too. If variable twitter and facebook are empty don't echo anything, if variable twitter has a value and facebook

Re: [PHP-DB] search of data base - again

2012-03-29 Thread Matijn Woudt
On Fri, Mar 30, 2012 at 1:10 AM, Ethan Rosenberg eth...@earthlink.net wrote: Sending again, since no response on 1st try. Ethan == Dear List I am trying to insert data into a table, with no success. I have two tables: mysql describe Visit3;

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Matijn Woudt
On Fri, Mar 30, 2012 at 7:49 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Jim Giner jim.gi...@albanyhandball.com wrote in message news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2... === Martijn Jim - Is it just the date that is the problem? Yes. Tru dat.  But mySql

Re: [PHP-DB] Engine?

2012-04-16 Thread Matijn Woudt
On Mon, Apr 16, 2012 at 1:09 PM, Bastien phps...@gmail.com wrote: Bastien Koert On 2012-04-16, at 2:21 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Apr 15, 2012, at 9:29 PM, Vinay Kannan wrote: Hello, I've always been left wondering what Engine to use while creating tables, I've

[PHP-DB] Re: [PHP] PHP Database Problems -- Code Snippets

2012-05-02 Thread Matijn Woudt
On Wed, May 2, 2012 at 11:43 PM, Ethan Rosenberg eth...@earthlink.net wrote: Dear list - Sorry for the attachment.  Here are code snippets --- Ethan, I don't want to sound rude, but it appears to me you don't have any understanding of what you're doing. It might help if you understand what

[PHP-DB] Re: [PHP] PHP Database Problems -- Code Snippets

2012-05-05 Thread Matijn Woudt
On Thu, May 3, 2012 at 4:20 PM, Ethan Rosenberg eth...@earthlink.net wrote: At 06:47 PM 5/2/2012, Matijn Woudt wrote: On Wed, May 2, 2012 at 11:43 PM, Ethan Rosenberg eth...@earthlink.net wrote: Dear list - Sorry for the attachment. Â Here are code snippets --- Ethan, I don't want to sound

Re: [PHP-DB] Multiple Database Connection Using Prepard Statements

2012-05-19 Thread Matijn Woudt
On Sat, May 19, 2012 at 8:36 PM, Ron Piggott ron.pigg...@actsministries.org wrote: How do I connect to multiple mySQL databases using Prepared Statements ? I have the syntax === $dsh = 'mysql:host=localhost;dbname='.$database3; $dbh = new PDO($dsh, $username, $password); === I want to

Re: [PHP-DB] Mysterious 5 second delay on sybase_connect()

2012-05-24 Thread Matijn Woudt
On Thu, May 24, 2012 at 10:51 AM, Tom Lloyd tomll...@wallcolmonoy.co.uk wrote: Hi there.  I'm working on a PHP-driven project on Debian Squeeze that connects to an instance of Microsoft SQL Server on Windows Server 2008. I'm using the sybase extensions to PHP. Since I rebooted the webserver

Re: [PHP-DB] ERROR W/ SQLSRV, PHP 5.4 SYMFONY!!!

2012-06-07 Thread Matijn Woudt
On Thu, Jun 7, 2012 at 7:42 AM, OJFR misabe...@infomed.sld.cu wrote: HI, Snip rude text OSAIN. Hi, You might want to read the PHP mailing list rules[1] and RFC 1855[2] before posting to this mailing list again. - Matijn [1] http://www.php.net/reST/php-src/trunk_README.MAILINGLIST_RULES

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Matijn Woudt
On Sun, Jun 17, 2012 at 10:21 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Ethan Rosenberg eth...@earthlink.net wrote in message news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... At 03:30 PM 6/17/2012, Jim Giner wrote: Ethan Rosenberg eth...@earthlink.net wrote in message

Re: [PHP-DB] SQL omit record if ever had value set

2012-06-18 Thread Matijn Woudt
On Mon, Jun 18, 2012 at 11:56 PM, Dee Ayy dee@gmail.com wrote: I would like a query that lists records where a column has not taken on a specific value when grouped by another column. N  V n1 v1 n1 v2 n2 v1 n2 v2 n2 v3 n3 v1 If v3 has ever been set for N, do not list N.  So the

Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-25 Thread Matijn Woudt
On Wed, Jul 25, 2012 at 12:21 PM, Tamara Temple tamouse.li...@tamaratemple.com wrote: Brad nyctelec...@gmail.com wrote: Here is where everything stands.. L http://pastie.org/4317155 I feel strange bottom posting, somehow, BUT THAT'S THE RULE It makes each individual message readable in a

Re: [PHP-DB] Prepared Statements Insert Problem

2012-09-02 Thread Matijn Woudt
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I wish to accomplish the following with prepared statements: $stmt = mysqli_stmt_init($cxn); if($stmt = mysqli_stmt_prepare($stmt, INSERT INTO Intake3 (Site, MedRec, Fname, Lname,

Re: [PHP-DB] Prepared Statements Insert Problem - Any more ideas?

2012-09-02 Thread Matijn Woudt
On Sun, Sep 2, 2012 at 10:41 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I wish to accomplish the following with prepared statements: $stmt =

Re: [PHP-DB] opening error messages in a new window

2012-09-26 Thread Matijn Woudt
On Wed, Sep 26, 2012 at 10:41 AM, Dr Vijay Kumar vaibhavinformat...@gmail.com wrote: In filling a form, error messages should come in a new widow while retaining the form filled on the screen. Coding in php is required. -- PHP can't do anything 'onscreen'. If you want to do anything

Re: [PHP-DB] Program Dies

2012-10-14 Thread Matijn Woudt
On Sun, Oct 14, 2012 at 11:57 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - Thank you ever so much for all your help. I apologize in advance for dumping all this code on you. I cannot get any debugger to work for me [see my separate email on debuggers]. I

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.

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] 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] 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] excec / query on Sqlite3

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

Re: [PHP-DB] Problem with query

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

Re: [PHP-DB] 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] Subject Matter

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

Re: [PHP-DB] Subject Matter

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