I need to switch from MySQL (where everything is peachy) to Postgresql -
reason I need to switch is I need to use PostGIS and I don't see a need
to run two databases.
I got Postgresql installed (stock CentOS / RHEL 5) and installed the
postgresql php module and mdb2 driver. Restarted the web
Michael A. Peters wrote:
I need to switch from MySQL (where everything is peachy) to Postgresql -
reason I need to switch is I need to use PostGIS and I don't see a need
to run two databases.
I got Postgresql installed (stock CentOS / RHEL 5) and installed the
postgresql php module and mdb2
Michael A. Peters wrote:
Michael A. Peters wrote:
I need to switch from MySQL (where everything is peachy) to Postgresql
- reason I need to switch is I need to use PostGIS and I don't see a
need to run two databases.
I got Postgresql installed (stock CentOS / RHEL 5) and installed the
$getEnd = select a.ACCOUNTID as CONTRACT, a.BALANCE/1 as BALANCE,
b.STATUS, b.IMSI_ID as MDN, b.IMEI_ID as ESN, ;
$getEnd .= b.EQUIP_ID as MIN, b.MKT, b.MARKET_NAME ;
$getEnd .= FROM work.account_.$startDate. a ;
$getEnd .= JOIN work.customer_.$startDate. b ;
$getEnd .= ON ( b.CONTRACT_ID =
On Fri, Jul 25, 2008 at 1:55 PM, Jay Blanchard [EMAIL PROTECTED] wrote:
[snip!]
$endBal = mysql_fetch_array($dbEnd);
echo mysql_num_rows($dbEnd);
print_r($endBal);
Nothing gets returned from those last statements. Am I missing something
completely?
Right here
?php
// Code
[snip]
[snip!]
$endBal = mysql_fetch_array($dbEnd);
echo mysql_num_rows($dbEnd);
print_r($endBal);
Nothing gets returned from those last statements. Am I missing
something
completely?
Right here
?php
// Code before
if(!$dbEnd = (mysql_query($getEnd, $dbc))){
echo
On Fri, Jul 25, 2008 at 2:36 PM, Jay Blanchard [EMAIL PROTECTED] wrote:
I have several other queries running in this example and they all use
the same run/error check routine with no issues.
I'm sure you've already tried this, but did you copy the SQL query
echo'd out and try it directly
[snip]
I'm sure you've already tried this, but did you copy the SQL query
echo'd out and try it directly with MySQL to make sure there are rows
returned?
[/snip]
Yes.
*slaps forehead soundly* I found that there was a missing greater than
sign in a greater than or equal to requirement in an
On Fri, Jul 25, 2008 at 3:07 PM, Jay Blanchard [EMAIL PROTECTED] wrote:
*slaps forehead soundly* I found that there was a missing greater than
sign in a greater than or equal to requirement in an earlier query.
The most minuscule errors cause the greatest harm.
By the way, I didn't
On 7/25/08, Daniel Brown [EMAIL PROTECTED] wrote:
On Fri, Jul 25, 2008 at 3:07 PM, Jay Blanchard [EMAIL PROTECTED]
wrote:
*slaps forehead soundly* I found that there was a missing greater than
sign in a greater than or equal to requirement in an earlier query.
The most minuscule
[snip]By the way, I didn't mean to insinuate that your use of the
if()
condition was incorrect[/snip]
No worries.
[snip] Someone needs to whack me upside the head every so often. In my
case, that might be a patentable invention.[/snip]
I see you get whacked around the head here every so
On Fri, Jul 25, 2008 at 3:41 PM, Jay Blanchard [EMAIL PROTECTED] wrote:
I see you get whacked around the head here every so often...and if not
here I am sure that your SO handles it as needed.
Yeah, but she's in Virginia Beach for the week, so there's a
slight chance the bruising will
I have an extension that seems to create PHP variables correctly, and
var_dump() doesn't seem to have a problem. but upon moving to 5.1.x it
fails.
Anyone have a suggestion?
xmp xmldbx version='1.0'ycis_host t='a' R='1' C='2' cb='2' xag t='o'
nm='0' cn='classfoo' hostname t='sz' v='foo'//xagxag
Hello.
I am trying to get path/style variables working in windows with IIS on
a hosted environment. What I mean by path/style variables is the
following: Say I have a script test.php that can be accessed via:
http://mydomain/controller.php
...I want to pass variables to it like:
Ck wrote:
Hello.
I am trying to get path/style variables working in windows with IIS on
a hosted environment. What I mean by path/style variables is the
following: Say I have a script test.php that can be accessed via:
http://mydomain/controller.php
...I want to pass variables to it
Hi Richard.
Thank you for the reply. I was dragged to IIS kicking and screaming!
I have been doing php development for almost 6 years, and this will be
my first production-level experience with php through IIS...
Unfortunately it is a hosted environment and there is a legacy
coldfusion
I have something really wierd going on with a form that let's a user
add/edit/delete data from a mysql database.
It's like I can not edit any data that was not recently added or if it
was added by another user.
If I log into mysql directly under the same user I'm using form the php
script and
nevermind I got it.
snip
I have something really wierd going on with a form that let's a user
add/edit/delete data from a mysql database.
It's like I can not edit any data that was not recently added or if it
was added by another user.
If I log into mysql directly under the same user I'm
Warning: Invalid argument supplied for foreach() in
/usr/local/www/vhosts/pa.eastcoastbicycles.com/htdocs/mainfile.php on
line 42
Warning: Invalid argument supplied for foreach() in
/usr/local/www/vhosts/pa.eastcoastbicycles.com/htdocs/mainfile.php on
line 57
42: foreach ($_GET as $secvalue) {
Please use a DESCRIPTIVE subject!
On Monday 01 December 2003 02:51, Brian V Bonini wrote:
Warning: Invalid argument supplied for foreach() in
/usr/local/www/vhosts/pa.eastcoastbicycles.com/htdocs/mainfile.php on
line 42
Warning: Invalid argument supplied for foreach() in
Warning: Invalid argument supplied for foreach() in
/usr/local/www/vhosts/pa.eastcoastbicycles.com/htdocs/mainfile.php on
line 42
Warning: Invalid argument supplied for foreach() in
/usr/local/www/vhosts/pa.eastcoastbicycles.com/htdocs/mainfile.php on
line 57
42: foreach ($_GET as $secvalue) {
On Sun, 2003-11-30 at 18:45, Brian V Bonini wrote:
Warning: Invalid argument supplied for foreach() in
/usr/local/www/vhosts/pa.eastcoastbicycles.com/htdocs/mainfile.php on
line 42
Warning: Invalid argument supplied for foreach() in
On Sun, 2003-11-30 at 19:21, Robert Cummings wrote:
On Sun, 2003-11-30 at 18:45, Brian V Bonini wrote:
Warning: Invalid argument supplied for foreach() in
/usr/local/www/vhosts/pa.eastcoastbicycles.com/htdocs/mainfile.php on
line 42
Warning: Invalid argument supplied for foreach() in
Hello List,
The issue appears to be that no rows are being found with mysql_num_rows using the SQL
LIMIT offset. There should be rows found. Further, all processing just halts, and no
query is shown as per the code here:
// RUN THE QUERY TO RETRIEVE EACH FOUND RECORD
$queryResultHandle =
Can you give us the query too?
Alex
Hello List,
The issue appears to be that no rows are being found with mysql_num_rows
using the SQL LIMIT offset. There should be rows found. Further, all
processing just halts, and no query is shown as per the code here:
// RUN THE QUERY TO RETRIEVE
Hello everyone,
I am trying to execute a simple query using $_POST variables, so
that variable poisoning is not possible. note: I have register_globals
ON on my site. I am getting the error shown below . Please advise ...
as I can't seem to figure out why !
?
// connect to the BD/Table
On 2003-06-13 14:15-0400, Pushpinder Singh Garcha wrote:
I am trying to execute a simple query using $_POST variables, so
that variable poisoning is not possible. note: I have register_globals
ON on my site. I am getting the error shown below . Please advise ...
as I can't seem to
[snip]
$sql1 = INSERT INTO `contacts`
VALUES (
$_POST['company'],
$_POST['pri_name'],
$_POST['sec_name'],
$_POST['assistant_1'],
On Friday, June 13, 2003, at 02:22 PM, Zak Johnson wrote:
$_POST variables are still subject to poisoning; in your case, SQL
injection.
How is variable poisoning possible when using $_POST ?? I always felt
that the php compiler should check to see if the variable was part of
the POST Global
On 2003-06-13 14:42-0400, Pushpinder Singh Garcha wrote:
How is variable poisoning possible when using $_POST ?? I always felt
that the php compiler should check to see if the variable was part of
the POST Global array. At least this is is what I thought about the
$_POST global array.
It
On Saturday 14 June 2003 01:55, Global I.S. S.A. wrote:
The issue appears to be that no rows are being found with mysql_num_rows
using the SQL LIMIT offset. There should be rows found. Further, all
processing just halts, and no query is shown as per the code here:
// RUN THE QUERY TO
Sorry for so many questionsbut this should be the last
one for a while.
I have a form that I want to insert into a MySQL table. This
form is based on how many entries a user wants to enter. For example, a user
wants to type in 12 names, so 12 form fields appear. Or they want 50, 50 appear.
Do you require searching of this data eg... select via these numbers or
not??
Timothy Hitchens (HiTCHO)
Open Platform Consulting
e-mail: [EMAIL PROTECTED]
-Original Message-
From: Stephen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 9 January 2003 11:56 AM
To: PHP List
Subject: [PHP
: To: PHP List
: Subject: [PHP] Stumped...
:
:
: Sorry for so many questions but this should be the last one for a while.
:
: I have a form that I want to insert into a MySQL table. This form is
: based on how many entries a user wants to enter. For example, a user
: wants to type in 12 names, so 12
-
From: Stephen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 9 January 2003 12:00 PM
To: Timothy Hitchens (HiTCHO)
Cc: PHP List
Subject: Re: [PHP] Stumped...
I will later select them and display them to be edited, but
other then that, not really...
- Original Message -
From
PROTECTED]
Sent: Wednesday, January 08, 2003 9:09 PM
Subject: RE: [PHP] Stumped...
: What you can do it simply get the data and create an array serialise the
: array and sent it to
: the database ... the issue that arises from this is that you can't
: select if that record has
: 45 and 786 etc etc
List
Subject: Re: [PHP] Stumped...
How would I serialise it? I can make the numbers into an
array, but if I echo the array itself, I'd get Array and I
need the number in the db, not the word...
- Original Message -
From: Timothy Hitchens (HiTCHO) [EMAIL PROTECTED]
To: 'Stephen
PROTECTED]
To: 'Stephen' [EMAIL PROTECTED]
Sent: Wednesday, January 08, 2003 9:30 PM
Subject: RE: [PHP] Stumped...
: The issue with the serialise option is that is you have then in a row
: they are serialised
: and you can't do SELECT * FROM accounts WHERE num_rec LIKE '5' you
: would have
Don't write code which requires register_globals to be on.
$variable = $_POST['$var'];
-Original Message-
From: Stephen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 9 January 2003 3:03 PM
To: Timothy Hitchens (HiTCHO)
Cc: PHP List
Subject: Re: [PHP] Stumped...
Ok, I decided another
PROTECTED]]
Sent: Thursday, 9 January 2003 3:18 PM
To: Stephen; PHP List
Subject: RE: [PHP] Stumped...
Don't write code which requires register_globals to be on.
$variable = $_POST['$var'];
-Original Message-
From: Stephen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 9 January 2003 3:03 PM
I am trying to display a column from my database as a list. Each listing
needs to be a URL that links to another script that brings up all of the data
in the row to edit. I keep getting a parser error and I can't figure it out.
Here is the code and any help is greatly appreciated.
?php
$db
I am trying to display a column from my database as a list. Each listing
needs to be a URL that links to another script that brings up all of the
data
in the row to edit. I keep getting a parser error and I can't figure it
out.
Here is the code and any help is greatly appreciated.
?php
--- [EMAIL PROTECTED] wrote:
I keep getting a parser error and I can't figure
it out. Here is the code and any help is greatly
appreciated.
$sql = SELECT * FROM requests;
while ($result = mysql_fetch_array($query))
While this is not related to your parse error, it is a
major logic flaw,
--- Chris Shiflett [EMAIL PROTECTED] wrote:
--- [EMAIL PROTECTED] wrote:
I keep getting a parser error and I can't figure
it out. Here is the code and any help is greatly
appreciated.
$sql = SELECT * FROM requests;
while ($result = mysql_fetch_array($query))
While this is not
I'm going mad.
I've been trying to implement sessions so it will work backward on my
older 4.0.3 server ( I'm working on a 4.1.2), with no success as of yet,
but I think it's my 4.1.2 that's causing this, as the app in the
following example works perfectly on the older one.
Note, I have
In a file with functions only, one of the functions is structured like -
function foo()
{
if (isset($_POST['submit']))
{
/* DO SOME SQL */
header('location: x');
}
else
{
/* SHOW A FORM HERE */
}
}
I noticed today that when I turned off
Within the function before the header(), no there are no echo or print
statements.
I do have a few error checking that uses trigger_error() which displays
a page, but no errors are being triggered.
And just in case, I did check the error_handler file. There aren't any
'white space' before or
Are there any other reasons why header() would fail while output
buffering is off.
What's the error message? It tells you exactly what file and line number
started the output, so that's where you should look...
---John Holmes...
--
PHP General Mailing List (http://www.php.net/)
To
I've been using the following function successfully for months, tonight I
literally copied/pasted it to another page I was creating, called it exactly
the same using the same data type, and I'm getting an incorrect result. The
function is supposed to take a standard MySQL CCYY-MM-DD date format
function cleandate($indate) {
str_replace(-, /, $indate);
return date(F j, Y, strtotime($indate));
}
I suspect that you actually need something like this:
function cleandate($indate) {
$indate = str_replace(-, /, $indate);
return date(F j, Y, strtotime($indate));
}
Why don't you just use DATE_FORMAT() in your query, then you don't have
to do any extra PHP code at all??
---John Holmes...
-Original Message-
From: Jason Soza [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 3:50 AM
To: PHP-General Mailing List
Subject: [PHP] Stumped
John Holmes wrote:
Why don't you just use DATE_FORMAT() in your query, then you don't have
to do any extra PHP code at all??
you might want a link to that:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html - look
somewhat below the middle of the page
function cleandate($indate) {
-
From: Jesper Brunholm [EMAIL PROTECTED]
Date: Friday, June 21, 2002 2:02 am
Subject: Re: [PHP] Stumped on a function
John Holmes wrote:
Why don't you just use DATE_FORMAT() in your query, then you
don't have
to do any extra PHP code at all??
you might want a link to that:
target=lhttp
Hi,
I need to find a solution to this. I am lost. To see what I talk about
check vvmm.net/search.php3. I am using php 4 offline. Based on whatever
the viewer select I get the below script to build the select statements
accordingly. Everything is working fine now. I want to add another
Greetings,
I keep getting the message that I cannot get results. I have a simple
user authentication code that uses a mysql database to authenticate
from. Initially I had the code working when I had the mysql_connect
variables in the code itself. When I moved the connection variables to
an
Greetings,
I keep getting the message that I cannot get results. I have a simple
user authentication code that uses a mysql database to authenticate
from. Initially I had the code working when I had the mysql_connect
variables in the code itself. When I moved the connection variables to
an
I'd start by adding the mysql_error() function in your die() statement...
$result = mysql_query($sql,$connection) or die ("Couldn't get results: " .
mysql_error());
it might give more information to help you find the problem...
At 10:15 AM 3/8/01 -0800, Nicole Lallande wrote:
Greetings,
I
Thanks Joe - that showed me right away!! all better now -- on to the
next step..
Nicole
"Joe Sheble (Wizaerd)" wrote:
I'd start by adding the mysql_error() function in your die() statement...
$result = mysql_query($sql,$connection) or die ("Couldn't get results: " .
mysql_error());
it
On 3 Mar 2001 17:17:15 -0800, Brett [EMAIL PROTECTED] wrote:
I want to send a confirmation email upon receiving an order, and would like
to send the page that I display on the browser to the user.
ob_start();
// do something
mail('confirm@somewhere', 'confirmation', ob_get_contents());
This question may have been asked a million times, but I have had no luck
searching for a difinitive answer.
I want to send a confirmation email upon receiving an order, and would like
to send the page that I display on the browser to the user.
I can not figure out how to send a page, like the
This question may have been asked a million times, but I have had no
luck searching for a difinitive answer.
I want to send a confirmation email upon receiving an order, and would
like to send the page that I display on the browser to the user.
I can not figure out how to send a page,
use
$filearray =
file("http://www.yourstite.com/yourscript.php?some_vars=whatever");
then
$body = join (" ",$filearray);
mail($to $subject,$body);
or something like that. Maybe readfile() may be of use here to. You just
want to read the page in as a string, so make sure that you use some
From: "Brett" [EMAIL PROTECTED]
This question may have been asked a million times, but I have had no luck
searching for a difinitive answer.
I want to send a confirmation email upon receiving an order, and would
like
to send the page that I display on the browser to the user.
I can not
63 matches
Mail list logo
