Hi.
I am using PHP4+Apache 1.3.14 (win32)+[Access-local | Oracle-remote] with
very simple query on small tables.
When I start the page.php it takes several second to display the results: it
seems that it is waiting someting; if there are many rows, it displays a
portion of it at time (in terms of
Hi Olinux,
U may want 2 try this js-code:
function ToggleAllCheckboxes()
{
for( var x = 0; x document.MYFORM.elements.length; x++ )
{
var y = document.MYFORM.elements[x];
if( y.name != 'CHECKALL') y.checked = document.MYFORM.CHECKALL.checked;
}
}
As U C, U have 2 setup a
Hi Stefano
I don't know if this is what you are looking for.
Take a look at the flush() function which should bring output faster to
the browser.
Hope it help
Cheers
Soeren
- Original Message -
From: Stefano [EMAIL PROTECTED]
The question is: there are some variable configuration in
Hello,
I'm trying to store some encrypted data on MySQL using GnuPG and eventually
send this information via e-mail. Is somebody using this solution? Has
somebody links on this topic where I can look and see how to do it?
Regards,
Tomás
+-- --+
Hello Everyone!!
We are making on the project with PHP4 and MSSQL7. Everything is based on
NT4 platform.
Certainly, in this case we are operating by SQL stored procedures.
The question is..
I found some problems while extracting data from database over ODBC
which we need to use to make a
RTFM or search in the archive of this mailinglist !!!
int mysql_insert_id ([int link_identifier])
Greetinx,
Mike
Michael Rudel
- Web-Development, Systemadministration -
Besuchen Sie uns am 20. und 21. August 2001 auf der
online-marketing-düsseldorf in Halle 1 Stand E 16
Hi,
I'm not sure about the probeme you have, but if the probleme is based on
ODBC, why do use ODBC? You could also use the Sybase-Ct libs.. should work
also with MSSQL...
Greetings,
Stefan
-Ursprüngliche Nachricht-
Von: Michael Yevdokimov [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag,
http://php.net/manual/en/function.mysql-insert-id.php
from the link above
Warning:
mysql_insert_id() converts the return type of the native MySQL C API
function mysql_insert_id() to a type of long. If your AUTO_INCREMENT column
has a column type of BIGINT, the value returned by
Hi,
hope anyone has an idea on how to fix this...
form
input type=submit name=Submit value=Submit Request
OnClick=submit.php class=button
input type=submit name=Edit value=Edit Request OnClick=edit.php
class=button
/form
you could give the form one action and then check on the following
Try setting form.action and using form.submit() to send it ('edit.php' is
not valid javascript).
Here:
htmlheadscript!--
function submitTo(form, url) {
form.action = url;
form.submit();
}
--/script/headbody
form name=f action=submit.php
input type=submit
Yes :-
http://www.alt-php-faq.org/#id65
Regards
Darren
http://www.php4hosting.com
-Original Message-
From: Tomas Garcia Ferrari [mailto:[EMAIL PROTECTED]]
Sent: 10 July 2001 12:02
To: 'php-db'
Subject: [PHP-DB] How to use GnuPG to store data on MySQL
Hello,
I'm trying to store
Micheal,
If things work in Query but not PHP you can easily get an under-the-covers
comparison of the ODBC calls by turning on Tracing in the ODBC Administrator
(Driver Manager).
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal
olinux,
When you move to remote connections and want to compile ODBC support into
PHP on a *nix box, you will need a Driver Manager in the mix as well as the
ODBC Drivers.
There is a HOWTO on compiling the iODBC Driver Manager with PHP at
www.iodbc.org.
Basically, it involves getting the iODBC
Christian,
Are you using an ODBC driver or just the unified-ODBC functions?
If a driver, then I suggest changing vendors - that performance is in no way
representative of ODBC in general.
In addition, to improve performance even more when using similar queries,
first use odbc_prepare to prepare
Jacarilla 8.7.2001.Publicidad/Enseñanza a Distancia
Hola que tal:
El motivo de la presente carta es informarte de la posibilidad de poder
realizar algún curso a distancia de tu interés, cursos relacionados con tu
trabajo inquietudes y ocio.ect.El conocimiento es el mayor
Not sure if this is really the right list to ask on, so please excuse me.
I am trying to use the adodb db class with php4/mysql. On problem i have hit
is that if i retrieve 2 tables with a join and the 2 tables both have a
field of the same name, the command
$result-fields(fieldname) always
Hi Mark,
You can access the column by index position instead, or use as column alias:
select a.col col1, b.col col2 from a,b where a.key = b.key
Then access using col1 and col2.
Bye, John
Mark Newnham [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Not sure if
Don't flush or print/echo too often. This generates many fragmented tcp-ip
packets
(causing the behaviour you observe). The fastest method is probably
store the accumulated HTML data in a variable and print the variable every
100 rows or so.
Regards, John
Soeren Nielsen [EMAIL PROTECTED] wrote
Hi Michael,
The should not be any issues with the oder of the columns in the select using ODBC. I
do have some questions for you.
1) What is the reson for using stored procedures for this. The procedure you are
showing is just a wrapper arround a SQL statement. You could as easily generate
Dear Experts
When ever i try to run MySQL under linux it gives me following error
ERROR 2002 : can't connect to local MYSQL server through socket '/var/lib/mysql.sock'
(111)
what could be possible remedy/rectification of the above ?
million thx in advance
Vivek Misra
--
PHP Database
Are you running as the admin setting it up or are you a user on the system
getting the error?
Vivek Misra [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Dear Experts
When ever i try to run MySQL under linux it gives me following error
ERROR 2002 : can't
Hi,
I'm having an odd occurrence using mysql. If I insert into a varchar field
with information like This is the information, it works fine and I can
retreive and display the data using a normal 'print' or 'echo' statement.
However, if I try to display the data in a form field (so that I can
Hi,
Dear Experts
When ever i try to run MySQL under linux it gives me following error
ERROR 2002 : can't connect to local MYSQL server through socket
'/var/lib/mysql.sock' (111)
this is with PHP isn't it? can you log in the monitor and then type SHOW
VARIABLES. A long list
will be
I have seen in several places the following line:
img src='myScript.php' etc..etc..
Will this tag work in both IE and Netscape?
What does myScript.php do? Does it find an image and pass the binary data back?
Something like this--
?php
// Code to find get a path from a database
$fp =
Check out http://www.phpbuilder.com/columns/florian19991014.php3. It's a
tutorial that explains getting images in and out of databases. It also
describes what this myscript.php thingy does.
Good luck,
Ben
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
list-help: mailto:[EMAIL
I have the following setup.
PHP 4.04 running on windows 2000 using SQL Server 7.0
The script runs fine for sometime, then I get the following errors
PHP has encountered Access Violation at 013A2466. So I have to reboot
everytime. This happens
almost every 2 to 3 hours or so. I have to use PHP
Hello, I've used PHP4 + Interbase and I got a PHP Program executed an
ilegal operation bla bla bla bla. in a very very simple php script.
Then I switched back to PHP3 and everything is fine (well, everything
for this only little script I've tested).
Is this know? Is PHP4 + Interbase buggy?
Hi Andrew,
thanks a lot for your help. Today we discovered what
our real problem was:
After playing a little bit with the php-scripts that try
to connect to the IBM DB2, we set the optional parameter
Cursortype when calling odbc_pconnect().
And the exciting thing: When we set the cursor
Hello
Did anybody have problems with retrieving data from the fields of type
Text..
?php
$dsn = dsn_database;
$user = enduser;
$pass = ;
$query = usp_get_subj 10;
$conn = odbc_connect($dsn, $user, $pass);
$res = odbc_exec($conn, $query);
while (odbc_fetch_row($res)) {
//$data =
Hi
I found an interesting thing.. But it will just make my work much harder..
comparing to ASP... :o (which I already am not able to use in the
project we should deliver to our customer in a few weeks :o
?php
// database settings
$dsn = dsn_database;
$user = enduser;
$pass = ;
The error which occures during the call of stored procedure is:
Warning: SQL error: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor
Index, SQL state S1002 in SQLGetData in
d:\Inetpub\wwwroot\local_test\test.php on line 43
Michael Yevdokimov
Web developer
e-mail: [EMAIL PROTECTED]
Ok.. I discovered also that everything will work pretty good.. But!! The
field on type text should be ALWAYS the LAST in the model of the table..
Otherwise, it will not work what happens in my case..
Good night!
Mike
Michael Yevdokimov
Web developer
e-mail: [EMAIL PROTECTED]
Hello php-db,
How to delete file using PHP ?
and how to set it's permission ?
,,,
(@-@)
+==---o00(_)00o-==+
It is better to be defeated on principle than to win on lies.
--Arthur Calwell
--
Best regards,
andRie
http://www.php.net/manual/en/ref.filesystem.php
-Original Message-
From: andRie Is [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 3:28 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Delete file
Hello php-db,
How to delete file using PHP ?
and how to set it's permission ?
Hello, pure HTML server question:
images like (backgroundimage.jpg) stored on server at: /htdocs/www/img
util.showpic.html is stored at : /htdocs/util/
How to use backgroundimage.jpg as background in util.showpic.html ?
body background=/www/img/backgroundimage.jpg
does not work..
what
The following sequence appears to hang the webpage...
...
$dbht = ibase_trans($dbh);
... insert...
if($dbht) { ibase_commit($dbht); }
any thoughts to how to overcome this?
David Miles
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
Is /htdocs/ your web root? If it isn't the browser loading up the page
would not have access to /www/img/backgroundimage.jpg. If it is - try
removing the space after the .jpg in your body tag.
Tom
At 15:51 10/07/2001 -0700, you wrote:
Hello, pure HTML server question:
images like
Thanks for the reply Manual.
The updating IS done with one single query - but the problem is that if two
people are editing the same car, the second update will overwrite the
first. Not a huge problem - and the chance of it happening is almost nil -
but there is still the possibility..
HI, thanks
not sure what the web root is.
first dir I see on FTP is / so is that the root?
and it contains a whole bunch of dirs including htdocs
htdocs contains dirs: img (pics) util (utility html pages) www (main
html pages)
is there a way to refer to images in imgfrom html pages in
Tom Peck wrote:
Thanks for the reply Manual.
The updating IS done with one single query - but the problem is that if two
people are editing the same car, the second update will overwrite the
first. Not a huge problem - and the chance of it happening is almost nil -
but there is still
when you load up your web page in your browser, what folder do you see? It
is most likely the contents of the www/ folder.
If this is the case, then all of your files which you want accessible to
the web (ie html and images) need to be somewhere under this. Try putting
both the background
I Looked up the root..sorry
it is DOCUMENT_ROOT .. /htdocs/www
so I guess browsers think they are starting out at /htdocs/www and can't go
below to get anything?
so if I have phtml pages at /htdocs/util/ like
www.util.consumergrapevine.org/showdatabases.php and images at
/htdocs/www/img
So what you mean is:
If someone clicks on a car to edit, a txt file is written (maybe called the
carID.txt). Then if someone else clicks on that car to edit it, it says
that it is already being edited by someone else because the txt file
exists? So what happens if that person who clicked
The php file placed in your /util/ directory will not be accessible by the
web.. everything you want accessible to the web has to be placed in the
/www/ folder.. so place the php file in the /www/ folder (or /www/util/
if you like) and the images in the /www/img/ folder, and use the body
to get to the img directory you need to go up one directory ( ../ ) and
then into the img directory
body background=../img/backgroundimage.jpg
hope that helps
nick
At 04:38 10/07/01 -0700, Ken Sommers wrote:
I Looked up the root..sorry
it is DOCUMENT_ROOT ..
Hello again,
DOCUMENT_ROOT is.. /htdocs/www
I have a php file ( showdatabases.php) in my subdomain area /htdocs/util/
it loads up just fine: and if you click it, you will see my database
structure if you like..:)
www.util.consumergrapevine.org/showdatabases.php
I have images stored in
Hello again,
DOCUMENT_ROOT is.. /htdocs/www
I have a php file ( showdatabases.php) in my subdomain area /htdocs/util/
it loads up just fine: and if you click it, you will see my database
structure if you like..:)
http://util.consumergrapevine.org/showdatabases.php
I have images stored in
The problem is that they are completely different websites, from the web
browser point of view - even though they are so close to each other on the
server... You should have mentioned this was a sub domain site :-)
If you REALLY don't want to copy the image from the www folder to the util
Thanks Tom
and sorry I didn't mention it properly at first,,
I was trying to analyse the problem.
is it becuz the first part of the referenece being the ../
in body background=../www/img/background.jpg
the ../ wants to take the browser into illegal territory above the root?
because we are
Yes that is correct.
Your main site root is: /htdocs/www/
And your sub site (util) root is /htdocs/util/
These are two different sites from the browser's point of view.
Neither site will have access to anything below the root folder (from the
browser).
Tom
At 18:02 10/07/2001 -0700, you
Thanks again,
why couldn't the main root be /htdocs/
?
ken
- Original Message -
From: Tom Peck [EMAIL PROTECTED]
To: Ken Sommers [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, July 10, 2001 6:05 PM
Subject: Re: [PHP-DB] RE: trash last message ,this ones right I think
Yes that is
Perhaps you could consider using the webserver config (in Apache it
would be the httpd.conf file) to do the dirty work.
Create and alias (in the /util/ domain) for img that points to the
/hdocs/www/img/ location - voila! YMMV
HTH
Tom Henry
Ken Sommers wrote:
Hello again,
Ken
If the util site is going to be part of the main site, why don't you put it
in the www folder? ie. /htdocs/www/util/ the idea for different site
roots is so that you can keep different sites separate.
If you had the root as /htdocs/ for all, then the website address would
be:
Every time I use the command
LOAD DATA LOCAL INFILE C:WINDOWS:Desktop:db.txt INTO TABLE booktest;
I get this error message...
ERROR:
File 'C:WINDOWS:Desktop:db.txt' not found (Errcode: 2)
How can I load my file to the database???
--Will
I may be not understanding properly without checking your MySQL syntax, but
should it not be C:\WINDOWS\Desktop\db.txt?
Tom
At 08:53 10/07/2001 -0500, you wrote:
Every time I use the command
LOAD DATA LOCAL INFILE C:WINDOWS:Desktop:db.txt INTO TABLE booktest;
I get this error message...
- Original Message -
From: Ken Sommers [EMAIL PROTECTED]
To: pak [EMAIL PROTECTED]
Sent: Tuesday, July 10, 2001 10:29 PM
Subject: Re: Referential Integrity
Ever play .,.Name that Code?
I can delete those related rows in those 50 tables in about 5 lines..
but first you gotta keep a
- Original Message -
From: Ken Sommers [EMAIL PROTECTED]
To: pak [EMAIL PROTECTED]
Sent: Tuesday, July 10, 2001 10:46 PM
Subject: Re: Referential Integrity
I started learning PHP Mysql about 2 weeks ago.
I'm still reading the tutorials.
Hopefuly some experienced programmers in PHP
57 matches
Mail list logo