Adv. Systems Design pressed the little lettered thingies in this order...
hello *:
I have initially set a field named title to be
varchar(50)...I am finding that it is not long
enough...can I change the size without adversely
affecting existing data?
ALTER TABLE table_name CHANGE
[EMAIL PROTECTED] pressed the little lettered thingies in this order...
hello,
I've this silly question:
how can I pass a db persistent connection from a script to another? (it
seems there's no way: but what's the use then of them?)
eg, I tryed this 2 scripts (with Oracle 8.1.6)
Keith Whyman pressed the little lettered thingies in this order...
Can anyone help with this problem !
user name should just be keith but the @localhost gets added and then I
can't connect ???
Warning: MySQL Connection Failed: Access denied for user: 'keith@localhost'
(Using password:
I've just installed php4.0.4 , apache-1.3.14 and oracle8.1.6
on my RedHat 7.0 machine.I am trying to write a php script to connect
to my oracle database.But I am facing problems.When I used the oci8
functions as follows:
?php
putenv(ORACLE_SID=sid);
Tomás García Ferrari pressed the little lettered thingies in this order...
Hello,
I updated php to version 4.0.5 and MySQL to version 2.32.39, had errors on
lines like this:
$rows = mysql_num_rows($result);
and noticed that this is a solution:
$rows =
Hello
I am trying to access a Berkeley database V1.85 using PHP V4.0.5 (on Windows
2000) without success.
I have tried the dbmopen() routines and dba_open(..., ..., dbm) routines.
dbmopen() etc. are successful but the results suggest that they do not
support this database
format. The
on 6/21/01 2:30 PM, Tomás García Ferrari at [EMAIL PROTECTED] wrote:
I updated php to version 4.0.5 and MySQL to version 2.32.39, had errors on
lines like this:
$rows = mysql_num_rows($result);
and noticed that this is a solution:
$rows = @mysql_num_rows($result);
Is this a new
$rows = mysql_num_rows($result) should work. If you want to know what's
going on, try doing:
?php
$rows = mysql_num_rows($result) or die(Error grabbing number of rows. MySQL
said:pfont color=red . mysql_error() . /font);
?
-- David Balatero
-Original Message-
From: Tomás García Ferrari
on 6/21/01 2:23 PM, wflow at [EMAIL PROTECTED] wrote:
What I want to do is create another query from some of the data from another
one. The question is how do I take the data I get back from my first query
and put that into variables so I can build my second query. The example I
have in mind
Hello php-er,
how to make user to start login again after several minute doesnt
doing anything ? i want to use it and implement it using session.
so after the pages expired i want to destroy the session exist.
anyone can help me ?
TIA
A real friend is one who walks in when the rest
Thanks everyone for the help !
Discovered the problem !
My provider had changed the name of the host, without telling anyone !
ahhh the sort of thing that makes life fun ! :-)
Sounds like either:
1) You don't have your correct username/password info in the mySQL/user
table
or
2) Your
Hi,
the @localhost is to show the database server you are trying to log on and
it has nothing to do with your problem.
Please check your username and password and if you have the right
permissions.
Dobromir Velev
-Original Message-
From: Keith Whyman [EMAIL PROTECTED]
To: [EMAIL
Hi,
the '@' is an error control operator avaialble in all php versions. When
prepended to an expression in PHP, any error messages that might be
generated by that expression will be ignored.
Check the PHP Manual for more info.
Dobromir Velev
-Original Message-
From: Tomás García Ferrari
someone friend say me that rebuild source code php 4.0.4 , is true
I don't think you need to do anything as drastic as that!
I generally receive this error message if mysql_connect() (similar to
other _connect() functions) isn't given the right number of
arguments.
Send the offending code
Is this a new use of the function mysql_num_rows?
No!
You can use the @ to 'suppress error messages' that may reveal
delicate information to users such as paths to directories on your
server. It can be preppended to almost any php function likely to
result in an error, if used incorrectly.
Hi,
Have a try with something like this. Not tested and it's Friday ;o)
$connid = ifx_connect(blah,blah,blah) or
die(An error occurred connecting to database);
$Query = SELECT tracknum,orderdate,ordertotal,status,shipdate .
FROM orders .
WHERE
have a look at ob_start(ob_gzhandler) which will compress the page and
then send it, expecting the client to decompress it on arrival.
this is all handled transparently so you don't need to worry about the
decompression.
i found it very slightly slower but enormous reductions in network
How can I connect to our MySQL server remotely. Ordinarily, we upload the
same PHP application the same machine that runs MySQL too. So, I just
access it using localhost in the mysql_connect( ) function, like:
mysql_connect($servername,$dbusername,$dbpassword);
where
On 21.Jun.2001 -- 02:22 PM, William Flow wrote:
Chris,
Thanks for the advice, of course I already did rtfm and the
ifx_fetch_rows entry did not really help me. It, in fact
does NOT return an enumerated array, as the top line of the page
states. It ONLY returns an associative array.
On 21.Jun.2001 -- 02:22 PM, William Flow wrote:
Chris,
Thanks for the advice, of course I already did rtfm and the
ifx_fetch_rows entry did not really help me. It, in fact
does NOT return an enumerated array, as the top line of the page
states. It ONLY returns an associative array.
Hi All,
I have an Admin section for my site (where users fill in web forms and it
changes the site and upload facility for images) and would like a script
that does a User Logon page. Password is enough. I have created a TABLE in
my mySQL database called bw_password with two fields id and
i think this could also be your query failing.
if you have an invlaid sql staement you'll get the same error.
Steve
-Original Message-
From: Carlos Estala [mailto:[EMAIL PROTECTED]]
Sent: 21 June 2001 18:03
To: [EMAIL PROTECTED]
Subject: [PHP-DB] 1 is not a valid PostgreSQL link
On Thu, 21 June 2001, Christopher Ostmo wrote:
The persistence of the DB connection follows the child process that
serves your individual web page request. The first time a child process
requests a persistent DB connection, it will maintain that connection
until the child process dies.
On Thursday 21 June 2001 23:07, Chris Cowan wrote:
Does PHP work with MSSQL 2000?
It's work with freetds library
regards,
peco
--
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
Hi all,
I'm totaly lost. I have a Linux server (Debian Potato), which runs
Apache (1.3.14) + PHP (4.0.5) and MySQL (3.23.39).
Now, I need to connect to other machine (NT) which runs MS SQL 7 and I
need to insert some data to this machine. I'll read this data from my
MySQL and I need to store
Hi,
I'm kind of new to php so there may be an obvious answer but I can't
find it for the moment.
What I want to do is change the 'type=submit' of a submit button to
'type=image' so I can control the looks of the button.
In pure HTML there is of course no problem, the image is still used as a
What needs to be done is that you create a new user in the 'user' databese
where you replace 'localhost' with the IP number of the machine you will be
using to log in to your database and then grant the appropriate priviliges.
hope to have been of any help.
jan
Lester June Cabrera wrote:
How
Hi All,
I have an Admin section for my site (where users fill in web forms and it
changes the site and upload facility for images) and would like a script
that does a User Logon page. Password is enough. I have created a TABLE in
my mySQL database called bw_password with two fields id and
// USED FOR AUTHENTICATION
function authenticate_user(){
Header(WWW-Authenticate: Basic realm=\[EMAIL PROTECTED]\);
Header(HTTP/1.0 401 Unauthorized);
echo You are not authorized to enter this section of the site!\n;
exit;
}
At 22.06.2001 09:42, you wrote:
How can I connect to our MySQL server remotely. Ordinarily, we upload the
same PHP application the same machine that runs MySQL too. So, I just
access it using localhost in the mysql_connect( ) function, like:
I run different mySQL servers and frequently use them to back up the others
(i.e. I'll use ServerTwo to hold a backup of ServerOne's data in case
ServerOne goes down), so I wrote a few functions to help copying databases
between servers for backups, and to manage databases and tables on single
B,
Do your first query, then run this (for one record returned).
while($row = ifx_fetch_row($query_result_id)) {
for(reset($row); $fieldname=key($row); next($row)) {
$$fieldname = $row[$fieldname];
}
}
Do your second query.
The while statement
It also works well with ODBC.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access Data Integration Technology Providers
-Original Message-
From: snpe [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 22, 2001
on 6/22/01 6:10 AM, Jan de Koster at [EMAIL PROTECTED] wrote:
I'm kind of new to php so there may be an obvious answer but I can't
find it for the moment.
Look at the PHP FAQ, it's a great place to start:
http://php.net/FAQ.php
In pure HTML there is of course no problem, the image is still
Hi,
Can anyone tell me what is the .htaccess file and how to use it?
Thanx,
vipin chandran
[EMAIL PROTECTED]
--
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,
No, with an image, the value captured are the coordinates x and y above the
image this means that if your variable is called submit, the two variables
$submit_x and $submit_y are set.
- Mensaje original -
De: Jan de Koster [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviado: vendredi 22
At 22.06.2001 11:23, you wrote:
I tried but to no avail, I was trying to
send the header to redirect if the password in the input box matches the
database password but it kept saying that the header was already sent.. I
tried Javascript aswell, doing a location.href = URL within the if
Our website uses mysql/php. I found the link as a hard coded link and I
can't figure out why the programmer would have used c2x5han as a keyword
instead of chan - which is an acronym for Child Health Nutrition.
I thinking about changing the link but not sure what the repercussions would
be
I ALWAYS use this set of scripts because they don't have to integrate into your pages.
They are a front end check that you just add one line to the top of all your pages
you want to secure. The check runs and if they have clearance, THEN your page
displays. Very easy to use and customize.
-Original Message-
From: Bård Farstad [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 11:45 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Informix question
I'm writing an application which uses the PHP interface to
informix. I'm having trouble with newlines in
Hey Lisa,
it's very simple. You was on the right way!
The reason that you got the error 'header already sent': you did NOT use
header at the top of your script! There we're some bytes send to the client!
So your header only can be sent if the client did not receive some data!!!
Below an
what are the advantages and disadvantages of primary keys and indices?
- Noah
--
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]
43 matches
Mail list logo