Hi people...
I use PHP 4 with Red Hat 7 and a Oracle DB, but I canĀ“t find the extensions to access
the oracle db
In php.net I found the DLL for Win NT/2000 but I didn't find the files for Linux.
Paulo Cesar
Hi,
It's me bothering you great helpers again! Wondering if you can help me?
I know I am missing something stupid cause I am taking this pretty much
straight out
of the PHP 4 Bible.
Here is my table dump:
CREATE TABLE users (
uid int(10) unsigned NOT NULL auto_increment,
name varchar(20)
I have been successfully able to upload the files to the server and its path
stored in the database..
Now I have two small issues...
1. How would I automate the file naming otherwise errors will fly (can't
copy file... blah blah)
2. The second part is the most annoying. It seems that I
What exactly is the error message? Did you change config.php to use the name
of your database and your username password?
I've found the articles at devshed to be helpful in the past. This
particular one has a pretty good explaination of setting up a user
authentication system:
On 2/5/02 9:58 AM, Todd Williamsen [EMAIL PROTECTED] wrote:
Now I have two small issues...
1. How would I automate the file naming otherwise errors will fly (can't
copy file... blah blah)
You could replace the file name with a randomly generated number. There are
a number of ways to
I am not getting an error message. The te.php is connecting to the data
base. Just not doing what I want
it to.
While that is a very good tutorial (if I was just logging in) but it has
nothing to do with inserting information
into the database via a form.
But thanks for the tut. It will come in
Jerry,
Installing DB2 Client will allow you to use the ODBC functions in PHP, but
be aware that you are not actually using any ODBC Drivers in this instance.
PHP allows hiding of certain database specific functions under a Unified
ODBC that uses the ODBC functions without using true ODBC
Jennifer,
You have a clear idea of what you want done by the script - as guided by the book.
However, do you have a clear idea of what the script is actually seeing - and
therefore why it is doing what
it's doing?
When debugging, add a heap of ECHO statements to test pertinent values, eg
Hi Jennifer
The table defines the uid field as not null.
CREATE TABLE users (
uid int(10) unsigned NOT NULL auto_increment,
name varchar(20) NOT NULL default '',
password varchar(20) NOT NULL default '',
..
However you are trying to insert null
Hi again
The insert statement is incorrectly positioned within the if statement.
?
if(!IsSet($stage))
{
?
Please fill out the form below to get an account.
FORM METHOD=POST ACTION=te.php
Username:BRINPUT TYPE=TEXT NAME=name SIZE=15BR
input type=hidden
If you read to part 2 of the tutorial it has quite a bit on inserting data.
The reason there are tutorials and books are to teach the *concepts* behind
what they are showing you.
This is probably what is tripping you up; you create the table with uid as
an integer, auto increment, not null
I believe when PHP saves a file, it is already owned by the web server user.
In my case, nouser. I could not get this behaviour to change.
Normally you should not need to CHMOD or CHOWN anything you upload unless
you need them to be modified by ftp users as well.
Just make sure the folder is
Thanks Andrew for your answer.
In the environment variables I have already:
DB2INSTANCE=db2inst1
LD_LIBRARY_PATH=:/home/db2inst1/sqllib/lib
Is it correct ? Or does it need to point to the DB2 Client directory
/usr/IBMdb2/V7.1/lib
Thanks.
Jerry
Andrew Hill [EMAIL PROTECTED] wrote in
Yeah,
My chown reference was to chowning the folder that the files are uploaded
to, not the indv. files.
Robert
- Original Message -
From: JD Daniels [EMAIL PROTECTED]
To: Todd Williamsen [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 05, 2002 12:21 PM
Subject: RE:
You need to specify some env variables before you connect: heres what I do.
#
putenv(LD_LIBRARY_PATH=/home/db2inst1/sqllib/lib);
putenv(DB2INSTANCE=db2inst1);
Just installed Les Visiteurs for php site statistic gathering...looks fine.
Anyone have a favorite site statistic script/program in PHP? I'm
experimenting with different ones to see what I like.
The only disadvantage I can see with Les Visiteurs is having to put a couple
of lines of code in
Ok what is wrong with this sql statement?
$sql = UPDATE $table_name SET
c_name=\$c_name\,s_addy=\$s_addy\,city=\$city\,state=\state\zip=\zi
p\,phone=\$phone\;
The error I recieve is as follows
Warning: Unexpected character in input: '\' (ASCII=92) state=1 in
/path/to/wwwdemo_change.php3 on line
Try putting single quotes around your variables in your update statement
instead of the escaped double quotes, they are easier to read.
Also, were you wanting to update all entries in that table to the same,
c_name, s_addy, city, state, zip and phone? If not, you will need to
add 'where
Hi there, make sure you aren't outputting anything to the browser prior to
sending headers ie the echos on top of page 3. When you register a session
variable you should assign it a value ie:
session_register(mysessionvar);
$mysessionvar = $whateveryouwish;
Also make sure session_start(); is at
Ok jas
Ok what is wrong with this sql statement?
$sql = UPDATE $table_name SET
c_name=\$c_name\,s_addy=\$s_addy\,city=\$city\,state=\state\zip=\zi
p\,phone=\$phone\;
insufficient checking:
comma missing between state and zip
incorrectly escaped before phone
...
I have looked on MySQL.com
Did you type this out or cut/paste? There was a comma missing between
state\zip . Should work when you add the comma.
Add a WHERE condition for the update, otherwise every row will be set to
these values.
Common practice is to use single quotes around the char variables, saves a
lot of
Hi All
How do I count how many time a certain link generated in part from my db
has been click so that I can show this number to my visitors as some
kind of hit list, top 10 etc:
I thank you in advance for any help
Dave Carrera
Website Designer
http://www.davecarrera.com
--
PHP Database
22 matches
Mail list logo