Re: [PHP-DB] Displaying data as while recieving form mysql server
Hi Lee, You can't. A table has to be closed /table before a browser can render it and present it to you. So, the webserver may well be trowing echo(trtd.$row[$i].td/tr\n); to the browser, the browser will wait for the /table. You might try cutting the one big table into smaller tables, each complete table will be visible as it is completed. Or find an alternative and don't use tables. This also argues that it is not wise to put an entire (much content) page into a table: body table ... content, much content ... /table /body as it simply takes ages before anything seems to happen in your browser. M.vr.gr. Roel Mulder At 16:17 22-02-2002 -0600, you wrote: Hello. After I run my mysql query and get the results, then I do a look to put the data into table rows that go to a webbrowser. How can i set it up so that the user see's the table rows as their writen, not after the script is all done. Lee [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Mulder Technisch Advies Postbus 69 NL-2740 AB WADDINXVEEN tel. 0182-640184 fax. 0182-640185 http://www.mta.nl -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Redirecting to a new page
Hi Matt,
http://nl.php.net/manual/nl/function.header.php
Note: HTTP/1.1 requires an absolute URI as argument to Location: including
the scheme, hostname and absolute path.
Thus, print Location:http:/www.host.com/admin.php; should work.
Regards,
Roel Mulder
At 13:57 04-01-2002 +, you wrote:
Can't find the right instructions on php.net, basically, i want a page where
someone logs in, and then according to the database entry for them, either
they are an admin user or a normal user, and it should then send them to a
page depending on which they are.
I've accessed the db ok, and checked which they are, then i've used
if ($myrow[Admin] == Y){
print Location:admin.php;
}else{
print Location:user.php;
)
this doesn't sem to work - just gives a blank screen with the standard html
headers and footers, rather than the desired location page.
Mulder Technisch Advies
Postbus 69
NL-2740 AB WADDINXVEEN
tel. 0182-640184 fax. 0182-640185
http://www.mta.nl
--
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]
Re: [PHP-DB] parse-error MySQL - PhP @ win2000
Dag Jelle,
Als je printf(); gebruikt moet je dit wel correct doen, met print(); zou
het goed moeten gaan.
Dus regel 24 wordt: print ($resultaat[0]);
(Excuse me muttering Dutch between the two of us :)
M.vr.gr.
Roel Mulder
At 21:32 10-11-2001 +0100, you wrote:
Hi all,
I have recently installed an apache server, PhP4 and MySql on my win2000
machine (I know, I should be running linux; That will have to come with
time). But now I am trying to learn PhP - MySQL. When running the script
below I get the error message:
Parse error: parse error in c:\phpdev\www\public\test2.php on line 25
Is there anybody who knows what the problem might be? I think is in the
result display part, considering how things run properly when I leave it
out. Hopefully you ca get me going, since I do not know what I am doing wrong!!
Thanks for the help,
Jelle
?
$host=localhost;
$username=;
$password=;
$database=jelle_test;
$table=pet;
$db = mysql_connect($host)
or die (verbinding maken met de server is mislukt);
Echo gefeliciteerd, de verbinding is tot stand gebracht, de handle is $db;
@mysql_select_db($database, $db)
or die (Helaas geen verbinding kunnen maken met de database);
$sql_select = Select * from pet;
$result = mysql_query($sql_select, $db);
if($result) {
echo Selectie succesvol;
while ( $resultaat = mysql_fetch_row($result)) {
printf($resultaat[0]);
}
mysql_close($db);
?
--
**
Ir. Jelle G. Ferwerda
[EMAIL PROTECTED] - www.bio-vision.nl
Mulder Technisch Advies
Postbus 69
NL-2740 AB WADDINXVEEN
tel. 0182-640184 fax. 0182-640185
http://www.mta.nl
--
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]
Re: [PHP-DB] Url link
Hi Mark, Try this code for your delight: http://www.oreillynet.com/pub/a/php/2000/11/02/next_previous.html Regards, Roel Mulder At 16:02 14-05-2001 -0400, you wrote: Hey there, I'm trying to build NEXT/PREV buttons on my search page. The only way I know to do it so far is via an url. 8 8 8 8 Does anyone know how best to get rid of the \'s or a better way to do next/prev buttons? Thanks!!! Mark Mulder Technisch Advies Postbus 69 NL-2740 AB WADDINXVEEN tel. 0182-640184 fax. 0182-640185 http://www.mta.nl -- 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]
Re: [PHP-DB] Apache+PHP+MySQL installation at once - HOW?
Another option is http://www.firepages.com.au/devindex.htm Look for phpdev3: Apache, PHP, MySQL and phpMyAdmin in one zip, for windows platforms. all yours, Roel Mulder At 10:31 04-05-2001 -0500, you wrote: At 9:45 AM +0200 5/4/01, Vojtech Dvorak wrote: Hi, I want to install this great trio Apache+PHP+MySQL and don't want it install step by step, program by program. I remember, that I saw somewhere some prepared package for very fast and comfortable installation of these three at once. Don't you now where I can find it? Thanks Vojtech http://www.nusphere.com/ Paul DuBois, [EMAIL PROTECTED] Mulder Technisch Advies Postbus 69 NL-2740 AB WADDINXVEEN tel. 0182-640184 fax. 0182-640185 http://www.mta.nl -- 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]
Re: [PHP-DB] Search engines database driven sites
Hello Grant,
Well the thing with search engines is as AltaVista puts it very nicely:
quote
Dynamic pages also block Web crawlers.
8 8cut 8 8
Typically such pages have a question mark (?) in the URL. When a search
engine crawler arrives at such a page, it captures the content but halts
immediately, and will not follow the links, because it sees ahead of it an
infinite number of pages -- a black hole that would bring it to a crash.
/quote
This came from http://doc.altavista.com/adv_search/ast_haw_wellindexed.html
where you can find more useful tips.
So if you are passing variables in any way like
http://www.site.com/dir/article.php?id=25 than these pages will simply not
be indexed...
One way to deal with this is the following:
Build the link above like this: http://www.site.com/dir/25.html this
document doesn't exist.
In that directory you refer the 404's to article.php where you call
getenv("REQUEST_URI") and look, it says 25.html which you can then use to
query the database and show that article :)
Roel
At 12:24 27-02-2001 +, you wrote:
Greetings
I'm not sure my question fits into the remit of this list - so apologies in
advance if it's off track... Please point me in a more suitable direction is
necessary!
I recently converted my sites from hardwired HTML to a PHP/MySQL
combination - with dynamic 'newsy' info held in a database, tailored for
each visitor. Unfortunately the 'hit rate' from search engines has gone
virtually to zero as Altavista, Hotbot etc. removed me from their indexes -
they don't index .php files as far as I can see, and also don't follow links
on php pages (I imagine it's the same for ASP, ColdFusion etc.). In contrast
Google and All The Web have no problems with the .php extension (and even
index my .pdf files!).
I would be grateful for any wisdom on how best to deal with this. I could of
course make an HTML intro page, but that would be a pity since I'd hardly be
able to an intro page that conveys all the necessary info to bring the right
visitors. Any advice on how to do this well? I could alternatively change
the setting of the PHP parser to parse all .html as if it's php.
Unfortunately I'm sharing a server right now and my ISP is unlikely to
accept this because of the reduction in performance (I may be prepared to
move to a dedicated server if necessary though). Lastly I thought of writing
a PHP routine that, run once a day, will make a few HTML 'mirror' pages
based on the content of the database to capture the search engine visitors.
I could do that, but it seems to defeat the purpose of the dynamic pages
somewhat... pity.
Any other ideas? How do others deal with this issue?
Regards
Grant
---
Grant Ballard-Tremeer,
HEDON Household Energy Network http://www.ecoharmony.net/hedon/
eco Ltd. http://ecoharmony.com
---
--
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]
Mulder Technisch Advies
Postbus 69
NL-2740 AB WADDINXVEEN
tel. 0182-640184 fax. 0182-640185
http://www.mta.nl
--
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]
