Re: [PHP-DB] Php 5 and Mysql on Windows
[EMAIL PROTECTED] wrote: That solved it. Awesome. Thanks you so much. Brian - A 'phpinfo()' test page is almost essential. When you make changes to the php.ini file you can check they have taken ;) -- Lester Caine - G8HFL - L.S.Caine Electronic Services - http://home.lsces.co.uk Model Engineers Digital Workshop - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/ Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to stop the server timing out
hmm, you can edit your php.ini there is max_execution_time or in header of your php file put *ini_set* ( max_execution_time, string newvalue ) Bastien Koert napisaĆ(a): You need to just start adding echo statements to the code to see where the hang up is Bastien From: David Skyers [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] How to stop the server timing out Date: Tue, 3 Oct 2006 11:51:30 +0100 Hi, I have written a php page and every time I run it, it causes the server to times-out. Is there anything I can do, to get the page to run completely or speed up how the page works. Please note I do not have any control over the server. The page does a select from a table and inserts the data into another table. However it times-out half way through inserting. The code is attached. Thanks, David David Skyers Support Analyst Management Systems, EISD, UCL Extension: 41849 Tel: 020 7679 1849 Email: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Pozdrawiam Szymon Fornal Bild Presse Polska s.c. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- e-mail: [EMAIL PROTECTED] GG: 1234713 ICQ: 208408766 mobile: (+48) 504049222 work: (+48) 042 6362632 w. 18 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to stop the server timing out
Hi, Is there anything I can do, to get the page to run completely sure, contact the hosting company to prolong the maximum execution time on that script or speed up how the page works maybe, but I dont see the source code The page does a select from a table and inserts the data into another table do you use insert ... select syntax? OKi98 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] problem with header()
Hi I can not submit any header() information in the following context. What is wrong within the code? ?php require_once includes/db.inc; require_once HTML/Template/ITX.php; if (!($connection = @ mysql_connect($hostname, $username, $password))) die(Could not connect to database); $status = mysqlclean($_GET, status, 1, $connection); $template = new HTML_Template_ITX(./templates); $template-loadTemplatefile(form2tpl.tpl, true, true); $template-setCurrentBlock(success); $template-setVariable(AUTOR, $_REQUEST[autor_eb]); $template-setVariable(STICHWORT, $_REQUEST[stichwort_eb]); $template-setVariable(DATUM, $_REQUEST[datum_eb]); $template-setVariable(ANLAGE, $_REQUEST[anlage_eb]); $template-setVariable(PROBLEM, $_REQUEST[problem_eb]); $template-parseCurrentBlock(); $template-show(); session_start(); foreach($_POST as $Key = $Value) { $_SESSION[$Key] = $Value; } if ($_POST['submit'] == Eintrag Bearbeiten){ header(Location: http://127.0.0.1/www2/knowledge_db/knowbase02.php;); exit; } ? Best regards, Joerg Kuehne
Re: [PHP-DB] problem with header()
On 10/4/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi I can not submit any header() information in the following context. What is wrong within the code? ?php require_once includes/db.inc; require_once HTML/Template/ITX.php; if (!($connection = @ mysql_connect($hostname, $username, $password))) die(Could not connect to database); $status = mysqlclean($_GET, status, 1, $connection); $template = new HTML_Template_ITX(./templates); $template-loadTemplatefile(form2tpl.tpl, true, true); $template-setCurrentBlock(success); $template-setVariable(AUTOR, $_REQUEST[autor_eb]); $template-setVariable(STICHWORT, $_REQUEST[stichwort_eb]); $template-setVariable(DATUM, $_REQUEST[datum_eb]); $template-setVariable(ANLAGE, $_REQUEST[anlage_eb]); $template-setVariable(PROBLEM, $_REQUEST[problem_eb]); $template-parseCurrentBlock(); $template-show(); session_start(); foreach($_POST as $Key = $Value) { $_SESSION[$Key] = $Value; } if ($_POST['submit'] == Eintrag Bearbeiten){ header(Location: http://127.0.0.1/www2/knowledge_db/knowbase02.php;); exit; } ? Best regards, Joerg Kuehne There must be NO output to the user, before any header(); calls. 1) Check the files you require() for any whitespaces before the ? tag 2) IF $template-show(); does what it says, you must start the session before that call. 3) Good luck :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] problem with header()
Hello thanks for your helping. But several things I already have checked. How I could force my code to make header() call effective. On 10/4/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi I can not submit any header() information in the following context. What is wrong within the code? ?php require_once includes/db.inc; require_once HTML/Template/ITX.php; if (!($connection = @ mysql_connect($hostname, $username, $password))) die(Could not connect to database); $status = mysqlclean($_GET, status, 1, $connection); $template = new HTML_Template_ITX(./templates); $template-loadTemplatefile(form2tpl.tpl, true, true); $template-setCurrentBlock(success); $template-setVariable(AUTOR, $_REQUEST[autor_eb]); $template-setVariable(STICHWORT, $_REQUEST[stichwort_eb]); $template-setVariable(DATUM, $_REQUEST[datum_eb]); $template-setVariable(ANLAGE, $_REQUEST[anlage_eb]); $template-setVariable(PROBLEM, $_REQUEST[problem_eb]); $template-parseCurrentBlock(); $template-show(); session_start(); foreach($_POST as $Key = $Value) { $_SESSION[$Key] = $Value; } if ($_POST['submit'] == Eintrag Bearbeiten){ header(Location: http://127.0.0.1/www2/knowledge_db/knowbase02.php;); exit; } ? Best regards, Joerg Kuehne There must be NO output to the user, before any header(); calls. 1) Check the files you require() for any whitespaces before the ? tag Already checked 2) IF $template-show(); does what it says, you must start the session before that call. I have correct that, but without success 3) Good luck :) thanks, is what I am need. Best regards, Joerg Kuhne To: [EMAIL PROTECTED] Cc: php-db@lists.php.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] How to stop the server timing out
Hi, Thanks, the echos causes the page to responds after each insert, so the server no longer times out. David -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: 04 October 2006 03:24 To: David Skyers; php-db@lists.php.net Subject: RE: [PHP-DB] How to stop the server timing out You need to just start adding echo statements to the code to see where the hang up is Bastien From: David Skyers [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] How to stop the server timing out Date: Tue, 3 Oct 2006 11:51:30 +0100 Hi, I have written a php page and every time I run it, it causes the server to times-out. Is there anything I can do, to get the page to run completely or speed up how the page works. Please note I do not have any control over the server. The page does a select from a table and inserts the data into another table. However it times-out half way through inserting. The code is attached. Thanks, David David Skyers Support Analyst Management Systems, EISD, UCL Extension: 41849 Tel: 020 7679 1849 Email: [EMAIL PROTECTED] -- 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
[PHP-DB] textarea value assignment
Hello how I could assign a textarea with a variable value? Although I tried to achieve an allocation like a normal input, but it does not work so I have no success with textarea. The code looks like following fragment. $problem_val = mysqlclean($_SESSION, problem_eb, 500, $connection); textarea style=width: 320px; height: 150px; heigth=30 width=50 cols=1 rows=1 name=problem_eb value=?php echo $problem_val?/textarea Best regards, Joerg Kuehne
[PHP-DB] PHP - MySQL webhosting
If anyone is interested in some VERY good webhosting that has support for PHP and MySQL, please take a look at the following link: http://www.sturdyhosting.com/idevaffiliate/idevaffiliate.php?id=100 They offer domain names for $8.95 and also webhositng solutions for as low as $2.95 per month. I hope that some of you are interested and can join the greatest webhosting company in the world!
Re: [PHP-DB] textarea value assignment
[EMAIL PROTECTED] wrote: Hello how I could assign a textarea with a variable value? Although I tried to achieve an allocation like a normal input, but it does not work so I have no success with textarea. The code looks like following fragment. $problem_val = mysqlclean($_SESSION, problem_eb, 500, $connection); textarea style=width: 320px; height: 150px; heigth=30 width=50 cols=1 rows=1 name=problem_eb value=?php echo $problem_val?/textarea Best regards, Joerg Kuehne There is no value attribute of textarea...to put text in there, you place it between the textarea/textarea tags. i.e. textarea style=width: 320px; height: 150px; heigth=30 width=50 cols=1 rows=1 name=problem_eb ?php echo $problem_val; ?/textarea -B -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP - MySQL webhosting
If anyone is interested in some VERY good webhosting that has support for PHP and MySQL, please take a look at the following link: http://www.sturdyhosting.com/idevaffiliate/idevaffiliate.php?id=100 They offer domain names for $8.95 and also webhositng solutions for as low as $2.95 per month. I hope that some of you are interested and can join the greatest webhosting company in the world!
Re: [PHP-DB] textarea value assignment
Brad Bonkoski wrote: [EMAIL PROTECTED] wrote: Hello how I could assign a textarea with a variable value? Although I tried to achieve an allocation like a normal input, but it does not work so I have no success with textarea. The code looks like following fragment. $problem_val = mysqlclean($_SESSION, problem_eb, 500, $connection); textarea style=width: 320px; height: 150px; heigth=30 width=50 cols=1 rows=1 name=problem_eb value=?php echo $problem_val?/textarea Best regards, Joerg Kuehne There is no value attribute of textarea...to put text in there, you place it between the textarea/textarea tags. i.e. textarea style=width: 320px; height: 150px; heigth=30 width=50 cols=1 rows=1 name=problem_eb ?php echo $problem_val; ?/textarea Also worth mentioning that you may run into problems if you don't use htmlentities on $problem_val, like so... textarea style=width: 320px; height: 150px; heigth=30 width=50 cols=1 rows=1 name=problem_eb ?php echo htmlentities($problem_val); ?/textarea -Stut -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] textarea value assignment
Hi I will try it. Many thanks in any case. [EMAIL PROTECTED] wrote: Hello how I could assign a textarea with a variable value? Although I tried to achieve an allocation like a normal input, but it does not work so I have no success with textarea. The code looks like following fragment. $problem_val = mysqlclean($_SESSION, problem_eb, 500, $connection); textarea style=width: 320px; height: 150px; heigth=30 width=50 cols=1 rows=1 name=problem_eb value=?php echo $problem_val?/ textarea Best regards, Joerg Kuehne There is no value attribute of textarea...to put text in there, you place it between the textarea/textarea tags. i.e. textarea style=width: 320px; height: 150px; heigth=30 width=50 cols=1 rows=1 name=problem_eb ?php echo $problem_val; ?/textarea -B -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php best regards, George To: [EMAIL PROTECTED] Cc: php-db@lists.php.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] textarea value assignment
If anyone is interested in some VERY good webhosting that has support for PHP and MySQL, please take a look at the following link: http://www.sturdyhosting.com/idevaffiliate/idevaffiliate.php?id=100 They offer domain names for $8.95 and also webhositng solutions for as low as $2.95 per month. I hope that some of you are interested and can join the greatest webhosting company in the world! On 10/4/06, Stut [EMAIL PROTECTED] wrote: Brad Bonkoski wrote: [EMAIL PROTECTED] wrote: Hello how I could assign a textarea with a variable value? Although I tried to achieve an allocation like a normal input, but it does not work so I have no success with textarea. The code looks like following fragment. $problem_val = mysqlclean($_SESSION, problem_eb, 500, $connection); textarea style=width: 320px; height: 150px; heigth=30 width=50 cols=1 rows=1 name=problem_eb value=?php echo $problem_val?/textarea Best regards, Joerg Kuehne There is no value attribute of textarea...to put text in there, you place it between the textarea/textarea tags. i.e. textarea style=width: 320px; height: 150px; heigth=30 width=50 cols=1 rows=1 name=problem_eb ?php echo $problem_val; ?/textarea Also worth mentioning that you may run into problems if you don't use htmlentities on $problem_val, like so... textarea style=width: 320px; height: 150px; heigth=30 width=50 cols=1 rows=1 name=problem_eb ?php echo htmlentities($problem_val); ?/textarea -Stut -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] problem with header()
Good morning Bastien mosts likely you have html output in the page somewhere, perhaps in the includes or it could be a blank space in one of the files that is above and outside the php tags many thanks, there was a prior header() call in one of my include files which prevent the second header() call. Furthermore I had to rearrange the session_start() task within the script and the include file. best regards, Joerg To: [EMAIL PROTECTED] php-db@lists.php.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php