[PHP-DB] LDAP connexions
Hi! I need some information about php LDAP capabilities. I'm interested in managing LDAP connexions as ora_plogon manage the ORACLE ones. Theses connexions are used in order to manipulate the database (not only for authentications). We must be sure that there are too many connexions created and that we don't often load LDAP server with connexions/deconnexions. In the JAVA world, WebSphere give possibilities to do this for oracle and LDAP. I know (or I believe it) PHP don't have a context manager in order to manage a pool of process but I don't know how the oracle pool is managed. That's why I think there's somewhere a useful method to manage an LDAP pool too. Thanks in advance. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Email Form
I am new to PHP and need some help with an form mail problem. Basically i know how to get a form to submit data to MySQL and I know how email the content of a form. But how do i get a form to do both? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Email Form
Hi, Combine the two scripts Begin script Accept the post variables Insert them into the database Mail them End script jack -Original Message- From: Philip O'Rourke [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Email Form I am new to PHP and need some help with an form mail problem. Basically i know how to get a form to submit data to MySQL and I know how email the content of a form. But how do i get a form to do both? -- 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] Unsuscribe
Re: [PHP-DB] Need to Run a PHP script using CRON or ?
El Lun 15 Sep 2003 17:47, Jonathan Villa escribió: I believe this would need php to installed as a cgi, which I prefer not to do... If you don't want to because of security resons, please install it and don't leave it in the hands of the web server. If you don't want to go through the problem of compiling, then you might think about finding on the net a binary PHP for you operating system. -- 08:55:02 up 25 days, 45 min, 4 users, load average: 0.71, 0.51, 0.50 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Email Form
Hi Jcck, here is an example of how I'm connecting to the database to complete a registration process. What I'm trying to get at is where to insert the relevant email code. ?php require_once('../Connections/casu.php'); ??php session_start(); function GetSQLValueString($theValue, $theType, $theDefinedValue = , $theNotDefinedValue = ) { $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue; switch ($theType) { case text: $theValue = ($theValue != ) ? ' . $theValue . ' : NULL; break; case long: case int: $theValue = ($theValue != ) ? intval($theValue) : NULL; break; case double: $theValue = ($theValue != ) ? ' . doubleval($theValue) . ' : NULL; break; case date: $theValue = ($theValue != ) ? ' . $theValue . ' : NULL; break; case defined: $theValue = ($theValue != ) ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } $editFormAction = $HTTP_SERVER_VARS['PHP_SELF']; if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) { $editFormAction .= ? . $HTTP_SERVER_VARS['QUERY_STRING']; } if ((isset($HTTP_POST_VARS[MM_update])) ($HTTP_POST_VARS[MM_update] == form1)) { $updateSQL = sprintf(UPDATE users SET user_name=%s, fName=%s, sName=%s, job=%s, org=%s, org_type=%s, address=%s, postCode=%s, tel=%s, email=%s, c_of_c=%s, newsletter=%s, appTime=%s, group_id=%s, status=%s, drowssap=%s WHERE id=%s, GetSQLValueString($HTTP_POST_VARS['user_name'], text), GetSQLValueString($HTTP_POST_VARS['fName'], text), GetSQLValueString($HTTP_POST_VARS['sName'], text), GetSQLValueString($HTTP_POST_VARS['job'], text), GetSQLValueString($HTTP_POST_VARS['org'], text), GetSQLValueString($HTTP_POST_VARS['org_type'], text), GetSQLValueString($HTTP_POST_VARS['address'], text), GetSQLValueString($HTTP_POST_VARS['postCode'], text), GetSQLValueString($HTTP_POST_VARS['tel'], text), GetSQLValueString($HTTP_POST_VARS['email'], text), GetSQLValueString(isset($HTTP_POST_VARS['c_of_c']) ? true : , defined,'Y','N'), GetSQLValueString(isset($HTTP_POST_VARS['newsletter']) ? true : , defined,'Y','N'), GetSQLValueString($HTTP_POST_VARS['appTime'], date), GetSQLValueString($HTTP_POST_VARS['group_id'], int), GetSQLValueString($HTTP_POST_VARS['status'], int), GetSQLValueString($HTTP_POST_VARS['drowssap'], text), GetSQLValueString($HTTP_POST_VARS['id'], int)); mysql_select_db($database_casu, $casu); $Result1 = mysql_query($updateSQL, $casu) or die(mysql_error()); $updateGoTo = new_member.php; if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) { $updateGoTo .= (strpos($updateGoTo, '?')) ? : ?; $updateGoTo .= $HTTP_SERVER_VARS['QUERY_STRING']; } header(sprintf(Location: %s, $updateGoTo)); } ? ?php $varSearch_rsUserDetails = 1; if (isset($HTTP_SESSION_VARS['userSession'])) { $varSearch_rsUserDetails = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['userSession'] : addslashes($HTTP_SESSION_VARS['userSession']); } mysql_select_db($database_casu, $casu); $query_rsUserDetails = sprintf(SELECT * FROM users WHERE id = '%s', $varSearch_rsUserDetails); $rsUserDetails = mysql_query($query_rsUserDetails, $casu) or die(mysql_error()); $row_rsUserDetails = mysql_fetch_assoc($rsUserDetails); $totalRows_rsUserDetails = mysql_num_rows($rsUserDetails); ? html head titleUntitled Document/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form method=post name=form1 action=?php echo $editFormAction; ? table align=center tr valign=baseline td nowrap align=rightId:/td td?php echo $row_rsUserDetails['id']; ?/td /tr tr valign=baseline td nowrap align=rightUser_name:/td tdinput type=text name=user_name value=?php echo $row_rsUserDetails['user_name']; ? size=32 /td /tr tr valign=baseline td nowrap align=rightFName:/td tdinput type=text name=fName value=?php echo $row_rsUserDetails['fName']; ? size=32 /td /tr tr valign=baseline td nowrap align=rightSName:/td tdinput type=text name=sName value=?php echo $row_rsUserDetails['sName']; ? size=32 /td /tr tr valign=baseline td nowrap align=rightJob:/td tdinput type=text name=job value=?php echo $row_rsUserDetails['job']; ? size=32 /td /tr tr valign=baseline td nowrap align=rightOrg:/td tdinput type=text name=org value=?php echo $row_rsUserDetails['org']; ? size=32 /td /tr tr valign=baseline td nowrap align=rightOrg_type:/td tdinput type=text name=org_type value=?php echo $row_rsUserDetails['org_type']; ? size=32 /td /tr tr
Re: [PHP-DB] Email Form
My Last post seems to have generated some sort of spam alert, so I'll attach the file. Jacob A. Van Zanen [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, Combine the two scripts Begin script Accept the post variables Insert them into the database Mail them End script jack -Original Message- From: Philip O'Rourke [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Email Form I am new to PHP and need some help with an form mail problem. Basically i know how to get a form to submit data to MySQL and I know how email the content of a form. But how do i get a form to do both? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php begin 666 example.php M/#]P:' @F5Q=6ER95]O;F-E*N+B]#;VYN96-T:6]NR]C87-U+G!HI M.R _/CP_AP#0IS97-S:6]N7W-T87)T*D[#0H-F9U;F-T:6]N($=E=%-1 M3%9A;'5E4W1R:6YG*1T:5686QU92P@)'1H951Y4L(1T:5$969I;F5D M5F%L=64@/2 B(BP@)'1H94YO=$1E9FEN961686QU92 ]((B*2 -GL-B @ M)'1H959A;'5E([EMAIL PROTECTED]%G971?;6%G:6-?75O=[EMAIL PROTECTED] _(%D9'-L M87-H97,H)'1H959A;'5E*2 Z(1T:5686QU93L-@T*(!S=VET8V@@*1T M:547!E*2![#0H@( @8V%S92 B=5X=(Z#0H@( @( D=AE5F%L=64@ M/2 H)'1H959A;'5E($]((B*2 _((G(B N(1T:5686QU92 N((G(B Z M().54Q,(CL-B @( @()R96%K.R @( -B @(!C87-E()L;VYG(CH- MB @(!C87-E()I;[EMAIL PROTECTED]( @( @)'1H959A;'5E([EMAIL PROTECTED]1T:5686QU M92 A/2 B(BD@/R!I;G1V86PH)'1H959A;'5E*2 Z().54Q,(CL-B @( @ M()R96%K.PT*( @(-AV4@(F1O=6)L92(Z#0H@( @( D=AE5F%L=64@ M/2 H)'1H959A;'5E($]((B*2 _((G(B N(1O=6)L979A;@D=AE5F%L M=64I(X@(BB(#H@(DY53$PB.PT*( @( @8G)E86L[#0H@( @8V%S92 B M9%T92(Z#0H@( @( D=AE5F%L=64@/2 H)'1H959A;'5E($]((B*2 _ M((G(B N(1T:5686QU92 N((G(B Z().54Q,(CL-B @( @()R96%K M.PT*( @(-AV4@([EMAIL PROTECTED]( @( @)'1H959A;'5E([EMAIL PROTECTED]1T M:5686QU92 A/2 B(BD@/R D=AE15F:6YE9%9A;'5E(#H@)'1H94YO=$1E M9FEN961686QU93L-B @( @()R96%K.PT*(!]#0H@(')E='5R;B D=AE M5F%L=64[#0I]#0H-B1E9ET1F]R;4%C=EO;B ](1(5%107U-%4E9%4E]6 M05)36R=02%!?4T5,1B==.PT*:[EMAIL PROTECTED]ESV5T*1(5%107U-%4E9%4E]605)3 M6R=1545265]35%))3DG72DI('L-B @)5D:71;W)M06-T:6]N(X]((_ M(B N(1(5%107U-%4E9%4E]605)36R=1545265]35%))3DG73L-GT-@T* M:[EMAIL PROTECTED]AIW-E=@D2%144%]03U-47U9!4E-;(DU-7W5P9%T92)=*2D@)B8@ M*1(5%107U!/4U1?5D%24ULB34U?=7!D871E(ET@/3T@(F9OFTQ(BDI('L- MB @)'5P9%T95-13 ]('-PFEN=8H(E501$%412!UV5R[EMAIL PROTECTED] ME]N86UE/25S+!F3F%M93TERP@TYA;64])7,L(IO8CTERP@;W)G/25S M+!OF=?='EP93TE[EMAIL PROTECTED]F5SSTERP@]S=$-O94])7,L('1E;#TE M[EMAIL PROTECTED]:6P])7,L(-?;V9?8STERP@;F5WVQE='1ECTE[EMAIL PROTECTED]EM M93TE[EMAIL PROTECTED])O=7!?:60])7,L('-T871USTE[EMAIL PROTECTED]')O=W-S87 ])7,@5TA% M4D4@:60])7,B+ T*( @( @( @( @( @( @( @(!'971344Q686QU M95-T[EMAIL PROTECTED];)W5S97)?;F%M92==+ B=5X=(I M+ T*( @( @( @( @( @( @( @(!'971344Q686QU95-T[EMAIL PROTECTED] M2%144%]03U-47U9!4E-;)V9.86UE)UTL()T97AT(BDL#0H@( @( @( @ M( @( @( @( @($=E=%-13%9A;'5E4W1R:6YG*1(5%107U!/4U1?5D%2 M4ULGTYA;64G72P@(G1E'0B*2P-B @( @( @( @( @( @( @( @ M1V5T4U%,5F%L=653=')I;FH)$A45%!?4$]35%]605)36R=J;V(G72P@(G1E M'0B*2P-B @( @( @( @( @( @( @( @1V5T4U%,5F%L=653=')I M;FH)$A45%!?4$]35%]605)36R=OFG72P@(G1E'0B*2P-B @( @( @ M( @( @( @( @( @1V5T4U%,5F%L=653=')I;FH)$A45%!?4$]35%]6 M05)36R=OF=?='EP92==+ B=5X=(I+ T*( @( @( @( @( @( @ M( @(!'971344Q686QU95-T[EMAIL PROTECTED];)V%D9')E MW,G72P@(G1E'0B*2P-B @( @( @( @( @( @( @( @1V5T4U%, M5F%L=653=')I;FH)$A45%!?4$]35%]605)36R=P;W-T0V]D92==+ B=5X M=(I+ T*( @( @( @( @( @( @( @(!'971344Q686QU95-TFEN [EMAIL PROTECTED];)W1E;==+ B=5X=(I+ T*( @( @( @ M( @( @( @( @(!'971344Q686QU95-T[EMAIL PROTECTED] M4E-;)V5M86EL)UTL()T97AT(BDL#0H@( @( @( @( @( @( @( @ M($=E=%-13%9A;'5E4W1R:6YG*ESV5T*1(5%107U!/4U1?5D%24ULG8U]O M9E]C)UTI(#\@(G1R=64B(#H@(B(L()D969I;F5D(BPB)UDG(BPB)TXG(BDL M#0H@( @( @( @( @( @( @( @($=E=%-13%9A;'5E4W1R:6YG*ES MV5T*1(5%107U!/4U1?5D%24ULG;F5WVQE='1EB==*2 _()TG5E(B Z M((B+ B95F:6YE9(L(B=9)R(L(B=.)R(I+ T*( @( @( @( @( @ M( @( @(!'971344Q686QU95-T[EMAIL PROTECTED];)V%P M%1I;64G72P@(F1A=4B*2P-B @( @( @( @( @( @( @( @1V5T M4U%,5F%L=653=')I;FH)$A45%!?4$]35%]605)36R=GF]U%]I9==+ B M:6YT(BDL#0H@( @( @( @( @( @( @( @($=E=%-13%9A;'5E4W1R M:6YG*1(5%107U!/4U1?5D%24ULGW1A='5S)UTL()I;G0B*2P-B @( @ M( @( @( @( @( @( @1V5T4U%,5F%L=653=')I;FH)$A45%!?4$]3 M5%]605)36R=DF]WW-A==+ B=5X=(I+ T*( @( @( @( @( @ M( @( @(!'971344Q686QU95-T[EMAIL PROTECTED];)VED M)UTL()I;G0B*2D[#0H-B @;7ES6Q?V5L96-T7V1B*1D871A8F%S95]C M87-U+ D8V%S=2D[#0H@(1297-U;'0Q(#T@;7ES6Q?75EGDH)'5P9%T M95-13P@)-AW4I(]R(1I92AM7-Q;%]EG)O[EMAIL PROTECTED]@T*( D=7!D M871E1V]4;R ]()N97=?;65M8F5R+G!H([#0H@(EF(AIW-E=@D2%14 M4%]315)615)?5D%24ULG455%4EE?4U1224Y')UTI*2![#0H@( @)'5P9%T M94=O5[EMAIL PROTECTED]@*'-TG!O[EMAIL PROTECTED];RP@)S\G*2D@/R B)B(@.B B M/R([#0H@( @)'5P9%T94=O5[EMAIL PROTECTED]@)$A45%!?4T525D527U9!4E-;)U%5 M15)97U-44DE.1R==.PT*(!]#0H@(AE861EBAS')I;G1F*),;V-A=EO M;CH@)7,B+ D=7!D871E1V]4;RDI.PT*?0T*/SX-@T*/#]P:' -B1V87)3 M96%R8VA?G-5V5R15T86ELR ]((Q(CL-FEF(AIW-E=@D2%144%]3
[PHP-DB] Re: [PHP] MS-SQL 2000 weird problem
Solved the problem I changed the locales.conf file from freetds/etc I had spanish, i changed to us_english. I would like to use it in spanish cause when you use some spanish characters the application crashes. I don't know any other way to do it. [default] date format = %b %d %Y %I:%M%p [en_US] date format = %b %d %Y %I:%M%p language = us_english char set = iso_1 [es_ES] date format = %b %d %Y %I:%M%p language = us_english changed char set = iso_1 - Original Message - From: Dan Anderson [EMAIL PROTECTED] To: Martin Greco [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; PHP List [EMAIL PROTECTED] Sent: Monday, September 15, 2003 6:42 PM Subject: Re: [PHP] MS-SQL 2000 weird problem Any thoughts? Are you dying and outputting an error where something could happen to bodge up the server? I'm not familiar with MS SQL Server, but I know under mysql: ?php $link = mysql_connect($host,$username,$password) or die(); // I forget the next line off the top of my head /* returns null if $link didn't work and we didn't die */ $result = mysql_query(SELECT * FROM table); ? -Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Help connecting with oracle
Hi: I have a Oracle 7.3.3 on Unix, but in my computer (client) Windows 2000 i have a php source code that try to connect with this database. I test with TNSPING and SQLPLUS commands line, and connect with both susseffuly, but when i try to connect with php can't. I have a Apache server with php 4.2.2 i'm trying the follow code: ? if ($conn=Ora_Logon( [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] , webmaster)) { echo BSUCCESS ! Connected to databaseB\n; } else { echo BFailed :-( Could not connect to databaseB\n; } Ora_Logoff($conn); ? And the error is: Warning: Oracle: Connection Failed: in C:\FoxServ\www\conectar.php on line 2 Failed :-( Could not connect to database Warning: ora_logoff(): supplied argument is not a valid Oracle-Connection resource in C:\FoxServ\www\conectar.php on line 7 Help!!
[PHP-DB] Help connecting with oracle Works Fine!
Tank you but i copy the .DLLs from c:\orant\bin to c:\winnt\system32 without overwriting and works fine!! bye folks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] ADO Connection Problems
I am having problems making things happen in a Microsoft Access Database that I am connecting to through an ADO Connection using PHP. I know a little bit about PHP and how to code, but this is the first time I have played around with the ADO Connection and Command objects. I am getting no error messages or anything, but when I browse the database, my changes are not being posted. Here is an example of what I am trying to do. Hopefully, I am just missing a step along the way. $dbFile = 'SERVER\\FOLDER\\BackEnd.mdb'; $conn = new COM('ADODB.Connection'); $conn-Open(DRIVER=Microsoft Access Driver (*.mdb);DBQ=$dbFile); $cmd = new COM('ADODB.Command'); $cmd-ActiveConnection = $conn; $cmd-CommandText = UPDATE TABLE1 SET FIELD1 = '$parm1' WHERE FIELD2 = '$parm2';; $cmd-Prepared = TRUE; $RSet = $cmd-Execute(); Any assistance anyone can offer would be greatly appreciated. Thank you. Joe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Saving state
Sorry about the cross posting, as im not exactly sure what would be the best method to handle this, but im trying to set up a web application with a tabbed interface. Each tab will have a form to enter data, and the requisite save and continue button. Heres where things get hard though. I want to be able to allow users to click on a previous tab to refrence, change, update, etc the information on those tabs. How do i save the state of these tabs so that they can be reaccessed? Just so you have a little more information, im trying to make a kinda simple call logging system with a customer tab which would hold customer info and a calls tab which would store call info and allow you to switch between call records. all of this data would be stored in a database, but i dont want to actually have to send a new query to the database just because the user clicked on a previous tab...if this would be possible. Also, if anyone has an idea as to how i can implement this a bit more intelligently, im open to suggestions, but the tabbed interface seemed to be the most user friendly. And yes, the web interface is important, which is why im not trying to do it in c++ or something like that. Shiloh
Re: [PHP-DB] Saving state
Sounds fairly complicated, but wat about storing the information in session variables? and using multi dimensional arrays to store the information eg Array ( [call_1] = Array ( [name] = john smith [number] = 555-555-555 [time] = 2003-10-17 10:41:00 ) [call_2] = Array ( [name] = bill johns [number] = 555-555-555 [time] = 2003-10-16 07:41:00 ) ) but it really depends on how you want to do it, it might be beneficial to re query the database every time, especially if its going to be multi-user, because what happens if 1 person logs a call, how will the other person using the system know that a new call has been logged, re-querying it shouldnt take too long, and would provide advantages when there is more than one user, and you would have no synchronisation problems Luke - Original Message - From: Shiloh Madsen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 10:24 AM Subject: [PHP-DB] Saving state Sorry about the cross posting, as im not exactly sure what would be the best method to handle this, but im trying to set up a web application with a tabbed interface. Each tab will have a form to enter data, and the requisite save and continue button. Heres where things get hard though. I want to be able to allow users to click on a previous tab to refrence, change, update, etc the information on those tabs. How do i save the state of these tabs so that they can be reaccessed? Just so you have a little more information, im trying to make a kinda simple call logging system with a customer tab which would hold customer info and a calls tab which would store call info and allow you to switch between call records. all of this data would be stored in a database, but i dont want to actually have to send a new query to the database just because the user clicked on a previous tab...if this would be possible. Also, if anyone has an idea as to how i can implement this a bit more intelligently, im open to suggestions, but the tabbed interface seemed to be the most user friendly. And yes, the web interface is important, which is why im not trying to do it in c++ or something like that. Shiloh -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Saving state
From: Shiloh Madsen [mailto:[EMAIL PROTECTED] Sorry about the cross posting, as im not exactly sure what would be the best method to handle this, but im trying to set up a web application with a tabbed interface. Each tab will have a form to enter data, and the requisite save and continue button. Heres where things get hard though. I want to be able to allow users to click on a previous tab to refrence, change, update, etc the information on those tabs. How do i save the state of these tabs so that they can be reaccessed? Just so you have a little more information, im trying to make a kinda simple call logging system with a customer tab which would hold customer info and a calls tab which would store call info and allow you to switch between call records. all of this data would be stored in a database, but i dont want to actually have to send a new query to the database just because the user clicked on a previous tab...if this would be possible. Also, if anyone has an idea as to how i can implement this a bit more intelligently, im open to suggestions, but the tabbed interface seemed to be the most user friendly. And yes, the web interface is important, which is why im not trying to do it in c++ or something like that. Shiloh I have done this using multiple hidden div tables /div. Works well for large forms when you want to show only a small piece of it at a time. Each tab exposes the current div table and hides the remaining tables. No need to save state because all data is on one form. It is just hidden from view until you get to the final tab and submit. If you are using any drop-downs select tags, you will need to set their visibility to 'none' along with that table because of their inherent visibilty over all other html. I have also seen this done using successive forms, posting one form to the next and creating hidden fields to save the data from one form to the next. This might be hard to handle though if you want to move forward and backward at will. Duane -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Saving state
Luke, Good point, this list is set up different in that Reply ONLY replies to the individual poster, not the list. Have to use reply to all. I have added the list address to this post. To all concerned, this thread contains some off list conversation that may be of interest, particularly to the original poster. Luke, I agree, both methods will probably work well, as you said, 'depending on the situation'. To expand on the issue of retrieving previously posted data into a multi-tabbed form. In this case, I would normally show the user a list of previous posts or perform a search. Selecting a previous post would load the form with the historical data to allow reviewing one tab at a time. Just like loading any normal edit/view form, but with the tabs breaking up the form into individual parts of the same record. Edits and updates are performed and posted using a similar process to the original post but using an UPDATE WHERE instead of an INSERT INTO statement. List, Sorry if this post is ugly. Delete as necessary. -Original Message- From: Luke Skywalker [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:19 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Saving state Yeah, i got ya, totally different concept, i was thinking the tabs would be like |previous calls|add a call|statistics| (just an example) but i now know what you mean with hiding/showing the sections thats a good idea if its only for submitting, but what if they want to go to a previous calls tab (like i have there) all the previously submitted calls wont be still held in the form data and i havent used any query strings in my example, to pass the values from each form id use the form post and submit it with javascript, so all the values (including the hidden ones) are available through $_POST['hiddenfieldname'] I think we have two different concepts entirely, i think yours would work, and mine would work, depending on the circumstances :) Maybe we should be posting this thread to the mailing list? Luke - Original Message - From: Duane Lakoduk [EMAIL PROTECTED] To: 'Luke Skywalker' [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 12:04 PM Subject: RE: [PHP-DB] Saving state Yes, I think so. Are you using the querystring to pass the name=value pairs for each form? If so, you could run into a querystring length problem if the form is large. Let me know if I got this part right. The method that uses the tabbed form never posts the data until you are completely done filling all tabs. These are not different pages, I am using DHTML to hide each successive tab. Simply hiding that tab form data and exposing the next. Completing the part of the form on each tab, then click submit only when completed on all tabs. Note: each tab is only a part of the complete form. The form data is only submitted once all tabs (parts of the form) are complete. Make sense? Duane -Original Message- From: Luke Skywalker [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 8:52 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Saving state Yeah, i think i understand what you mean, the one form used on each different page, but Shiloh would have to transfer the information from page to page, and what would happen if a user wanted to click from tab to tab the tabs at the top of teh page (or side or wherever) would not be forms, so the information wouldnt be submitted to them, and hed have to requery to get the information back? but if the javascript code submits the information to the next page (and that javascript code can be assigned to any hyperlink, thus effectively turning any link into a submit button) do you know what i mean? and yeah it is strange that you havent seen your post yet, it has been sent to the list, as i saw it there :/ Luke - Original Message - From: Duane Lakoduk [EMAIL PROTECTED] To: 'Luke Skywalker' [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:43 AM Subject: RE: [PHP-DB] Saving state Luke, I think you may have this out of sequence. I was replying to Shiloh's post. I commented on the hidden field process as well. I use that for some other forms and info pulled from Exchange or the Account SAM database. I like the tabbed approach as it is just one form regardless of the number of tabs. Really have to look at these on a case by case basis. On another note, I haven't even gotten my own post to the forum yet that you are replying to. Odd huh? Thanks -Original Message- From: Luke Skywalker [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 8:27 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Saving state Just something to keep in mind, if your users will
Re: [PHP-DB] Saving state
Yeah, that is a good way to do it, i would do something similar too but Shiloh seemed to not want to requery the database, althought querys in this case would be the quickest and simplest way to get the historical information, which would be stored in the database already, and as you said, update querys if you want to change the information loaded into the form. If you need to avoid the database, the only other way i can see of keeping the information is adding it to variables at the same time as you add it into the database, and when you need to re-access the info, pull it from the variable instead of the database, but that could get messy Luke - Original Message - From: Duane Lakoduk [EMAIL PROTECTED] To: 'Luke Skywalker' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 12:39 PM Subject: RE: [PHP-DB] Saving state Luke, Good point, this list is set up different in that Reply ONLY replies to the individual poster, not the list. Have to use reply to all. I have added the list address to this post. To all concerned, this thread contains some off list conversation that may be of interest, particularly to the original poster. Luke, I agree, both methods will probably work well, as you said, 'depending on the situation'. To expand on the issue of retrieving previously posted data into a multi-tabbed form. In this case, I would normally show the user a list of previous posts or perform a search. Selecting a previous post would load the form with the historical data to allow reviewing one tab at a time. Just like loading any normal edit/view form, but with the tabs breaking up the form into individual parts of the same record. Edits and updates are performed and posted using a similar process to the original post but using an UPDATE WHERE instead of an INSERT INTO statement. List, Sorry if this post is ugly. Delete as necessary. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Why varying functionality across php db apis for db metadata?
For example, php mysql library supports list_dbs and list_tables commands as well as getting table metadata. MySQL sql also 'natively' supports these commands (show databases, show tables, describe tableName). Why not similar commands for Oracle, SQLServer, etc.? These are simply selects against certain system tables, no? mike klein -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Graphs
Hi, I have data (in numeric format) stored in MySql. This data I am collecting hourly. Now I want to generate the graphs using this data and to display them in the browser. Which r the tools/utilities are available to do the same? I am using PHP4.2.2, Apache server and MySQL. Thanks in advance. -- Regards, --Balaji -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Graphs
Hi I have been using the utilities from this website with very good results http://www.aditus.nu/jpgraph/ Jack from: Balaji H. Kasal [EMAIL PROTECTED] date: 2003/09/16 Tue PM 06:48:48 CEST to: [EMAIL PROTECTED], PHP List [EMAIL PROTECTED] subject: [PHP-DB] Graphs Hi, I have data (in numeric format) stored in MySql. This data I am collecting hourly. Now I want to generate the graphs using this data and to display them in the browser. Which r the tools/utilities are available to do the same? I am using PHP4.2.2, Apache server and MySQL. Thanks in advance. -- Regards, --Balaji -- 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] Re: [PHP] Re: [PHP-DB] Graphs
I found phpchartdirector to be a nice third party app http://www.hotscripts.com/Detailed/12237.html - Original Message - From: [EMAIL PROTECTED] To: Balaji H. Kasal [EMAIL PROTECTED]; [EMAIL PROTECTED]; PHP List [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:12 AM Subject: [PHP] Re: [PHP-DB] Graphs Hi I have been using the utilities from this website with very good results http://www.aditus.nu/jpgraph/ Jack from: Balaji H. Kasal [EMAIL PROTECTED] date: 2003/09/16 Tue PM 06:48:48 CEST to: [EMAIL PROTECTED], PHP List [EMAIL PROTECTED] subject: [PHP-DB] Graphs Hi, I have data (in numeric format) stored in MySql. This data I am collecting hourly. Now I want to generate the graphs using this data and to display them in the browser. Which r the tools/utilities are available to do the same? I am using PHP4.2.2, Apache server and MySQL. Thanks in advance. -- Regards, --Balaji -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General 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] store whois requests
I want to store whois requests including the ip address and date/time stamp into a file or MySQL database (a database is what I prefer to use) for monitoring the PHP whois script. Anybody an idea of how I could do this? I'm a beginner in PHP so any help is welcome. --IS -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] store whois requests
This is some code I already use... you may wish to change the way you retrieve you whois data. Ryan html headtitleWhois/title/head body form name=theform action=whois.php method=post Hostname: input type=text name=host length=30 input type=submit /form ?php //if a domain name was provided if ($host) { //output the name of the host echo h3$host/h3pre; //backwards tick marks will run this command on the server and echo's it out to the screen echo `whois $host`; echo /pre; //get the timestamp and ip $timestamp = date(YmdHis); $ip = getenv(REMOTE_ADDR); //create your query $query = insert into whois_log (domain, timestamp, ip) values (\$host\, \$timestamp\, \$ip\); //run the query against the database with your variables for $server, $username, and $password $db = mysql_connect($server,$username,$password); mysql_select_db(your_database,$db); if (!$result = @mysql_query($query,$db)){ $error = mysql_error(); print(Error Processing Query: $errorbr$querybr); } } ? scriptdocument.theform.host.focus()/script /body /html -Original Message- From: IS [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 4:27 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [PHP-DB] store whois requests I want to store whois requests including the ip address and date/time stamp into a file or MySQL database (a database is what I prefer to use) for monitoring the PHP whois script. Anybody an idea of how I could do this? I'm a beginner in PHP so any help is welcome. --IS -- 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