RE: [PHP-DB] Need help with delete and modify functions on a form.
--- Bastien Koert <[EMAIL PROTECTED]> escribió: > something like this example > (http://www.weberdev.com/get_example-4085.html)? > > Bastien > Thanks Bastien, that would do the job, ill study it to adapt it to my needs. Another thing, i have some flash buttons, (im ussing dreamweaver), so once the records are displayed, user can filter the info lets say choosing the lastname filed, as its a precompiled button i only can specify a link. I saw once that with php you can specify pure code on the link funcion is there any chance to specify in the link section the filter code? like: SELECT * from mydatabase where lastname = 'john'??? i think it was a way but i can´t find it now?? Also, do you have any experience with checkbox on a form, i mean some tut?? Thanks. Juan. ___ 1GB gratis, Antivirus y Antispam Correo Yahoo!, el mejor correo web del mundo http://correo.yahoo.com.ar -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Need help with delete and modify functions on a form.
something like this example (http://www.weberdev.com/get_example-4085.html)? Bastien From: Juan Stiller <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] Need help with delete and modify functions on a form. Date: Mon, 17 Oct 2005 13:04:51 -0300 (ART) Hi, i ´ve got a php page that shows records from a database (mysql), basically the php code retrieve info from the database and display it, and with some htm i ´ve made a table to show the recods, i need to add several things to the page, but i´ve no idea how to... A) I need to add a modify command B) A delete command. C) If its possible i would like to add radio buttons on each record, so people can mark and delete more than one message at a time. Can anyone help me with the php code or recommend a good tutorial to doing this changes?? Thanks in advance. Juan. ___ 1GB gratis, Antivirus y Antispam Correo Yahoo!, el mejor correo web del mundo http://correo.yahoo.com.ar -- 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] Need help with delete and modify functions on a form.
Hi, i ´ve got a php page that shows records from a database (mysql), basically the php code retrieve info from the database and display it, and with some htm i ´ve made a table to show the recods, i need to add several things to the page, but i´ve no idea how to... A) I need to add a modify command B) A delete command. C) If its possible i would like to add radio buttons on each record, so people can mark and delete more than one message at a time. Can anyone help me with the php code or recommend a good tutorial to doing this changes?? Thanks in advance. Juan. ___ 1GB gratis, Antivirus y Antispam Correo Yahoo!, el mejor correo web del mundo http://correo.yahoo.com.ar -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Limited connections to the database
Some good ideas in this (http://marc.theaimsgroup.com/?l=php-dev&m=98193543028899&w=2) post... Here is one (http://www.oracle.com/technology/pub/articles/deployphp/lim_deployphp.html) from oracle on this as well Bastien From: "Marcos R. Cardoso" <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] Limited connections to the database Date: Mon, 17 Oct 2005 07:36:41 -0300 Hello to everyone, we have been using an Apache server here at work (I work in a Library) where PHP/ASP scripts query the database very frequently (in the near future only PHP scripts will be used). The DBAs have recently complained that our webserver is performing the queries in a high speed and many times in a second. It worried them and they are asking if we could limit the connections to the database to a low number. As an example they told us that other applications in other webserver uses Tomcat to run Java, and there they managed to limit the number of active connections at the same time. I would like to know if it's possible to make something similar, and I'd like to know too if we have to configure the PHP or the Apache. Our environment is listed below: Windows 2003 Server Apache 2.0.54 PHP 4.4.0 Sun Chili!Soft ASP 3.6.2 MySQL 4.0.20a Oracle 9i (through a Oracle 8i NetClient) TIA, Marcos R. Cardoso Blumenau Brazil -- 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] Link Selected
Its really more of a js problem, youonly need PHP to populate the vairous JS arrays. I use this (http://www.mattkruse.com/javascript/dynamicoptionlist/) js code to make the population happen and it works well and I found it easy to integrate... Bastien From: <[EMAIL PROTECTED]> To: Subject: RE: [PHP-DB] Link Selected Date: Mon, 17 Oct 2005 15:46:01 +0900 Dear All, I am a new PHP programmer. I need help from all of you. I want to make Linked ComboBox between 2 or more ComboBoxs (connect to Database). For example: When I clicked the main field, the sub items field will display the data automatically on other ComboBox. Are there somebody could help me? Thank You & Regards, Anita -- 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] Limited connections to the database. .
http://www.google.com/search?q=oracle+limit+client+connections http://www.oracle.com/technology/pub/articles/php_experts/scaling_oracle _and_php.html Summary - either you're not using persistent connections, or your site is just very busy. If it's just that the site is busy, best you can do is just limit things on the website end. If the problem is no persistent connections - then you'll want to switch them on if you're doing multiple queries/page. You also want to make sure any information that doesn't need to be pulled from the database isn't (perhaps there are some global settings/etc. that change once a month, cache them globally somewhere and don't keep requesting them so often) - there may not be any such data, but then again, there may be. cheers, - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -Original Message- From: Marcos R. Cardoso [mailto:[EMAIL PROTECTED] Sent: Monday, October 17, 2005 5:37 AM To: php-db@lists.php.net Subject: [PHP-DB] Limited connections to the database. . Hello to everyone, we have been using an Apache server here at work (I work in a Library) where PHP/ASP scripts query the database very frequently (in the near future only PHP scripts will be used). The DBAs have recently complained that our webserver is performing the queries in a high speed and many times in a second. It worried them and they are asking if we could limit the connections to the database to a low number. As an example they told us that other applications in other webserver uses Tomcat to run Java, and there they managed to limit the number of active connections at the same time. I would like to know if it's possible to make something similar, and I'd like to know too if we have to configure the PHP or the Apache. Our environment is listed below: Windows 2003 Server Apache 2.0.54 PHP 4.4.0 Sun Chili!Soft ASP 3.6.2 MySQL 4.0.20a Oracle 9i (through a Oracle 8i NetClient) TIA, Marcos R. Cardoso Blumenau Brazil -- 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] 电子传单,最廉价的宣传方式
I don't think this list requires you to be subscribed to post, does it? [ 0FF T0PIC ] Judging from the mail address (which can be forged by a 2yr old) - I'd say it was entirely automated. What I don't get, is why messages like this get sent at all... Crossed long time, be out of control loudly to say: "Deity elder sister elder sister, you if can exactly with me say a speech, I then die for you 1,000, 10,000, also like the body ascends the throne happy, likes infinite." Suddenly the double knee knelt down, has done obeisance. Qiu Chuji said that, "North 斗大 socializes with all one's strength with you, two evil spirits leaders one group of evildoers, are taking advantage of a an opening overrun to in front of the Double Ninth Festival palace. They as soon as come up set on fire burn view, the Hao fellow go forth to battle with that Huo all prince begin. Also is he too has a low opinion of the enemy, but the Huo Du Wugong also has a distinctive style, is strange especially really. The Hao fellow gets rid of when presently is slightly irritable, the chest has hit a his palm. Our busy knot protects. Only has been short Hao a fellow person, made up the disciple skill difference too was far, the law might then was limitedly. You if are inferior to time rushes, all really taught today 当真 is collapses completely. Now wants to come, calculated defends under the mountain the numerous disciples have not admitted mistakes the enemy, these two flows 妖人 no doubt is unable to climb mountains, reaches your Pakistan and the Huo Tu-2 person actually eventually prevents. This two people collaborate with dubhe to fight, we lose are cannot lose, but can like you win cleanly in no way is refreshed... ... " Is speaking of here, suddenly listens to the west cry cry resounding, some people move the bugle. Angle sound desolate intense, Guo Jing listens in the ear, cannot help but the heart steps the Yin, turns one's thoughts toward a loved one the desert, remembered the Mongolian yellow sand to be luxuriant, the campaign 无际 scenery. What's the point in that? Seriously. cheers, - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -Original Message- From: KOKO电子传单 [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 8:01 PM To: php-db@lists.php.net Subject: [PHP-DB] 电子传单,最廉价的宣传方式.. 过了良久,禁不住大声说道:“神仙姊姊,你若能活过来跟我说一句话,我便为你死一千遍,一万遍,也如身登极乐,欢喜无限。”突然双膝跪倒,拜了下去。 丘处机道:“北斗大阵全力与你周旋,两个魔头领着一批奸人,乘隙攻到重阳宫前。他们一上来就放火烧观,郝师弟出阵与那霍都王子动手。也是他过于轻敌,而霍都的武功又别具一格,怪异特甚。郝师弟出手时略现急躁,胸口中了他一掌。我们忙结阵相护。只是少了郝师弟一人,补上来的弟子功力相差太远,阵法威力便属有限。你若不及时赶到,全真教今日当真是一败涂地了。现下想来,就算守在山下的众弟子不认错了敌人,那些二流妖人固然无法上山,达尔巴与霍都二人却终究阻挡不住。此二人联手与北斗阵相斗,我们输是不会输的,但决不能如你这般赢得乾净爽快……”正说到这里,忽听西边鸣鸣鸣一阵响亮,有人吹动号角。角声苍凉激越,郭靖听在耳中,不由得心迈阴山,神驰大漠,想起了蒙古黄沙莽莽、平野无际的风光。 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Limited connections to the database
Hello to everyone, we have been using an Apache server here at work (I work in a Library) where PHP/ASP scripts query the database very frequently (in the near future only PHP scripts will be used). The DBAs have recently complained that our webserver is performing the queries in a high speed and many times in a second. It worried them and they are asking if we could limit the connections to the database to a low number. As an example they told us that other applications in other webserver uses Tomcat to run Java, and there they managed to limit the number of active connections at the same time. I would like to know if it's possible to make something similar, and I'd like to know too if we have to configure the PHP or the Apache. Our environment is listed below: Windows 2003 Server Apache 2.0.54 PHP 4.4.0 Sun Chili!Soft ASP 3.6.2 MySQL 4.0.20a Oracle 9i (through a Oracle 8i NetClient) TIA, Marcos R. Cardoso Blumenau Brazil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Link Selected
There are some possibilities: 1) Define a link to the same page in your first combobox (.. and execute him when he is selected (with Javascript). Be sure that you take the value off the selected item to the folowing page. Your second combi will be reloaded and here you fill the value in the where clause 2) The disadvantage off the first solution is that your page is reloaded, this way you lose the values that are allready fild in. A way to avoid that is to work with popups. Work with a link to the popup in the first combo. Let the query be exetuted in the popup and put the values with Javascript in the second combo. (opener.document.form.fourni.options[opener.document.form.fourni.selectedIndex].value) 3) Load all the possibilties in javascript arrays and then point to them Regards Koen On 17/10/05, Micah Stevens <[EMAIL PROTECTED]> wrote: > > Sounds like more of a Javascript problem than a PHP one. Maybe some Ajax to > get the updates? > > On Sunday 16 October 2005 11:46 pm, [EMAIL PROTECTED] wrote: > > Dear All, > > > > I am a new PHP programmer. I need help from all of you. > > > > I want to make Linked ComboBox between 2 or more ComboBoxs (connect to > > Database). > > For example: > > When I clicked the main field, the sub items field will display the data > > automatically on other ComboBox. > > > > Are there somebody could help me? > > > > Thank You & Regards, > > > > Anita > > -- > 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] Link Selected
Sounds like more of a Javascript problem than a PHP one. Maybe some Ajax to get the updates? On Sunday 16 October 2005 11:46 pm, [EMAIL PROTECTED] wrote: > Dear All, > > I am a new PHP programmer. I need help from all of you. > > I want to make Linked ComboBox between 2 or more ComboBoxs (connect to > Database). > For example: > When I clicked the main field, the sub items field will display the data > automatically on other ComboBox. > > Are there somebody could help me? > > Thank You & Regards, > > Anita -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Link Selected
Dear All, I am a new PHP programmer. I need help from all of you. I want to make Linked ComboBox between 2 or more ComboBoxs (connect to Database). For example: When I clicked the main field, the sub items field will display the data automatically on other ComboBox. Are there somebody could help me? Thank You & Regards, Anita -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php