urns a singleton object with PDO
connected to the database.
$sql = "BEGIN; select my_function('my_refcursor'); FETCH ALL from
'my_refcursor';";
$p = $database->query($sql);
$p->execute();
$result = $p->fetchAll();
$p->closeCursor();
-
Matthew Hartman
Programm
ause on
your first INSERT, and then pass the value as a parameter.
http://www.postgresql.org/docs/8.3/interactive/sql-insert.html
By the way, for obvious reasons, you should be using parameterized
queries to prevent SQL injection.
Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kings
you-return-multiple-result
-sets-using-pdo-and-postgresql
Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
(613) 549- x4294
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
gt;
> If it does work, then it is a sign that the database driver is not
> really preparing the statement (as it should for performance reason),
> but it is just substituiting values to compose a SQL (just for your
> convenience).
>
> On 10/31/08, Matthew Peltzer <[EMAIL PROTECTED]&g
bound variables does not match number of
tokens" error.
So it appears the parsing mechanism is funcitoning, but what ever is
responsible for binding to ORDER BY is not.
I've looked in bug reports and the change logs, but did not find a
explicit reference to this issue.
--
-- Mat
Hi fellow php late night peoples
Thanks for everyone's help the last couple of days...
I have learned so much. The best way to learn this stuff...is simple trial and
error...
and thanks for good old Ggle!
My problem tonight is very simple. I just don't know what command I want to
use.
Thanks Chris...
added the extra =
and its working fine...
Have a nice day everyone
Matt
- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: "Matthew Ferry" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, February 13, 2007 11:53 PM
Subject: Re
Hello Everyone,
Got another simple problem here
I am trying to do a if statement inside a while (mysql_fetch_array)
Here is my code:
if ($link = mysql_tech_array($links)) {
do {
if ($_GET['page'] = "$link[file]") {
$status = 'reg_button.php';
} else {
$status = 'push_button.php';
"$event[cal_description]";
echo "\n";
echo "\n";
} while ($event = mysql_fetch_array($events));
} else {
echo "No Public Events Are Currently Scheduled...";
}
?>
- Original Message -
From: "Matthew Ferry" <[EMAIL PROTECTED]>
To:
Hello Everyone
Got a simple / stupid question.
Worked on this all night. I'm over looking something very basic here.
The query "event_time" brings back the calendar id for each event that is
pending in the future.
ie 12, 13, 14, 26 (There could be 100 of them out there)
The second quer
query1 = SELECT * FROM egw_addressbook
query2 = SELECT contact_id, contact_value FROM egw_addressbook_extra WHERE
contact_name='Supplier'
query3 = SELECT contact_id, contact_value FROM egw_addressbook_extra WHERE
contact_name='RANO'
query4 = SELECT contact_id, contact_value FROM egw_addressbook_ex
yeah..that is what i'm trying to do, but
I need to query WHERE contact_name='Supplier' and bring back the value for
contact_value
query WHERE contact_name='RANO' and bring back the value for
contact_value
query WHERE contact_name='Dynamic' and bring back the value
for
contact_id=' 1'
Then add those values to the array created from query of the first table
Thanks...
Matt
- Original Message -
From: Natalie Leotta
To: Matthew Ferry
Sent: Friday, January 12, 2007 3:41 PM
Subject: Re: [PHP-DB] 2 queries --> 1 array
I t
Hello,
I need to query two different tables and create one "BIG" array.
I can query both tables, but can't find a way to combine the results in one
array.
The problem comes in with the second table. It has a weird layout.
The second table only has four fields. They are: contact_id, contact_o
Hello everyone
I'm back working on the website again... I'm having lots of fun.
I have a sql query that looks at one field in a database. (result2 query)
Then i have mysql_fetch_array statement.
I then use this array to print links on the page.
Works fine except I don't want duplicate links.
e than SCRIPT_NAME as not all httpd servers use it.
> On Sat, 6 Aug 2005, Ron Piggott wrote:
>
> > What is the correct $_SERVER that tells me what page is currently being
> > displayed? Ron
--
Matthew Weier O'Phinney
Zend Certified Engineer
http://weierophinney.net/matthe
rver, or if the slave server had stopped or did not have permissions
to read from the master server. Are you absolutely certain that PHP is
connecting to the master db server when performing the write operation?
--
Matthew Weier O'Phinney
Zend Certified Engineer
http://weierophinney.net/matthew/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
tter to try and handle the error, or to determine in
development how to ensure it doesn't occur. However, if the error isn't
critical, and your script can continue to function even if it occurs,
suppressing the error often is a viable option.
--
Matthew Weier O'Phinney
Zend Certified E
ll be using the value for
session.use_cookies that is in the php.ini file.
One possible way to get around this is to do your ini_set in a .htaccess
file instead (assuming htaccess files are enabled, and you're using
Apache):
.htaccess:
php_value session.use_cookies 0
Try
acing it in your
database. Check to see if the data is of the correct type and/or falls
within the correct range of values allowed for the field it will occupy.
Doing this will help keep your data normalized and prevent headaches
later on.
By the way, if you want some best practices for es
our advice!
- Matthew
-Original Message-
From: Brad Webb [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 12:21 PM
To: [email protected]
Subject: Re: [PHP-DB] Transfering post data to a series of pages.
You may also consider using sessions to store form data.. this allows
for a
anyone found it causes conflict or is there really no problem?
There's no problem. PhpDoc goes into comments; there's no interaction
with code whatsoever.
--
Matthew Weier O'Phinney | WEBSITES:
Webmaster and IT Specialist | http://www.garden.org
National Gardening
<%Server.Transfer ("transferpage1.asp")%>
Is there a counterpart with PHP?
- Matthew
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
agesize() -- though you should be using php >= 4.3.11 to
do this safely (see http://security.gentoo.org/glsa/glsa-200504-15.xml
for more information). One element returned by getimagesize() is the
image MIME type.
--
Matthew Weier O'Phinney | WEBSITES:
Webmaster and IT Specialist
, date_received LIKE '$yesterdays_date' is what you're actually
trying to test. That said, you'll get much better results with:
SELECT *
FROM table
WHERE
date_received LIKE '$todays_date' OR
date_received LIKE '$yesterdays_date'
ORDER BY
pra
image into the file I am
attempting to generate.
Is there a means to insert the actual image into the generated file instead
of the path?
Thank you for your time,
Matthew Perry
her function?
I have never tried something like this before.
- Matthew
-Original Message-
From: Martin Norland [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 16, 2005 10:09 AM
To: [email protected]
Subject: Re: [PHP-DB] grabbing data from other peoples sites
Perry, Matthew (Fire M
x27;t even know where we should start.
- Matthew
to enable GD?
- Matthew
7;ll only be operating on deltas from
here out, and those can be done quite quickly.
Anyways, it's a moot question now -- I've got the data in, and I'm
pretty happy with the results I've seen.
> On Friday 11 February 2005 11:56 am, Matthew Weier O'Phinney wrote:
>>
s
(I've now got that fixed) and (2) speed. I still don't have (2)
completely fixed, and it may be something I can't fix.
> On Thursday 10 February 2005 07:56 pm, Matthew Weier O'Phinney wrote:
>> I have a table which contains the following:
>> id (pr
include mailto:[EMAIL PROTECTED]
Sent: Friday, February 11, 2005 10:47 AM
To: [email protected]
Subject: Re: [PHP-DB] Excel headers not working anymore
Perry, Matthew (Fire Marshal's Office) wrote:
> Good morning,
>
> I have been using PHP4.1, Apache, and MySQL for a few year
* Martin Norland <[EMAIL PROTECTED]>:
> Matthew Weier O'Phinney wrote:
> > I have a table which contains the following:
> > id (primary key, auto incrementing)
> > app_id (integer, foreign key)
> > resource_id (integer, foreign key)
> > w
Good morning,
I have been using PHP4.1, Apache, and MySQL for a few years now and have
never had a problem with my Excel headers. When I want to output html to
Excel I place the following on the top of the page:
http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
w to
spot check 300 values to be certain that this is reasonable.
In a previous incarnation of the script, I was looping through each word
of each resource_id and then selecting out of tmp1 based on the single
word value. The results were very different (very few matches), and,
again, the sc
instead that
allows collapsing menus?
Thank you for your time,
- Matthew Perry
the session array and
it works beautifully now.
Thank you all for your advice!
- Matthew
-Original Message-
From: Simon Rees [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 25, 2005 4:25 PM
To: [email protected]
Cc: Perry, Matthew (Fire Marshal's Office)
Subject: Re: [PHP-DB] IIS
e advice on what I may need to change
in my own code so that it works with IIS instead of Apache.
Thank you for your time,
Matthew Perry
off with PHP variables? It
doesn't seem to be a problem with HTML.
This is exceedingly difficult to research online because '&' is excluded
from most search engines automatically.
-Matthew
lues?
UPDATE TEST set testA='b' where testA='';
UPDATE TEST set testA='b' where testA<>'a';
How is it possible that all NULL values equal any string?
If this question does not belong in this list I will make no additional
postings concerning this
TATUS='Inactive' where STATUS != 'Active';
UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS <> 'Active';
UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS IS NULL';
UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS = '';
UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS = NULL;
- Matthew
This one should be easy for most of you.
What is the SQL query to select the column name for the primary key of a
table?
-Matthew
over this problem all morning.
-Matthew
s and MySQL) or would this just cause problems?
2) If I must use Access, should I use ASP(grrr) instead of PHP?
3) If I must use Access, should I use MS SQL Server(grrr) instead of MySQL?
Thank you all for your time and patience.
- Matthew
-Original Message-
From: Bastien Koert [mailto:[
Does anyone know of a FREE program that exports MySQL to access? The trial
versions of the ones I have downloaded do not export all the records of the
database.
- Matthew
disconnecting on every page going to cause any problems? Are
there any other concerns I should consider?
Matthew
Peter Lovatt wrote:
You could use JavaScript
onblur executes when the user leaves the box, and will submit the form
HTH
Peter
-Original Message-
From: Matthew Perry
Is there a way to make an input box save data into a database as users
type? My users keep forgetting to press my "apply changes" buttons.
Matthew
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
When you export a table to excel, is there a way to merge cells and create
borders? I want my excel file to look exactly like my html table looks.
Matthew Perry
I need some ammo to convince my boss not to use ASP but use PHP instead.
Anyone have some info I can give him?
- Matthew
How do you append both an anchor and a variable to a URL with PHP?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
e a stored procedure or
trigger that could do this.
What tools can I use with MySQL instead of procedures or triggers?
Matthew
Does anyone know a free MySQL backup program to schedule regular backups?
How do I provide a password?
I have been trying -p password[mypass] mysqldump sampledb >
./backup/file.txt
-Matt
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 11:24 AM
To: Perry, Matthew (Fire Marshal's Office)
Cc: [EMAIL PROTECTED]
I have attempted to follow the documentation for mysqldump both on mysql.com
and previous emails to this list server. Unfortunately none of the advice
has helped me successfully backup my database. I have been spoiled by
phpmyadmin backup procedures and have never had to manually set up a backup
I am using PHP 4.1
Why would the php function imagecreatefromjpeg() not be recognized?
Fatal error: Call to undefined function: imagecreatefromjpeg() in C:\Program
Files\Apache Group\Apache2\htdocs\Inventory\updateitem.php on line 77
-Matthew Perry
How embarrassing.
Yes I must have accidentally deleted the table.
I reinstalled and it works fine now.
Thank you very much for your help.
-Matt
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 11:14 AM
To: Perry, Matthew (Fire Marshal&#
rors
for me on MySQL Version 4.0.16.max-nt.
Make sure that you are logged in as root.
C : \ >select user();
Sometimes MySQL is cryptic about its error messages for security reasons.
dave
"Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]>
10/19/2004
that corresponds to
your MySQL server version for the right syntax to use near
'PASSWORD('mypassword')' at line 1
Why does this not set my password correctly?
-Matt
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 1:35 PM
To:
I am developing a variety of different web based systems including
inventory, payroll, incident reports etc. Should I create a new database
for each project category or one huge database with every table I will ever
use in it?
-Matt
I have tried the step-by-step methods listed on mysql.com for setting a root
password for my local server but I keep getting the message "you must have
privileges to update tables in the mysql database to be able to change
passwords for others". What could I be doing incorrectly?
-Matt
The MySQL database on my web host has only non-sensitive information.
How bad an idea is it to have a backup copy emailed to me at a
designated time so I don't have to depend on myself and the host for
backups?
I am worried this cheep web host will go out of business and take my
backups with hi
How do I get my PHP funcitons to execute independantly based on what
time of day it is and not on the user?
This may not be how PHP was designed but I would like to do things like
send out an email to someone based on suchandsuch criteria, backup DB on
regular schedule etc.
- Matt
--
PHP Datab
Anyone know when there will be a version of MySQL that can handle nested
subqueries?
-Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
application that can help me with this so I can get away from UI development
back to my DB management?
I realize this is not a web design list server.
Matthew Perry
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> If you look up the manual entry for UPDATE, you'll find that you're
missing
> the commas separating the columns.
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.biz
> Open Source Software Systems Integrators
> * W
n =
'trophie' at line 3
thanks for your help
--
Advanced Forums, For Free! - Speak EZ forums (
http://www.speakezforums.com )
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Wednesday 13 October 2004 04:08, Matthew Kiehne wrote:
&g
forgive the poor structure of my code, im pretty new at this and havent
figured out exactly what it should be formed like to look its best, anyway
whenever i run this code it works on inserting new information into the
database, however when i want to update the SQL query returns an output like
thi
Does anyone know a good class or program that automatically generates an
ER diagram from all tables in a MySQL database?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Simple question,
How does one import excel and access data to MySQL?
-- Matthew Perry
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi, im fairly new to php and mysql and need a little help. im running a
forum community and would like to have it run on multiple databases because
of performance issues others have encountered using the same software on on
database. My question is is it possible to have the software connect to 2
d
The latest version is still only alfa.
Miles Thompson wrote:
Check the MySQL docs - I *think* subqueries are supported in the
latest version, but not triggers or stored procedures. But as I say,
check.
Alternatives? PostgreSQL or Firebird.
HTH - Miles Thompson
At 11:07 AM 10/1/2004, Matthew
"Error while executing command";
// Print results
while(odbc_fetch_row($result))
print odbc_result($result, 1) . " " . odbc_result($result, 2)
. " " . odbc_result($result, 3) . " " . odbc_result($result, 4) .
" " . odbc_result($res
Does anyone know of a good online source for using php and microsoft
access.
I don't want to have to use asp.
Thank you for your time.
Matthew Perry
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
27;phone']."%' or '%".$_POST['email']."%'");
I cant seem to figure out how to display. I have tried
$_POST['firstname']; ?> in the HTML but there was no return of data.
This is my form:
First Name:
Last Name:
Phone :
Email :
(6) NULL,
billable tinyint(1)NULL,
billed tinyint (1) NULL,
cost varchar (6) NULL,
last_modified_by varchar (50) NULL,
last_modified_date datetime NULL,
);
-Original Message-
From: Matthew McNicol [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 18, 2004 5
roducts owned.
I am running mysql latest version.. Any help would be greatly
appriciated
--
_
Matthew McNicol
yellowmarker.co.uk
PHP / MySQL web development
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
r from
$last_name and adds datetime in format of 715041200
Thanks any help appreciated
Vincent Jordan
Technical Support
Smart Parts, Inc.
Loyalhanna Business Complex
100 Station Street
Loyalhanna, PA 15661
800-992-2147 X 5617
--
_
Matthew McNicol
yellowmarker.co.uk
PHP / MySQL web
Why does this direct me to loginError.php even when $logIn = 1?
- Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Everyone,
Thank you very much for your advice about not using "PUT". I will use
GET or POST from now on.
I am, however, failing to understand how to use headers to change pages
instead of meta tags.
After checking if the user has logged in correctly I do this:
if ($loginGood){
echo '';
}
I SOMETIMES get the "cannot be displayed"
message. SOMETIMES it works even on her computer!
Anyone know why?
- Matthew Perry
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Then I withdraw the question.
Thank you for your time.
John W. Holmes wrote:
matthew perry wrote:
When my users choose an option in the drop down menu, they sometimes
accidentally change what they have chosen when the move the center
scrolling button of their mouse. I was giving a presentation
When my users choose an option in the drop down menu, they sometimes
accidentally change what they have chosen when the move the center
scrolling button of their mouse.
I was giving a presentation in front of my company's owner and did this
myself.
5 or so index fingers instantly pointed at me
My users complain about everything.
The most common is "Why do I have to move the mouse over to this box
every time? Wh!"
How do I get the cursor to que into the first input area of my form?
-Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/
What PHP function returns just the first letter of a string?
- Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I have a file uploading function that works well on my local server.
It finds a picture and uploads it into a defined directory.
Unfortunately this function does not work when I try to upload to my web
host.
It says I do not have the proper permissions.
I believe this has to do with the fact that
I think the problem isn't session data specifically. The log in fails
before the session begins.
Strangely this ONLY happens with macs. I have never had a problem with
PCs.
Maybe mac computers have a different default setting that could be
causing this problem?
Matt
--
PHP Database Mailing
Macintosh users can't log in on my web site.
I don't require anything unusual for log ins - simply a form with a user
id and password that queries a MySQL database.
The form is not encripted and I don't even use any security precautions
for the data transfer (users can't do much anyway).
After th
Anyone know a quick and easy way to fill in the address on a yahoo maps
form?
I want a link from my page to fill in all the details I already know so
my users don't have to enter it.
- Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
When I insert the following header:
header ("Content-type: application/vnd.ms-excel");
header ("Content-Disposition: attachment" );
I get the messages:
*Warning*: Cannot modify header information - headers already sent by
(output started at C:\Program Files\Apache Group\Apache2\htdocs\
I use Windows XP.
Really all I need to do is remove a single line in a pdf file and I
can't convince myself to spend $749 for Acrobat Pro to do it.
- Matt
On 7 Apr 2004, at 16:34, matthew perry wrote:
Does anyone know a free pdf editor?
what platform do you require it for?
--
Mike Karth
Does anyone know a free pdf editor?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Bar graphs are very easy to use with PHP. It's just a table columns of
varying height.
I wrote this a long time ago. To be honest it isn't very good code and
I think I got the ideas from someone else.
Regardless it should give you an idea.
You basically pass in an array of dollar amounts and
Does using a pasword input type
make the transfer more secure from someone "sniffing" my connection or
does it only shield an onlooker from seeing what the user enters?
- Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I am accumulating way to many PHP files in my home directory. It is
very difficult to sift through all the files.
I use a lot of "includes" and "requires" so it is difficult to organize
them in folders even if I change back a directory with my requires
using "..\".
Does anyone know of a bette
OK lets see if I can figure out how to ask this:
I am setting up a system for my company to filter through employee
applications. Most of the applications do not fit the criteria and I
want to allow my bosses a checkbox to the right of them which they can
check or uncheck to remove an applican
I am looking for the easiest way to export data to an excel file. Is
the easiest way to use PHP's file handling functions?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
l_escape_string().
http://phundamentals.nyphp.org/PH_storingretrieving.php
Regards,
Filip de Waard
Jimmy Brock
"Matthew Perry" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
I am trying to allow my users to enter quotes in their strings. For
instance instead of w
I am trying to allow my users to enter quotes in their strings. For
instance instead of writing:2 inch rod, they can write 2 " rod. The
problem is, of course, that " ends the string and all that is saved is
any value before the ". How do I get around this without using textarea?
--
PHP D
Hi Piotr,
Everyone else is suggesting edit all of the code.
Alternatively you could setup an iptables rule which forwards all
incoming requests on 127.0.0.1:3306 (or whatever port your mysql server
is running on) to 192.168.0.1:3306 (repolace 192.168.0.1 wit the IP of
your DB server).
This way if
p of your data
> fetching. You can probably get a boost by getting all the data into PHP
> first and then formatting and sending it to the client. At a minimum you
> should be able to determine if the client is the big slow down.
Matthew Vos
Systems Analyst
Product Developm
1 - 100 of 301 matches
Mail list logo
