Re: [PHP-DB] Real Killer App!
At 01:58 3/14/2003, Nicholas Fitzgerald wrote: As you guys know I've been going around in circles with this spider app problem for a couple days. How would you do it? http://www.hotscripts.com/PHP/Scripts_and_Programs/Search_Engines/more3.html Start Here to Find It Fast!© - http://www.US-Webmasters.com/best-start-page/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] session and header(location....)
anyway if header(location) does not work, you can insert a small hidden form into the login-checking page, and if login/password is correct, just set body.onLoad event handler to HIDDENFORM.submit(); , where HIDDENFORM is your small hidden form. Ok. i know it is a weird way to solve your problem :-(. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PROGRESS via PHP
Does anybody have experience of using PROGRESS with PHP? Or, may be any links to people who have? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with passing variables in PHP
I'm a beginner in PHP and Database connections I'm accessing a MS Access database using PHP. Everything is working fine. I get the data through an ODBC query and show it on an HTML format form so that I can modify the data and re-post it. I tried to pass the values to a second php file that has the updating query but no luck. My PHP didn't accept passing variables at all. I'm using PHP 4.3.1 on IIS 5.1 server, I even tried Apatche2 with no luck. Is there a way to run an update query using data from a form in the same page without the need for passing it to another page?, and what is wrong with my server not allowing me to pass variables, is there a parameter in the server I should set on? Here is a test example for passing a variable that failed: File 1: Test Passing a variable ?PHP echo html\n; echo body\n; echo form name=\Update\ method=\post\ ACTION=\update.php\\n; echo p align=\right\INPUT type=\text\ NAME=\sname\ VALUE=\$sname\ SIZE=30/td\n; echo PINPUT TYPE=\submit\ NAME=\submit\ VALUE=\Send\/p\n; echo /FORM\n; echo /body\n; echo /html\n; ? File 2: update.php ?php echo html\n; echo body\n; if (isset($sname)) { print($sname); } else { print (No data yet\n); } echo /body\n; echo /html\n; ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Real Killer App!
I've already looked at all of these, well most of them anyway. The only one's I haven't looked at are the ones that just do real time searches. Nothing of what I've seen is as functional as what I've designed, and for the post part built. Which is why I built it. This spider issue is the only thing that remains to be done. I'm currently using mnoGoSearch on an existing search engine I have, but I had to do a lot of work to get it to A: act like one would expect a search engine to act, and B: integrate into the site the way I wanted it. A lot of it was stuff I shouldn't have had to do. Besides, the spider is slow as hell, and only works on linux, unless I want to pay $100's for the windows version. Not that that's necessarily a problem, but I would like to have that option. The spider I've written, except for this problem I'm having, is much faster on windows than mnoGoSearch is on linux! As soon as I hit the send button here I'm going to be installing on a linux server and see if I have the same problem. Nick W. D. wrote: At 01:58 3/14/2003, Nicholas Fitzgerald wrote: As you guys know I've been going around in circles with this spider app problem for a couple days. How would you do it? http://www.hotscripts.com/PHP/Scripts_and_Programs/Search_Engines/more3.html Start Here to Find It Fast!© - http://www.US-Webmasters.com/best-start-page/
RE: [PHP-DB] Problem with passing variables in PHP
On update.php, you need to refer to the varibles passed from the first page like so: $_POST[varname]. I think that'll fix your problem. -Original Message- From: Mazin Albahkali [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 11:08 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Problem with passing variables in PHP I'm a beginner in PHP and Database connections I'm accessing a MS Access database using PHP. Everything is working fine. I get the data through an ODBC query and show it on an HTML format form so that I can modify the data and re-post it. I tried to pass the values to a second php file that has the updating query but no luck. My PHP didn't accept passing variables at all. I'm using PHP 4.3.1 on IIS 5.1 server, I even tried Apatche2 with no luck. Is there a way to run an update query using data from a form in the same page without the need for passing it to another page?, and what is wrong with my server not allowing me to pass variables, is there a parameter in the server I should set on? Here is a test example for passing a variable that failed: File 1: Test Passing a variable ?PHP echo html\n; echo body\n; echo form name=\Update\ method=\post\ ACTION=\update.php\\n; echo p align=\right\INPUT type=\text\ NAME=\sname\ VALUE=\$sname\ SIZE=30/td\n; echo PINPUT TYPE=\submit\ NAME=\submit\ VALUE=\Send\/p\n; echo /FORM\n; echo /body\n; echo /html\n; ? File 2: update.php ?php echo html\n; echo body\n; if (isset($sname)) { print($sname); } else { print (No data yet\n); } echo /body\n; echo /html\n; ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Problem with passing variables in PHP
I am sure someone else will beat me to this but here is an example update.php --- ?php echo html\n; echo body\n; //add this to assign POST to a variable you can use on this page $sname=$_POST[sname] //that will give you an idea of what to do if (isset($sname)) { print($sname); } else { print (No data yet\n); } echo /body\n; echo /html\n; ? -Original Message- From: Mazin Albahkali [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:08 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Problem with passing variables in PHP I'm a beginner in PHP and Database connections I'm accessing a MS Access database using PHP. Everything is working fine. I get the data through an ODBC query and show it on an HTML format form so that I can modify the data and re-post it. I tried to pass the values to a second php file that has the updating query but no luck. My PHP didn't accept passing variables at all. I'm using PHP 4.3.1 on IIS 5.1 server, I even tried Apatche2 with no luck. Is there a way to run an update query using data from a form in the same page without the need for passing it to another page?, and what is wrong with my server not allowing me to pass variables, is there a parameter in the server I should set on? Here is a test example for passing a variable that failed: File 1: Test Passing a variable ?PHP echo html\n; echo body\n; echo form name=\Update\ method=\post\ ACTION=\update.php\\n; echo p align=\right\INPUT type=\text\ NAME=\sname\ VALUE=\$sname\ SIZE=30/td\n; echo PINPUT TYPE=\submit\ NAME=\submit\ VALUE=\Send\/p\n; echo /FORM\n; echo /body\n; echo /html\n; ? File 2: update.php ?php echo html\n; echo body\n; if (isset($sname)) { print($sname); } else { print (No data yet\n); } echo /body\n; echo /html\n; ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Real Killer App!
Have you tried adding a flush() statement in at certain points? Perhaps put one in after every page is processed. Technically this is designed for browsers, but perhaps it will help here. It will most likely slow things down, but if it works, then you can adjust it from there (like every 10 pages or so). As another long shot, you may try using clearstatcache() also. You don't want to cache any files you are processing, but PHP may be doing this anyway. On Thursday, March 13, 2003, at 02:59 PM, Nicholas Fitzgerald wrote: Actually, that was the first thing I thought of. So I set set_time_limit(0); right at the top of the script. Is it possible there is another setting for this in php.ini that I also need to deal with? I have other scripts running and I don't want to have an unlimited execution time on all of them. Nick -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] gd library
Hi to all, I just installed PHP 4.3.1 on a windows 2000 machine. Everything works fine except for graphics. I can't generate graphics. I copy the php.ini to C:\WINNT\system and uncommented the line for php_gd.dll library, but still I can't make to work. I keep getting the following error: Call to undefined function: imagecreate() in c:\inetpub\wwwroot\php\lines.php on line 22 below is the code that I'm working with $height = 200; $width = 200; $im = ImageCreate($height, $width); $white = ImageColorAllocate ($im, 255, 255, 255); $black = ImageColorAllocate ($im, 0, 0, 0); // draw on image ImageFill($im, 0, 0, $black); ImageLine($im, 0, 0, $width, $height, $white); ImageString($im, 4, 50, 150, Sales, $white); // output image Header (Content-type: image/png); ImagePng ($im); // clean up ImageDestroy($im); Any help is greatly appreciate Thanks Nato ~~~ Nato Castro Web Development COmputing TechnologieS, Inc. (CoTs) 3028 Javier Road, Suite 400 Fairfax, VA 22031 Tel: 703.280.8800 ext.1205 ~~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Real Killer App!
I did try a flush table on the table, even down to for every read or write with no luck. Haven't tried the clearstatcache() though, sounds like an idea who's time has come. Nick Brent Baisley wrote: Have you tried adding a flush() statement in at certain points? Perhaps put one in after every page is processed. Technically this is designed for browsers, but perhaps it will help here. It will most likely slow things down, but if it works, then you can adjust it from there (like every 10 pages or so). As another long shot, you may try using clearstatcache() also. You don't want to cache any files you are processing, but PHP may be doing this anyway. On Thursday, March 13, 2003, at 02:59 PM, Nicholas Fitzgerald wrote: Actually, that was the first thing I thought of. So I set set_time_limit(0); right at the top of the script. Is it possible there is another setting for this in php.ini that I also need to deal with? I have other scripts running and I don't want to have an unlimited execution time on all of them. Nick -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Special Characters
Hi I am a bit of a newbie to some of this... but I have an issue where I need to read in a file that contains German characters and display them in a browser.. It appears the german ß (ss) gets translated etc I have tried get_html_translation_table(HTML_ENTITIES) and htmlentities() I am using the latest PHP 4.3.2 on OSX My example code is: ?php $filename=/Library/WebServer/Documents/aointernational/datasource/test.xml; $data = (file_get_contents($filename)); print $data; ? Any help would be great! TIA Daz -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] problem connecting w/ODBC
Hello, I am having problems accessing a database through ODBC. I first sent an email describing my problems accessing an MS Access database through PHP. Today I installed MySQL. I have no problems accessing my test database with the mysql commands. I downloaded MySQL's ODBC driver. I get the same error message trying to access this database w/ODBC as I did with the MS Access database. I am running Windows XP Professional, PHP 4.3.1, and Apache 1.3.27. Here's my PHP code: $connection = odbc_connect(testmysql, , ) or die (Couldn't connect to the server.); $sql = SELECT * FROM member; $result = odbc_exec($sql,$connection) or die (Couldn't execute query); I get the following error message in my browser: Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in c:\program files\apache group\apache\htdocs\test4.php on line 17 Couldn't execute query Anyone have any ideas of what I should do so I can access a database through ODBC? -- Beverly Steiner [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: MySQL JOIN problem
SELECT a.report_id, a.lib_id, a.exclude, b.lib_name, b.city FROM reportinfo a LEFT JOIN libinfo b ON a.lib_id = b.lib_id WHERE reportinfo.quarter != '0' the above statement will return ALL values within the reportinfo table that have a quarter value NOT set to 0. it will return the relevant lib_name and city from the libinfo table, through the left join. if you want to only display reportinfo items that have a libinfo entry, you will want to use the INNER JOIN instead. also note that the aliases of 'a' and 'b' correspond to reportinfo and libinfo. They are set simply by declaring the alternate name after first referencing the tables hope this helps, Cam Rob Day [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I'm having trouble getting the results I want. The database deals with libraries and reports they've submitted. Here are the relevant tables with the primary keys marked with a star (*): +--+ | libinfo | +--+ | lib_id* | | lib_name | | city | +--+ +---+ | reportinfo| +---+ | report_id*| | lib_id| | exclude | | quarter | +---+ In reportinfo.quarter there are currently two possible values, 0 and 2. I want libinfo.lib_name and libinfo.city for all entries in libinfo, where libinfo.lib_id = reportinfo.lib_id, that do not have an entry in reportinfo where reportinfo.quarter = 0. I don't care if there is an entry in reportinfo where quarter = 2. Can someone please help me construct this query? Thanks. -Rob P.S. I realize that this question has nothing to do with PHP. But be assured that this is one small part of a PHP/MySQL web application. Thank you for your indulgence. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] How to insert image in image ?
Hi, i have one image of some building . i want to insert an animated image which can indicate the path of particular bulding by the image movement.Its very urgent.Any idea and suggestion are welcomed. Thanks in advance. with regards, Rajni Arya -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] transfer files that doesent exists
Hi all, I'm about to make an open source backup module that works on php... The thing i want is for php to execute this command tar cvzfp backup.tar.gz dir/* BUT IN A SPECIAL WAY! I don't want the file backup.tar.gz to be on the server, it's supposed to either be deleted as fast as the user downloaded the file, or best of all, i want php to do something with the command such that it is ONLY output, and might be in the headerdoes anyone know how to do that ?? If i did'nt explain right please let me know And thanks. Lars Rasmussen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php