Hi Arvid,
thank you very much for your remark. It is useful for me.
===
On Fri, 14 Sep 2007 12:01:40 +0300
Arvids Godjuks [EMAIL PROTECTED] wrote:
Don't use SQL_CALC_FOUND ROWS on simple queries, when you have to run a
simple query on one or two (with join) tables with a simple WHERE.
Dear Brian,
My problem is solved. thank you very much for your help.
===
On Wed, 12 Sep 2007 14:04:11 -0400
brian [EMAIL PROTECTED] wrote:
Patrik Hasibuan wrote:
Dear my friends...
I am trying to display the content of a table. Each page must content
only 5 records maximum. Each page
Dear mike,
your thread solved my problem.
I really appreciate your help.
Thank you very much.
On Thu, 13 Sep 2007 14:49:29 -0700
mike [EMAIL PROTECTED] wrote:
warning: this is VERY UGLY CODE. i wrote it 3-4 years ago now i think
and it just keeps working.
you call it this way:
#
Don't use SQL_CALC_FOUND ROWS on simple queries, when you have to run a
simple query on one or two (with join) tables with a simple WHERE. Especialy
if tables are big. I found out that single SELECT COUNT(id) FROM table is
far more faster when query has simple WHERE conditions. I use
except i think innodb does not have a full row count stored.
anyway the design was meant for a simple one function call. it's
worked great for small and data loads.
On 9/14/07, Arvids Godjuks [EMAIL PROTECTED] wrote:
Don't use SQL_CALC_FOUND ROWS on simple queries, when you have to run a
2007. 09. 14, péntek keltezéssel 10.50-kor mike ezt írta:
except i think innodb does not have a full row count stored.
of course not, but SQL_CALC_FOUND_ROWS does not use that. it is working
like it selects the rows and counts them. and in the case of complex
queries (where you use more than one
Hi Mike,
I am intrested for the solution you gave me. But I am confused of the way in
implementing select FOUND_ROWS().
I wrote another very simple codes as the first step for understanding this
threat:
?php
$konek=mysql_connect(127.0.0.1,root,mypassword);
if ($konek){
for
warning: this is VERY UGLY CODE. i wrote it 3-4 years ago now i think
and it just keeps working.
you call it this way:
# pagination.
if(isset($_GET['pg'])) {
$page = intval($_GET['pg']);
} else {
$page = 1;
}
$page = sprintf(%02d,$page);
$query = Array(
'query' =
);
}
.
Please tell me why PHP does not work as I expect.
Thank you very much in advance.
=
html
?php
session_start();
session_register(tiket);
setcookie(curguruescomidiklan);
setcookie(guruescomidiklan,);
setcookie(jmli);
$tiket=session_id();
$pageamount = 5;
?
table align=center
tr
!--Bagian Pencari
Patrik Hasibuan wrote:
Dear my friends...
I am trying to display the content of a table. Each page must content
only 5 records maximum. Each page has Previous and Next buttons
(made from anchor).
I dump the primary of the working table and keep it in a cookie. So
than the paging task work with
On 9/12/07, Patrik Hasibuan [EMAIL PROTECTED] wrote:
Dear my friends...
I am trying to display the content of a table. Each page must content only 5
records maximum. Each page has Previous and Next buttons (made from
anchor).
I dump the primary of the working table and keep it in a
ðÒÉ×ÅÔ!
Saci wrote:
Who cares about privacy on my own company Intranet ?
Anyone not willing to show where they has been surfing on the net to any
unexperienced bycomer. Youu may read the history, but you just have *no*
warranty that it will not be cleared at runtime.
Since you have control
I tried this simple code
html
body
Page refered by
?php
echo $HTTP_REFERER.'br';
echo $_SERVER['HTTP_REFERER'].'br';
?
/body
/html
and I receive blank reply even if referenced from a link from other site.
What am i doing wrong ? Or perhaps my server does not have referer enabled?
--
PHP
as a feature. In
short, it cannot really be trusted.
-Original Message-
From: Saci [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 14, 2002 2:11 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Does not work
I tried this simple code
html
body
Page refered by
?php
echo $HTTP_REFERER.'br
// HTTP_REFERER as a feature. In short, it cannot really be trusted.
Anybody know how to do that using JAva history with PHP together , or any
other methode that works and can be trusted.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ðÒÉ×ÅÔ!
Saci wrote:
// HTTP_REFERER as a feature. In short, it cannot really be trusted.
Anybody know how to do that using JAva history with PHP together , or any
other methode that works and can be trusted.
Thank god no method can be trusted :) History even less the the
referrer. Just
Pffft you can't trust Java, JavaScript or anything on the server side at
all. Since it's set by the browser (client) itself, the best you can do is
test for it, and provide a fall back option.
For the bulk of users, this will be okay, because they're on IE. What you
need to be carefull of is
To say the minumum yor reply does not help in nothing.
Who cares about privacy on my own company Intranet ?
Alberto Serra [EMAIL PROTECTED] escreveu na mensagem
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
ðÒÉ×ÅÔ!
Saci wrote:
// HTTP_REFERER as a feature. In short, it cannot really be
-Original Message-
From: Saci [mailto:[EMAIL PROTECTED]]
Sent: Monday, 15 July 2002 12:51 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Does not work
To say the minumum yor reply does not help in nothing.
Who cares about privacy on my own company Intranet
I agree, I made a mistake on my last reply , and I apologize for that.
Thank you also for you for your coments, but my main question still open
without any related reply.
To say the minumum yor reply does not help in nothing.
Who cares about privacy on my own company Intranet ?
1. I
This works for me, PHP 4.1.1
Upon first loading the page, I get nothing, but when I click on go, I get
both referrer address' echoed.
refer.php:
---
html
body
A HREF=refer.phpgo/aBRBR
Page refered by
?php
echo $HTTP_REFERER.'br';
echo $_SERVER['HTTP_REFERER'].'br';
?
/body
/html
---
It's
I forgot to point out another disadvantage of turning on register_globals
apart from that of security is that when you are sending a page with a
form to the same page, e.g:
form name=whatever action=$PHP_SELF method=post
there is a tendency to lose info.. E.g.
If you are sending text separated
Not a problem, I can make some code modification. Sometime it is better to
do it now and not have so much headache later on when more features are
being added.
Scott
Kondwani Spike Mkandawire [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I forgot to point out
Not a problem! I can make some adjustment to the $user_detail['']
(session_id()) to make it work as $_SESSION[''].
Scott
Erik Price [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
On Wednesday, June 26, 2002, at 02:37 PM, Scott Fletcher wrote:
I didn't know
I forgot to point out another disadvantage of turning on register_globals
apart from that of security is that when you are sending a page with a
form to the same page, e.g:
form name=whatever action=$PHP_SELF method=post
there is a tendency to lose info.. E.g.
If you are sending text separated
Hi! I downloaded the newer version of PHP and compiled it. The php is
working great! But there is one problem.
When I use the hyperlink, test.php?data=yes and I go to this page,
test.php but there is no data in this variable, $data. So, the web page I
have, most of them are all thrown off
On Wednesday, June 26, 2002, at 01:20 PM, Scott Fletcher wrote:
When I use the hyperlink, test.php?data=yes and I go to this page,
test.php but there is no data in this variable, $data. So, the web
page I
have, most of them are all thrown off becuase of this. I use PHP
version
4.2.1.
[snip]
When I use the hyperlink, test.php?data=yes and I go to this page,
test.php but there is no data in this variable, $data. So, the web page I
have, most of them are all thrown off becuase of this. I use PHP version
4.2.1. Is there a bug in this PHP version??? Or some changes in PHP that
I'm using UNIX, not windows, so there is no php.ini in UNIX.
I only use the ./configure command which is
-- snip --
./configure
--with-apache=../apache_1.3.26
--with-ibm-db2=/usr/lpp/db2_06_01
--with-openssl=../openssl-0.9.6d
--with-mcrypt=../../lib
--without-mysql
[snip]
I'm using UNIX, not windows, so there is no php.ini in UNIX.
[/snip]
Look here /etc/apache/php.ini-dist or /etc/apache/php.ini. There is an ini
file for PHP, and you may have to rename php.ini-dist to php.ini. Once done,
look for
; You should do your best to write your scripts so that
On Wednesday, June 26, 2002, at 02:13 PM, Scott Fletcher wrote:
I'm using UNIX, not windows, so there is no php.ini in UNIX.
Sorry, don't take offense if I ask if you've been living under a rock --
I only use Linux, and there is definitely a php.ini file that you use.
I put mine in
I didn't know that. Thanks for the info. I think it would be best that I
not use php.ini.
I can write the script to register the variable. What would be a demo
script that would work? I'm having a little trouble understanding that on
the php.net website. Most of the script that use global
Hi Erik!
This is my 2nd posting, not sure what happened to my first one. Sorry about
not seeing your previous posting before. Windows crashed on me. My fault.
I didn't know we can use php.ini in UNIX or Linux. Cool! Haven't been
using it on UNIX for a long time. I think I can leave it out
There is no feasable way to hide data being submitted to your
website. Anything that a user's browser can send, the user can
telnet to port 80 of your server and spoof.
You can try POSTing data, which will not appear in the URL,
but dont even waste time trying to hide submitted data,
rather,
On Wednesday, June 26, 2002, at 02:56 PM, Scott Fletcher wrote:
I tried that and it worked. I have
one question, what about the hyperlink? People will see the option in
the
hyperlink. You know. Is there a way around it to hid that in the
hyperlink?
If by hyperlink you mean the URL
On Wednesday, June 26, 2002, at 02:37 PM, Scott Fletcher wrote:
I didn't know that. Thanks for the info. I think it would be best
that I
not use php.ini.
On the contrary, I think it would be best if you read through it and
read about it at http://www.php.net/manual/en/configuration.php
Um, alright, I'll just leave the code in the hyperlink the way it is. It is
not possible to use the form or post of some sort for the hyperlink.
form will work with the submit button where we can use post or hidden.
Hyperlink meant words or sentences that have underline underneath it, when
Running Apache,linux,php4.1.2 and I can't get $_SESSION to work, creates
the temp file but doesn't actually put anything in it. There appears to
be a bug report saying it is broke but does anyone know what version (if
any) $_SESSION actually works in? I'm trying 4.1.1 also and its doing the
same
, 2002 11:22 AM
Subject: [PHP] Does $_SESSION work in any release?
Running Apache,linux,php4.1.2 and I can't get $_SESSION to work, creates
the temp file but doesn't actually put anything in it. There appears to
be a bug report saying it is broke but does anyone know what version (if
any
It seems that I have a parse error somewhere in the following code
(since that's the only code in my script, it's a test script):
// arraytest.php
$tempsql = SELECT COUNT(*) AS count
FROM divisions;
$tempresult = mysql_query($tempsql, $db);
$temprow =
Hmm I believe that the mysql_query() function requires quotes around the
query statement even it it is being passed as a variable..
mysql_query($tempsql, $db);
-Kevin
It seems that I have a parse error somewhere in the following code
(since that's the only code in my script, it's a test
Message -
From: Erik Price [EMAIL PROTECTED]
To: PHP (E-mail) [EMAIL PROTECTED]
Sent: Thursday, January 10, 2002 4:28 PM
Subject: [PHP] does this work?
It seems that I have a parse error somewhere in the following code
(since that's the only code in my script, it's a test script
I tried that... I get the same error (same line and everything).
As a side note, I haven't ever had to quote the first argument in
mysql_query() before...
This is quite a conundrum, eh?
Erik
On Friday, January 11, 2002, at 04:25 AM, Kevin Stone wrote:
Hmm I believe that the mysql_query()
Show all your code. Did you open a connection to the MYSQL server? If so,
show the code.
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 3:29 PM
To: PHP
Subject: [PHP] does this work?
It seems that I have a parse error somewhere
Show all your code. Did you open a connection to the MYSQL server? If so,
show the code.
What is the exact error that you get?
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 3:29 PM
To: PHP
Subject: [PHP] does this work?
It seems
quotes are not needed
-Original Message-
From: Kevin Stone [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 3:26 AM
To: Erik Price; PHP (E-mail)
Subject: Re: [PHP] does this work?
Hmm I believe that the mysql_query() function requires quotes around the
query statement even
On Thursday, January 10, 2002, at 04:39 PM, Rick Emery wrote:
Show all your code. Did you open a connection to the MYSQL server? If
so,
show the code.
Okay, but I changed some personal info (that I know is definitely
correct):
?php
// arraytest.php
$db = mysql_connect(hostname,
Wait, my bad. Typo... all my fault.
I feel like an ass.
Erik
--
PHP General 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]
nnection to the MYSQL server? If
so,
show the code.
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 3:29 PM
To: PHP
Subject: [PHP] does this work?
It seems that I have a parse error somewhere in the following code
(since that's the only co
'; PHP
Subject: RE: [PHP] does this work?
Show all your code. Did you open a connection to the MYSQL server? If so,
show the code.
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 3:29 PM
To: PHP
Subject: [PHP] does this work?
It seems
But as I was writing before, what I'm really trying to do with this
isn't just echo the COUNT of records in a table.
What do I need to separate the array $temprow into pieces so that I
can get at the data:
$tempsql = SELECT divisions.div_name, divisions.div_id
FROM divisions;
-1362 X289
[EMAIL PROTECTED]
- Original Message -
From: Erik Price [EMAIL PROTECTED]
To: Kevin Stone [EMAIL PROTECTED]
Cc: PHP (E-mail) [EMAIL PROTECTED]
Sent: Thursday, January 10, 2002 4:43 PM
Subject: Re: [PHP] does this work?
I tried that... I get the same error (same line
On Thursday, January 10, 2002, at 05:16 PM, Martin Towell wrote:
is this valid in PHP?? (haven't tried it myself yet...)
$tempsql = SELECT COUNT(*) AS count
FROM divisions;
maybe it needs to be on one line???
It turns out that my problem was a typo. I apologize
and it would be like using the statement $a = $a;
very very useless!
bvr.
On Thu, 10 Jan 2002 15:39:27 -0600, Rick Emery wrote:
quotes are not needed
mysql_query($tempsql, $db);
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
At 4:28 PM -0500 1/10/02, Erik Price wrote:
PS: what I am -really- trying to do is dynamically fill in a
select listbox with options that correspond to all of the
records in a given table. Like so:
form
select
?php
foreach
2002 22:15
Subject: Re: [PHP] does this work?
But as I was writing before, what I'm really trying to do with this
isn't just echo the COUNT of records in a table.
What do I need to separate the array $temprow into pieces so that I
can get at the data:
$tempsql = SELECT divisions.div_name
to be on one line???
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 8:39 AM
To: 'Erik Price'; PHP
Subject: RE: [PHP] does this work?
Show all your code. Did you open a connection to the MYSQL server? If so,
show the code.
-Original Message
Perhaps people expected you to check the docs or the code yourself. If
you go to php.net/sybase you will find the functions you need. If you
read the user comments on that page you will even find urls to
tutorials/faqs on how to install and configure things for PHP to talk to
Sybase ASA.
eg.
I suppose You have ASA 6.0 or later version installed on Your machine with
Linux. If it is true, then You can install Open Client for ASE 11.0.3 (it is
free) and You can communicate via Open Client to ASA. It works only with ASA
6.0 and higher. Then You need to compile PHP with Sybase Open
2nd time, seem that last time nobody saw my question...
I mean, is there in PHP support for Sybase Adaptive Server Anywhere, any
version, like for MySQL and some other databases?
Thanks.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
I mean, is there in PHP support for Sybase Adaptive Server Anywhere, any
version, like for MySQL and some other databases?
Thanks.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the
Hello all,
If anyone works with phpXML library please explain me why add_node method
doesn't work for me? It returns the full path for the new added node but
there is no new node in the resulting XML!?
For example:
-
$xml = new
Lets take the most simple of scripts and run it on a standalone page to
prove it's working correctly before we import into a template file.
http://www.yorkshire-search.co.uk/links/add_form.php4
Next step, lets change the tags ?php ? to php/php because that's what
it says in the manual and put it
63 matches
Mail list logo