$TNS_ADMIN=/home/beckman/oracle/network/admin
If those aren't set, then things won't work.
Please confirm that those environment variables are set in Apache or
whatever web server you are using. If they aren't, oci8 won't work.
Beckman
On Fri, 16 Jul 2004, Adam Williams wrote:
Hi, I
Hi, I'm trying to connect to an oracle 9.20 database using:
$conn = OCILOGON("dah50","dah50","zed2.aleph0");
but I get the error ORA-12154
Searching on google says my listener.ora or tnsnames.ora may have
problems, but I think mine are correct. Can someone take a look and see
if they are ok?
110) BETWEEN '$startdate' and
> > 'enddate'
> > and type = '1'
> > group by date
> >
> > In MySQL you don't need to specify a field for count(). And you should
> > have to convert the eventime field twice, you should be able to
&
.eventime, 110) BETWEEN '$startdate' and
> 'enddate'
> and type = '1'
> group by date
>
> In MySQL you don't need to specify a field for count(). And you should
> have to convert the eventime field twice, you should be able to
> reference th
Yeah I basically had that with my previous SQL statement, I was grouping
by event.cardnum instead of counting the cardnums by date. I think what
I'm trying to do is beyond the scope of SQL and I'll have to write some
PHP to take the SQL statement results and feed them into an array and
count t
I see it, the hardest part is
> converting the eventime to a date or some unique string to represent
> the date.
>
>
> On Apr 21, 2004, at 1:13 PM, Adam Williams wrote:
>
> > I'm using some proprietary software/hardware where when a visitor
> > swipes
>
I'm using some proprietary software/hardware where when a visitor swipes
their entry card, it is recorded in a mssql 2000 server. My boss wants a
count of unique vistors for a range of dates. So, I need to have it give
a count of unique vistors, meaning that I need to count all vists for a
da
Hi, I know this isn't PHP related but I have a quick question about
postgresql. I come from a mysql enviroment so I'm a little clueless, even
after reading the postgresql docs.
I am moving a postgresql database from one server to another. As the user
that owns the database, lculber, I ran p
Hi, I have oracle and PHP working together on a remote server called zed
that runs redhat linux. I have another computer called accessserver
that runs win2k pro with PHP that I am trying to connect to oracle on
zed. Both computers have the oracle client libraries installed. On
accessserver I
I've used mysql a little, but now I'm working with a MS SQL SERVER 2000
database. We have a proprietary application/hardware setup where
when a person enters the building, the time they enter the building
is automatically put into the database in a field called eventtime, and
their access card
Hi, I have an SQL statement that is ran when data is submitted through a
form. When someone types in a word with an ' such as farmer's the SQL
statement fails. I tried $_POST[data] = addslashes($_POST[data]); before
executing the SQL statement, but the statement still fails. any
suggestions?
How do I compile PHP on Unix to have oracle 9 support. Looking at
./configure --help and PHP's website, I see no option for oracle 9
support. I see --with-oci8 but that appears to only work for Oracle 8.
Any help? Thanks!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, v
Hi, I was wondering if anyone has seen this informix error before. It has
me stumped. Searching on google didn't reveal anything. Running my query
in informix returns the proper results, so I'm not sure what the problem
is.
Warning: ifx_fetch_row(): 4 is not a valid Informix Result resource
uot; it won't return that
result, but I want it to because the person using the db is looking for
all the fields that contain holmes, north, and carolina.
CPT John W. Holmes wrote:
From: "Adam Williams" <[EMAIL PROTECTED]>
CPT John W. Holmes wrote:
From: "Adam Wi
I'm using Informix SQL. Do you know how to do full text searching on
Informix? If so, please share the details :)
Jay Blanchard wrote:
[snip]
I am selecting a field in a database called description for keyword
searching. The field contains names of people, states, years, etc.
When
someone s
I'm doing a fulltext search.
CPT John W. Holmes wrote:
From: "Adam Williams" <[EMAIL PROTECTED]>
I am selecting a field in a database called description for keyword
searching. The field contains names of people, states, years, etc. When
someone searches for say "
Hello,
I am selecting a field in a database called description for keyword
searching. The field contains names of people, states, years, etc. When
someone searches for say "holmes north carolina" the query searches for
exactly that, fields which have "holmes north carolina", and not fields
t
use system() to run /bin/df
depending on the OS you might need to add a flag to it like -h (linux) or
-k (solaris).
www.php.net/system
Adam
On Fri, 27 Dec 2002, Dankshit wrote:
> Is there a way to see how much space is left in a ftp server?
>
> thanks in advance!
>
--
use mysqlimport, its a program that comes with MySQL. go to www.mysql.com
and click on documentation to learn more about it.
Adam
On Fri, 13 Dec 2002, mikek wrote:
> I have a few hundred rows of data to import into a mysql db. Its currently
> tab separated.
>
> What's th
Mon, 9 Dec 2002, Alex Francis wrote:
> Adam, You are correct.
>
> I had two NICs, set up exactly as you describe, but kept getting problems (I
> would lose my internet connection and have to reboot to get it back. I think
> I will try againand if that fails, buy a cable modem ro
No I think he has his WS with a real IP from his ISP and then his web
server plugged into the same hub as his WS but with 192.168.1.1. He'll
either need to get a 2nd NIC and give it an ip like 192.168.1.2 or get a
cable modem router. Or change his WS to linux and add eth0:0 with
192.168.1.2 :)
can you ping your router? is it filtering ICMP? can you ping anything?
is your cat 5 cable crimped properly and you have link lights on your
switch/hub/router and network card?
Adam
On Mon, 9 Dec 2002, Alex Francis wrote:
> It seems like a network problem. I can access
can your main workstation ping 192.168.1.1
On Mon, 9 Dec 2002, Alex Francis wrote:
> At last I have Apache and PHP running on my server.
> My server IP is 192.168.1.1 and I have set ServerName 192.168.1.1 in my
> httpd.conf file.
>
> I can access my test files from the server using either http://
www.php.net/isset
if !isset($var)
{
echo "var is not set to anything";
}
else
{
echo "var is set to $var";
}
On Mon, 9 Dec 2002, Edward Peloke wrote:
> Hello all,
>
> I have a login/register screen for my php/mysql db. When the page opens,
> the user sees the log in screen but I have a button
use GROUP BY field
Adam
On Fri, 6 Dec 2002, Doug Coning wrote:
> Hi everyone:
>
> How do I get MySQL to summarize a query so that I receive only 1 instance
> per similar record. I.E. if you have 10 records with name "Smith" and 5
> records with "Barney, etc, that it woul
Have you ran it by hand in MySQL from the command prompt with some test
data and gotten an error?
Adam
On Tue, 12 Nov 2002, Steve Dodkins wrote:
> if i have a statement
>
> $result = mysql_query("SELECT
> labor_id,labor_ord_no,labor_wkyr,works_orders_part_no,works_orders_
I'd go back to apache 1.3.27 and php-4.2.3 if I were you and see if that
fixes your problem.
I run Informix, PHP, and Apache on a server and have had no problems.
Adam
On Mon, 21 Oct 2002, Erwin Speybroeck wrote:
> Hi,
>
> I'm struggling with a problem for quite some tim
search around for phpmyadmin on google
Adam
On Wed, 2 Oct 2002, Brett Lathrope wrote:
>
> Ok, here's my scenario...
>
> My Web Host has all Root Admin control over MySQL and PHP configs (but they
> are setup well no complaints there)...I simply have access to 1 DB (alrea
why not
if (!($1%2))
{
echo "even!";
}
else
{
echo "odd!";
}
Adam
On Thu, 26 Sep 2002, Brad Bonkoski wrote:
> oops...
>
> I meant:
> (if $i is odd)
> ...
>
> because $i would be the current index in the array.
>
>
> Brad Bonkoski wrote:
>
> > why not this?
> >
> > $result = mys
www.php.net/stripslashes
Adam
On Wed, 18 Sep 2002, Jason Vincent wrote:
> Hello,
>
> New PHP (long time PERL user) here. I am using an Access database -
> yeah I know Access is crap, but I have no choice. Anyway, it seems that
> this magic backslash thing is unav
He's using microsoft sql server, not mysql.
try --with-mssql
maybe?
Adam
On Wed, 18 Sep 2002, Jason Morehouse wrote:
> It means you haven't compiled mysql support into php. Recompile it using
> --with-mysql
>
> --
>
> Jason Morehouse (jm[@]netconcepts[.]com)
> Auckland
actually make that system("df -h");
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Tue, 17 Sep 2002, Bo wrote:
> Any ideas of how to write a php script to determine the disk space left in
> my account at my web server?
>
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
look in /etc/httpd/conf/httpd.conf
when you restart apache (/etc/rc.d/init.d/httpd restart) it restarts php
because php is called by apache.
Adam
On Thu, 12 Sep 2002, Warren Massengill wrote:
> RedHat Linux 7.2 RPM installation included:
> PostgreSQL 7.1.3
> PHP 4.0.6
>
Yes but support is experimental so you may notice strange behavior.
Adam
On Sat, 7 Sep 2002 [EMAIL PROTECTED] wrote:
> Is it possible to run Apache 2.X with PHP?
>
>
>
> Julio Cuz, Jr.
>
> [EMAIL PROTECTED]
>
> Information Services
>
> Riverside Community College
>
>
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
Adam
On Sat, 7 Sep 2002, Bryan McLemore wrote:
> Hi Guys I have written this SQL Query :
>
> CREATE TABLE tasks (id INT AUTO_INCREMENT, name VARCHAR(50), desc TEXT, address
>VARCHAR(50), startDate DATE, lastWork DATE, progress
1:
http://quanta.sourceforge.net/
2:
yes
Adam
On Fri, 6 Sep 2002, Bryan McLemore wrote:
> First off, What html/php editor do you guys think is better?
>
> Secondly, perhaps a little more relevant to the database part of this. I just want
>to clarify that with mysql_q
ateus Cordeiro Inssa wrote:
> Em Qui, 2002-08-29 às 17:48, Adam Williams escreveu:
> > Apache can execute a file without reading it. Don't believe me? Make a
> > file 701 and then open it in apache.
>
> Oh, yes, so can apache bypass the kernel ? I don't think so, unless
Apache can execute a file without reading it. Don't believe me? Make a
file 701 and then open it in apache.
Adam
On 29 Aug 2002, Mateus Cordeiro Inssa wrote:
> Em Qui, 2002-08-29 às 16:05, Adam Williams escreveu:
> > oh yeah duh
oh yeah duh me, set it 701
Adam
On Thu, 29 Aug 2002, Ryan Jameson (USA) wrote:
> Wouldn't that make php unable to read it as well? Then it is useless as well.
> <>< Ryan
>
> -Original Message-
> From: Adam Williams [mailto:[EMAIL
set you to owner of the script and then chmod 700 it
Adam
On Thu, 29 Aug 2002, Smita Manohar wrote:
> hii
> im using php script with mysql. i want to hide the script from the admin or
> from the person who has privileges to access all the data. bcos i use ftp to
> upload
restart apache
Adam
On Thu, 29 Aug 2002, James Hatridge wrote:
> HI all...
>
> I'm at my end, would some kind soul please help? I'm working on a database
> using SuSE 8.0, mysql, and PHP. All the standard installs.
>
> I need to use exec, unlink, etc. BUT the durn PHP is
read mysql.com's documentation on the GRANT command. Or install
phpmyadmin and use that.
Adam
On Thu, 29 Aug 2002, Leif K-Brooks wrote:
> I need to add mysql users to some databases, but my dumb control panel
> (ensim) doesn't seem to have a feature to do that, and I'm
In your connect statement, you aren't selecting a password and TCP port to
connect to. You made need to specify those.
Adam
On Tue, 27 Aug 2002, Brian Noecker wrote:
> Hey everyone, got a problem here. I'm using php4.2.1, postgres 7.2. I'm
> trying to do a simple data
look at http://www.php.net/manual/en/function.pg-connect.php
do you have postgresql starting with the -i paramater so that it is
listening on a TCP port? PHP needs this to be able to connect to
postgresql.
Adam
On Tue, 27 Aug 2002, Brian Noecker wrote:
> Hey everyone,
View the source in mozilla, it might just be suppressing the output
for whatever reason.
Adam
On Wed, 28 Aug 2002 [EMAIL PROTECTED] wrote:
>
>
> Hi there,
>
> I am experiencing a peculiar problem. I have recently moved a PHP / MySQL driven
> website I have been developin
The database was created successfully";
}
else
{
echo "The database was not created ".mysql_error()."";
}
?>
If it still gives you the same error, try connecting to mysql from the
console with mysql -u user -ppasswd
Adam
On Tue, 5 Aug 2003, Russell Griechen wrote:
> New
Thats how its supposed to work. It won't reuse old numbers even after you
delete the entire row.
Adam
On Tue, 27 Aug 2002, simon wrote:
> Hi
>
> Wondering if anybody can help with this:
>
> My table has an INT column named 'member_id' which is set to AUTO_INCREMENT.
> I
use an HTML form.
Adam
On Mon, 26 Aug 2002, Gerd Ulrich wrote:
> Hello, I want to build a questionaire where the user is guided through five
> pages of questions. How can I program PHP that the user gets to the second
> page after pushing the "Submit"-Button?
> My solut
I got it to work. I have to put the statement in ifx_prepare right before
I call it in the loop. I think its because when I define the statement at
the start of the code, $statement[$counter] has not been asigned yet so it
sets its value to nothing.
Adam
--
PHP Databa
I have an informix database with a table called phptesttable. It has a
SERIAL field (for mysql users that can help, its the same as INT NOT NULL
PRIMARY KEY AUTO_INCREMENT) and a CHAR field (CHAR in Informix is the
same as VARCHAR in mysql).
In my PHP script if I submit an array and then insert
set a default value that isn't possible (like -99-99 99:99:99) and
then have an if statement saying if ( $row[date] == '-99-99 99:99:99'
) { $row[date] = '';}
Adam
On Mon, 19 Aug 2002, Smita Manohar wrote:
> i'm using php with mysql. some tables in database have
If your articles are in an SQL database uses the LIMIT clause on your SQL
statement.
Adam
On Fri, 16 Aug 2002, olinux wrote:
> I would like to allow articles to be searched and
> returned in grouped categories - similar to cnet.com
>
> See example here:
> http://cnet.sea
See if this message posted earlier helps you out:
http://marc.theaimsgroup.com/?l=php-db&m=102938139730405&w=2
Adam
On 16 Aug 2002, Osman Omar wrote:
> Hi,
>
> Can I connect/access MS access database from linux ?
> if can, what software/driver that I need?
>
> Now I'm u
what is the structure of the table that this info will be going into?
Paste me the CREATE TABLE command you used to create it.
Adam
On Thu, 15 Aug 2002, Shoulder to Shoulder Farm wrote:
> Hi all,
> How can I make a PHP4 page that will add information to a MySQL database
I should add if you are going to upgrade apache also, to rpm -e apache
first so that You will have a clean install. backup httpd.conf first
though! But you might want to save /etc/logrotate.d/httpd because the rpm
-e removed this, and it is what rotates the log files for
/var/log/httpd/access_lo
I'd uninstall php first...I believe its rpm -e mod_php (or you can do rpm
-e `rpm -qa|grep php` and then I'd upgrade apache and PHP on your box for
security reasons. Read the installation section in the php manual at
www.php.net for details.
Adam
On Wed, 14 Aug 2002, Jul
57 matches
Mail list logo