Hallo!
I'm trying to read lo objects (images) from postgreSQL using php's
pg_loreadall() function with the intention of put them dirctly on a html
document, but I can't. I also have problems about how to embed the result of
the pg_loread() on a html document.
Somebody can help me?
Thak you very m
JOIN
tbl_zuordnung_autoren_medien ON
[tbl_autor].[autorenID]=[tbl_zuordnung_autoren_medien].[autorenID]) ON
[tbl_medien].[medienID]=[tbl_zuordnung_autoren_medien].[medienID]
WHERE ((([tbl_medien].[medientypID])='$medium'));
Thanks,
Patrick
Patrick Schäfer
magna moliri
Projektmanagementgesellsch
I have PHP compiled with OOB and Apache on one of my Linux bxes and it works
great. My problem is that I need to run PHP w/ OOB on a second box as a
stand alone app.
Here is a sample script:
#!/usr/local/bin/php
Here is the error:
X-Powered-By: PHP/4.0.4pl1
Content-type: text/html
Warning:
to duplicate code.
Including a CSS :)
--
=======
Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/
Now to him who is able to do immeasurably more than all we ask
or imagine, according to his power that is at work within us, to
him be glory in the church and in Christ Jesus throughout all
g
So it sounds like you need to examine the headers of the response (which
sounds like it is a redirect)?
Try PEAR's HTTP_Request (http://pear.php.net/package/HTTP_Request).
p.
> --
> From: Chris Payne
> Sent: Wednesday, April 21, 2004 12:52 PM
> To: [EMAIL PROTECTED]
> Su
GH wrote:
Greetings:
This is just a friendly reminder that if you are registered in the
United States to VOTE on November 2, 2004 (TOMORROW)
Need to know where you vote?
Please see the attached file (it is an image) that contains some information
Do we care? Realy? Unlikely. Maybe you should s
cts .= "" . $results["CREATED"][$i] . "";
$objects .= "" . $results["LAST_DDL_TIME"][$i] . "";
$objects .= "\n";
}
return $objects;
}
?>
Web Administration Tool for ORACLE Databases
http://esorclupg/backgrnd.gif&q
hi.
i'm storing events in a mysql-db, using epoch timestamps to pinpoint the
exact date/time for an event.
so far, I have been using localtime, being aware that there are
inconsistencies
in the number of epoch-seconds, when DST flips on and off. nevertheless, that
works fine as long as you
actually works.
anyone? (please cc:)
greets,
patrick./
DL Neil wrote:
>
> Hi Patrick,
> [I have put this back on the list, because greater minds might come up
> with a better explanation!?]
>
> There appears to be an issue with "gm" time functions. gmmk
;INSERT INTO your_table VALUES';
for ($i=0; $i<100; $i++)
{
if (!$first) $query .= ', ';
$query .= ' (0,1,2,3)';
$first = false;
}
mysql_query($query); // only one insert statement
Hope that helps,
Patrick Emond
- Original Message -
From: "Leif K-
n doesn't call
PHP_SELF with the updated values.
Thanks in advance. Apologies to anyone who is upset at the 9k attachment.
Patrick
DROP TABLE IF EXISTS people;
CREATE TABLE people (
person_id tinyint(4) unsigned NOT NULL auto_increment,
first_name varchar(30) NOT NULL,
last_name va
contacts.php appears to have been chewed up ... fresh copy.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Patrick Kirk said: Good Lord - its eaten contacts.php again!
Contacts//
>Contacts /
?grouping=> /
does
not explain your time problem, but it is my 2 cents before you place to much
stuff in global variables.
Thanks and regards,
Patrick
- Original Message -
From: "M1tch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 11, 2002 8:36 PM
Subject:
Is there a mysql or array variable for the current row of a query array?
I want to alternate background colours for each row of the query output so i
need to know the current row number.
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.
$row with BG color of red;
> }
> else
> {
> printf $row with BG color of purple;
> }
> }
>
> HTH
> -Brad
>
> Patrick Lebon wrote:
>
> > Is there a mysql or array variable for the current row of a query array?
> > I want to alternate
Thanks for your help. As i said im quite new to php so all your help in
simplifying my code has been appeciated.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
- Original Message -
From: "Diana Castillo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 28, 2002 10:02 AM
Subject: [PHP-DB] export to csv file
> Hi, I want to export some fields on a regular basis from a table to a text
> file, preferable to the users local com
Greetings:
I currently am using the fgetcsv function to read in fields from a
user-defined file. The delimited file is read and displayed just fine.
Firstly, what I'm trying to accomplish: The MySQL database has a table
with about 30 fields. The user-defined file may contain only some
is is line 7 of my
script
$select = mysql_select_db("intranet", $db);
Thanks,
Patrick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
.
The only reliable way I can see of being able to retrieve the data is to use
numbered rather than fieldname references. It only seems to apply to a few
fields and is without logic, since in some cases it does dereference
correctly.
--
t;mysql_select_db("intranet", $db);
> or die ("Sorry something is wrong");
>
>That what I use
>
>That really might be the problem..
>
>
>Learn how to put in debug stuff. It's easier to see your
>mistakesI know I had a bunch...
>
haven't found any dll named *sybase* for Windows. Is there any way of supporting
>Sybase?
There is a DLL in extensions calls php_sybase_ct.dll
You either need to compile in support for sybase with PHP or dl a dynamic
library.
--
===
oblem with confusion of the names of the
fields. I will try rewriting my query.
--
=======
Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/
Do not be anxious about anything, but in everything, by prayer
and pet
query specification, select duplicate field names individually and
use the AS keyword to specify a name that doesn't have an underscore in it.
2. Change any table field names that have underscores to remove them.
--
====
Anyone have experience using Ingres with PHP & Ingres.
I can't find any documentation on the area.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL
HI,
I have compiled php4 with the following command:
./configure' '--with-mysql' '--with-apache=../apache_1.3.20'
'--enable-track-vars' '--enable-tans-sid' '--enable-dba
The function dba_open() does not work for me. I get the following error
message:
Fatal error: Call to undefined function: dba
t open shared object file: No such file or directory in /home/pat/html
I did a 'find / -name php_dba.so' and came up with nothing.
Thanks in advance for any help.
"Hugh Bothwell" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
line
in the php.ini file and it now recognizes the dba_open() function call.
Now it gives me this error message:
Warning: driver initialization failed in db.php on line 6
and it does not open the database.
Any and all help are greatly appreciated.
Thanks,
Patrick
"Patrick Callihan&quo
With the help of another friend, I now have it working. The problem was I
needed to make the directory and file group apache and then give them both
group write permission. It works! I thought I would post this in case
someone else ran across the same problem.
Patrick
"Patrick Cal
Bona,
You are trying to perform an SQL*PLUS command. I think
you can only perform SQL commands with OCI. You can
print a ref cursor in SQL*PLUS but you have to handle it
differently with OCI. Look at the PHP reference manual for
ocinewcursor.
Good Luck,
Pat
[EMAIL PROTECTED] wrote:
> Hi aga
n during SELECTs.
More informations on http://www.mysql.com/doc/G/R/GRANT.html
Which version of phpMyAdmin are you using ?
Patrick
--
Patrick Guillot mailto:[EMAIL PROTECTED] - +33 (0)6 08 41 11 54
Online Development - Paanjaru http://www.paanjaru.com
Riding the Shockwave in cyberspace, for no
ould be greatly appreciated.
Thanks very much,
Patrick
---| patrick gibson |---+
email: email @ patrickg.com
url: http://patrickgibson.com/
+
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additio
s there's not really any
great way of protecting database connection information on a shared server?
Patrick
---| patrick gibson |---+
email: email @ patrickg.com
url: http://patrickgibson.com/
+
--
PHP Database Mailing List (http://www.ph
happen to be that root user. :) But it still is a shared
server with other users each having access to the system. I've setup MySQL
so that each user has access to only their database -- they cannot connect
to any other database on the system.
Patrick
---| patrick gibson |-
I've been running a PHP4 script on a Linux server every day for quite a
while now. All of a sudden, it stops working. The error message is:
[ODBC SQL Server Driver][SQL Server]The cursor was not declared.
What does this mean and how can I fix it? Nothing has changed as far as I
know. Nobody else
I just tried installing MDAC 2.7 on my SQL Server, based on another user's
recommendation. That didn't resolve the problem.
Any other ideas?
Thanks,
Pat
"Patrick Brown" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
whatever common element or key you have in both tables
(this may be the title of the book, or a book ID, etc)
- Patrick
- Original Message -
From: "George Pitcher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2002 8:37 AM
Subject: [PHP-DB] 1
eq will be
set to false, so checking that before using it as an array is a good idea)
- Patrick
- Original Message -
From: "James Kupernik" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2002 12:05 PM
Subject: [PHP-DB] Resource id #2
I have the following setups:
*PostgreSql 7.3.1 and MSSQL on Win2k server (A)
*Apache 1.3.x + PHP 4.3.1.1(using CGI & loaded w/ php_pgsql.dll) + ODBC for
PostgreSql v7.02.00.05 on Win2K server (B)
I tried to use phppgadmin 2.4.2 and odbc for postgresql to connect
PostgreSql in (A) but both connec
tcpip_socket is enabled!
access to postgresql is granted; ip-address is added to pg_hba.conf - METHOD
= trust
./pl
"Patrick Lok" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I have the following setups:
> *PostgreSql 7.3.1 and MSSQL on Win2k server (A)
There is no firewall within the LAN environment.
I tried the mssql_connect too using mssql_connect("testdb","sa","") but same
error returned!
Any idea?
./pl
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Wednesday
ROTECTED]
Possibly the db-server is accepting only localhost connections.
Niklas
-Original Message-
From: Patrick LOK [mailto:[EMAIL PROTECTED]
Sent: 12. maaliskuuta 2003 14:39
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP] Re: [PHP-DB] How to Connect remote DB server?
There is n
for the field name, and I made use
of the ibase_blob_info() function:
$blob_data = ibase_blob_info( $row->METADATA );
$blob_hndl = ibase_blob_open( $row->METADATA );
$content= ibase_blob_get( $blob_hndl, $blob_data[0] ));
ibase_blob_close( $blob_hndl);
Hope this has some hints,
Patrick May
It is possible to connect a remote db server using x_connect?
e.g. a PostgreSQL in server PSQLDB, ip=192.168.0.100 and a MSSQL server MSSQLDB,
ip=192.168.0.110
I tried pgsql_connect("psqldb","administrator","") &
pgsql_connect("192.168.0.100","administrator","") but failed!
Error is "Unab
has pointed me towards firebird / interbase:
http://firebird.sourceforge.net/
~ Patrick
Hi,
Using PHP 4.2.2 with Oracle 8. Can someone provide the code for reading a
BLOB from a Oracle database? I cannot find it anywhere in the archives.
Thank you.
Patrick Cossette
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
InterBase: binding (may take a while) [ext/interbase/tests/006.phpt]
=
And when I try to load the libphp4.so module, Apache silently dies. Any
ideas?
Thanks in advance,
Patrick May
Does anyone know where there is a good chat room with PHP developers?
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.0 - Release Date: 4/29/2005
i'm running php "PHP Version 5.1.6-pl6-gentoo" and have run into a bit
of a snag with pdo prepared statements and parameters. we use
parameters in all our queries, but just recently tried to add limits to
some of the queries so we can do paging. when attempting to add a
parameter to the limit sec
r any help.
Patrick
I think I will have to use a second script on mysql server since (I forgot
to mention) the database is replicated and that seems like the best option.
Thanks for the help
patrick
On Sat, Oct 25, 2008 at 2:14 PM, Nitsan Bin-Nun <[EMAIL PROTECTED]> wrote:
> Umm you can convert it to fi
t the problem and
changed the db connection but I was wondering if there is a php function
and/or mysql function that can be run from php to find out the privileges
for a particular db connection. Any ideas?
PHP Ver. 5.2.1
MySQL Ver. 5.0.27
on Linux
Thanks
patrick
Hey Frank,
I wasn't able to run the query:
select * from mysql.user where concat(user, '@', host) like (select
CURRENT_USER())
because I didn't have privileges to view the table, but I was able to root
around the INFORMATION_SCHEMA table and find what I needed.
thanks!
pa
ed from the
database since that will affect the row values when you are assigning them
to variables (ie- if the day is returned first in the array it should be "
$day = $row[0]" )
Hope that helps
Thanks
patrick
Sent from: Decatur Ga United States.
On Sat, Feb 14, 2009 at 12:05 AM, S
I believe your problem is that on line 33 you forgot your closing double
quote in the echo statement.
Thanks
patrick
Sent from: Decatur Ga United States.
On Fri, Feb 13, 2009 at 10:02 PM, Sashikanth Gurram wrote:
> Hi all,
>
> I have pasted the PHP code I wrote below. I do not know
I've had no success trying to execute any stored procedure from php.
I'm just trying to follow the example for multi-query in the php manual,
and have tried an example from Artfulsoftware.com. I have one input and
one output parameter. I've simplified the stored procedure to always
output one v
Bastien Koert wrote:
On Mon, Jul 13, 2009 at 11:52 AM, Patrick Moloney wrote:
I've had no success trying to execute any stored procedure from php.
I'm just trying to follow the example for multi-query in the php manual, and
have tried an example from Artfulsoftware.com. I have one inp
Bastien Koert wrote:
On Mon, Jul 13, 2009 at 1:33 PM, Patrick Moloney wrote:
Bastien Koert wrote:
On Mon, Jul 13, 2009 at 11:52 AM, Patrick Moloney
wrote:
I've had no success trying to execute any stored procedure from php.
I'm just trying to follow the example for multi-query
print '
' . $row['first_column'] . '
' . $row['second_column'] . '
' . $row['third_column']/60 . '
' . $row['fourth_column'] . '
' . $row['fifth_column&#x
code to access that data in my code, whereas your code you wouldn't
need to add any more code.
Thanks
patrick
On Wed, Jul 15, 2009 at 1:40 PM, Don Collier wrote:
> Would that work for multiple rows though? This is getting a varying number
> of rows.
> Patrick Price wrote:
>
~90% decrease in reading data from the database. Performing aggregate mysql
functions for most commented and etc are generally very fast and can be done
much more quickly than retrieving the whole article, passing to php, storing
to memory and then manipulating the data.
Thanks
patrick
2009/8
need to be concerned about SQL injection attacks, you should always
escape any data being used in a query.
http://us.php.net/manual/en/security.database.sql-injection.php
Hope this helps.
Thanks,
patrick
On Fri, Sep 4, 2009 at 5:07 AM, nagendra prasad wrote:
> Hi all,
>
> I am worki
down
weekly.
I had to rewrite the entire image upload/retrieval system for their site to
change it to folder based storage.
Just my thoughts...
Thanks
patrick
On Wed, Feb 3, 2010 at 8:02 AM, Phpster wrote:
> Sure is. Save the data in a blob field. Lots of examples on the net on how
&
According to php.net, if you don't specify a link iedentifier it closes the
last nonpersistent connection.
http://us3.php.net/mysql_close
Patrick
-- Sent from my Palm Pre
Ron Piggott wrote:
Does mysql_close() close all open database connections?
How would I specify which connecti
How is the last mailing date variable set?
Have you tried printing out the queries that are run when it is run manually
and when it is run as a cron to find any differences?
-patrick
On Jul 11, 2010 8:23 AM, "Ron Piggott"
wrote:
I am trying to write a query to select a trivia quest
66 matches
Mail list logo
