variables. Unless the OCI8 extension calls apache_getenv those
declarations will have no effect.
regards
grant
--
Grant Croker - Ingres PHP and Ruby maintainer
http://blogs.planetingres.org/grant
Generally, old media don't die. They just have to grow old gracefully.
Guess what, we still have stone
where near the top of apachectl, I cannot tell you
exactly since fink will not install and MacPorts does not build SQLite3.
Restart apache and you should see the correct values in getenv() or
phpinfo().
regards
grant
On/El 16/03/09 12:13, Mark Halling-Brown wrote/escribió:
Hi Grant,
Thanks
questions
regards
grant
Ingres PECL maintainer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
]\,\$sel_row[23]\,\$
sel_row[24]\,\$sel_row[25]\,\$sel_row[26]\,\$sel_row[27]\\n;
}
/codesnippet
Thanks,
Grant Griffith
Web Application Developer
Enhanced Telecommunications
http://www.etczone.com
812-932-1000
-Original Message-
From: Alex Gemmell [EMAIL PROTECTED]
Date: 13/12/2005 14:07
Hello,
Hi
I'm experiencing some odd character encoding issues. My PHP webpage is
displaying test from a MySQL database. What happens is that I export
data from an SQL Server database to a MySQL
tried
inserting the following snippet into the table-generating php code, with no
luck:
while ($row = @ mysql_fetch_row($result))
{
foreach($row as $data)
if ({sum(number_o_beans)} (100))
print \n\ttd {$data} /td;
print \n/tr;
}
Thanks ahead of time for your thoughts and recipes :)
Grant
I'm very new to PHP so somebody correct me please if this is a bad
idea...
I had the same problem and I ended up just including the second page at
the end of the first one:
?php
// some stuff (output if necessary)
include 'nextpage.php';
die();
?
Grant
On Fri, 2003-05-30 at 09:43, Rick Dahl
Hi
I did actually encounter that problem. However, wouldn't redirecting
properly still allow the user to resubmit the information using the back
button? I solved this problem a different way by setting and clearing
session variables on entry and exit to a series of pages.
Grant
On Fri, 2003
PROTECTED]]
Sent: Thursday, January 23, 2003 8:21 PM
To: Grant, Dean (OIT); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] ms sql limit equivalence
I am just joining this list so if this has been covered in the past I
apologize. I am working with MS SQL and would like the functionality
that
MySQL's
Hi,
I am just joining this list so if this has been covered in the past I
apologize. I am working with MS SQL and would like the functionality that
MySQL's limit function provides. I understand that MS SQL has no such
command or equivalent. Has someone found a way to use standard (or MS SQL
-ucd-snmp-hack'
'--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath'
'--enable-shmop' '--enable-versioning' '--enable-calendar'
'--enable-dbx' '--enable-dio' '--enable-mbstring'
'--enable-mbstr-enc-trans' '--with-apxs=/usr/sbin/apxs'
Any help would be greatly appreciated.
-Grant
The different machine has nothing to do with the config, and everything
to do with the connect. It is in the connect string that you specify
which machine for PHP to connect to Postgres.
Joe Nelson wrote:
I'm trying to configure php so that it will have support for both MySQL
and Postgres.
Access has to be running on a Winders machine. At least the drivers.
Another option might be to migrate the data, and use ODBC and linked
tables to let Access still work temporarily, but really have the data
already transitioned.
Otherwise it is a weird linked ODBC bouncing off a Windows
I mostly agree, although I prefer PostgreSQL for the transactions,
better row locking, and server side cursors. It also does better with
lotsa users (if the data isn't just used for the web, this is
important). I have used many languages for this stuff, and the one with
the best balance of
Look in you apache.conf file and find out what user the web server runs
as, then give that user the right to write to that directory, probably
through a group used for nothing else is most secure.
Brian Mauter wrote:
To get around this, I made a small shell script which runs as root. The php
The web server user needs to have access to that directory. On NT,
there are 2 of these users. On *nix, there is one. Giving these users
access to write to that directory is not a huge risk.
koelwebdesign wrote:
hi there,
I've searched the lists and forums for a couple of days now but
recommendations?
--
==
Grant Boggs
http://www.cornersonesoftware.ws
--
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]
(headers?)
/var/lib/mysqlwhich has the server/engine stuff
/usr/local/php-4.0.6/ext/libmysql/ which appears to have more '.h' files.
Do a
locate mysqld
And see what that pops up. If you did it by rpm, mysql is probably in a
/etc/mysql directory.
--
======
Grant Bo
Grant Boggs [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Does anyone use the Zend IDE for development?
My code is getting complicated enough that I need a step-execute
capable
debugger. Where I can set breakpoints, watches, etc. The nor
This does not sound like a MySQL problem, but more likely a poor indexes
problem. PostgreSQL does scale bigger than MySQL (more users) but you are
probably nowhere near that limit. When you have more than 25 concurrent
users (remember that the web server is probably only one or 2 unless it is
ling now... heh
--
======
Grant Boggs
http://www.cornersonesoftware.ws
--
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]
Grant Boggs [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Steve Brett [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
no need to recompile.
the debug server is a .so and only needs added lines php.ini
indefinitely. The web page loads as normal BAH!
--
==
Grant Boggs
http://www.cornersonesoftware.ws
--
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
The most useful schema would be to have the name of the document be system
generated, like i123456789.img and make the database as follows:
Image
Image_Name varchar(50) primary key
Original_Name varchar(50)
Description text
User
User_ID int8 primary key
Login char(8) uniques index
password
Hi,
I have this code after a user submits a form with name, description and
image file upload fields:
images/people/preview is simply a unix link to /tmp/phptempimg-ian.grant
The problem is, when this script is run, the image show is that from the
previous operation. If you refresh the page,
On Wed, 22 Aug 2001, Tim O'Brien wrote:
What is the best method to move data from access tables to postgreSQL?
Are there are php functions that are available?
Unfortunately, only Access reads Access very well, but you can use ODBC
and linked tables in Access to copy it to PostgreSQL.
--
value, write it back, then use that key to insert into the
main table?
--
==
Grant Boggs
http://www.cornersonesoftware.ws
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact
nks guys!
--
======
Grant Boggs
http://www.cornersonesoftware.ws
--
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]
mysql_insert_id([resource link_identifier]) returns the value of the
auto_increment field for the previous INSERT query. It will return 0 if
there is not an auto_increment field. If the link_identifier is not
specified, the last opened connection is used.
So, use $id = mysql_insert_id();
= $row[0];
return $id;
}
Ian.
Ian Grant [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
mysql_insert_id([resource link_identifier]) returns the value of the
auto_increment field for the previous INSERT query. It will return 0 if
there is not an auto_i
That Resource ID #2 is the connection or result set. You need to use the
connection to do a query, which returns a result set, then use the result
set to do fetches. Those will return an array of the stuff you really
wanted.
This uses PostgreSQL, but the concepts are the same for MySQL.
On Fri, 17 Aug 2001, Alex wrote:
Could you give me an example?
Grant wrote:
That Resource ID #2 is the connection or result set. You need to use the
connection to do a query, which returns a result set, then use the result
of the textarea tag would be
better, considering the users are not going to be HTML-proficient.
However, I cannot seem to find anything like this that doesn't cost loads.
Does anyone know of anything similar?
Thanks,
Ian Grant.
--
--
PHP Database Mailing List (http://www.php.net
Perrin wrote:
== $connection = pg_connect($constr user='$USER' password='$PW');
Actually It should be closed the connection after access finished, like that
pg_close();
== pg_close($connection);
But if the user force to close the web page that means have not close the
connection. I
Yes, thank you, this works!
Ian.
Paul Burney [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
on 8/10/01 7:50 AM, Ian Grant at [EMAIL PROTECTED] wrote:
I've got a simply search form, on my site using PHP and MySQL.
It writes a SELECT query usi
Hi,
I've got a simply search form, on my site using PHP and MySQL.
It writes a SELECT query using WHERE (Field LIKE '%thingy%') where thingy
is the word entered in the form. It works fine if the submit button is
pressed, but if you press return after typing the word, instead, it fails
and
Another possible solution (although more drastic) is to switch DBMS's. I
use PostgreSQL with no troubles. However, 6.5 and earlier are not so
great performance wise. 7.0.3 is OK, and 7.1.2 is exceptional. It also
now (finally) supports outer joins and write ahead locking.
If you are at the
2 ideas:
1) Define the loosest item that returns results (likely regex) then search
with slightly tighter criteria within the results.
Good for situations where even partial matches are a small percentage of
the total data
2) Check every record, and give it a score based on proximity to the
Eric Marenyi wrote:
I am trying to develop a dynamic website, but I dont have the capability to
use SQL, or Access databases, can I use PHP to interface with a different
type of database?, maybe a text delimited, or something, please help, thanks
--
Eric Marenyi
CEO Virtual British
On Fri, 3 Aug 2001, Robert Fitzpatrick wrote:
Hello:
I configured PHP originally --with-mysql and now I want to also use
PostgreSQL with PHP. Can I just re-run the './configure --with-mysql
--with-pgsql --enable-track-vars' again. Then do another 'make' and 'make
install'?
Thanks for the
Hi,
Can anyone help me with this - I have a database of people, that I want to
print into an HTML table - how can I make the table wrap into an equal
number of rows.
i.e. if there are 4 entries, a 2x2 table, 6 a 2x3, 8 a 2x4, 9 a 3x3, etc.
At the moment, I have something like:
Yeah, but if I had 31,
I'd want 6x5 and then 1 over, or something
Hugh Bothwell [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Umm... 31 entries, 1 x 31...
You might be better to choose a standard width and pad the last row with
empty cells.
I
Sorry I am not replying to the thread. I deleted the message, not
thinking.
If you install PostgreSQL from source, and take the defaults, it puts
its files in /usr/local/pgsql/... Each of theses subdirectories
matches one in /usr/local/... What I do is create symlinks win
/usr/local so I
Hello all
Is there any way of using a string in an SQL query instead of using the
table name. Something along the lines of
$result=mysql_query("SELECT * FROM $tablename",$db);
this doesnt work it come up with a parse error
thankyou
Grant
--
PHP Database Mailing List (http://w
the purpose of the dynamic pages
somewhat... pity.
Any other ideas? How do others deal with this issue?
Regards
Grant
---
Grant Ballard-Tremeer,
HEDON Household Energy Network http://www.ecoharmony.net/hedon/
eco Ltd. http://ecoharmony.com
---
--
PHP Database
45 matches
Mail list logo