vicky57t
-
Posts
5 -
Joined
-
Last visited
Never
vicky57t's Achievements
Newbie (1/5)
0
Reputation
-
THANKS A LOT [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /]
-
Hi all, I don't know anything at all about generating tooltips in php pages. I need to use them with buttons (submit) & other html components (text areas, textfields, dropdowns) Can anybody please help me outwith this ? Thanks in anticipation. [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /]
-
[!--quoteo(post=374888:date=May 18 2006, 01:46 PM:name=samshel)--][div class=\'quotetop\']QUOTE(samshel @ May 18 2006, 01:46 PM) [snapback]374888[/snapback][/div][div class=\'quotemain\'][!--quotec--] $_SERVER['REMOTE_ADDR'] will be useful for you [/quote] THANX A LOT [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /] [!--quoteo(post=374898:date=May 18 2006, 03:40 PM:name=EchoNinja)--][div class=\'quotetop\']QUOTE(EchoNinja @ May 18 2006, 03:40 PM) [snapback]374898[/snapback][/div][div class=\'quotemain\'][!--quotec--] to expand on what samshell said, in your when you send your info from the form to the database just simply do this $ip=$_SERVER['REMOTE_ADDR']; and then just add it into the INSERT like the rest of the data :) [/quote] Thanks a LOT [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /]
-
hi all, i built a small app in php & mySql which resides on an apache server with gentoo linux. I use it on my local network to post knowlwdgebase entries & solutions from simple webpage with textboxes & text areas. what I want is some way in PHP code from whcih I can get the IP address of people entring data in the tables thru the application and maybe get the entry in my database. Kindly help thanks
-
[!--coloro:#FF6666--][span style=\"color:#FF6666\"][!--/coloro--]I have the following code :[!--colorc--][/span][!--/colorc--] ----------------------------------------------------------------------------------------------------------------------- <html> <?php //////// Link up with back end $link = mysql_connect('10.34.36.18:3306', 'gforge', 'gforge123'); if (!$link) { die('Could not connect: ' . mysql_error()); } //////// Selecting database $db_selected = mysql_select_db('STATIONARY', $link); if (!$db_selected) { die ('Can\'t use Stationary Database : ' . mysql_error()); } /////////// Query 0 - getting DB table (DT) entries $query0 = mysql_query('select count,year,year_order from DT',$link); if (!$query0) { die('Invalid query: ' . mysql_error()); } if (mysql_num_rows($query0) == 0) { echo "No rows found, nothing to print so am exiting"; exit; } while ($row = mysql_fetch_assoc($query0)) { echo "Table Entries - "; echo $row["count"]; echo $row["year"]; echo $row["year_order"]; } ?> <br> <?php /////////// Query 1 - getting Max year from DB table (DT) entries $query1 = mysql_query('SELECT MAX(year) FROM DT',$link); if (!$query1) { die('Invalid query: ' . mysql_error()); } $max_year_db=mysql_result($query1,0); echo "Max year - $max_year_db"; ?> <br> <?php ////////// Query 2 - getting Max count corresponding to Max year from Query 1 $sql="SELECT MAX(count) FROM DT WHERE Year='".$max_year_db."'"; $query2 = mysql_query($sql,$link); if (!$query2) { die('Invalid query: ' . mysql_error()); } $max_count=mysql_result($query2,0); echo "Max Counter corresponding to max year - $max_count"; ?> <br> <?php //////// Query 3 - Selecting current Date from System $query3 = mysql_query('SELECT CURRENT_DATE',$link); if (!$query3) { die('Invalid query: ' . mysql_error()); } $current_date=mysql_result($query3,0); echo "Current date - $current_date"; ?> <br> <?php ////// Query 4 - Getting Current year from System date $sql="SELECT EXTRACT(YEAR FROM ('$current_date'))"; $query4 = mysql_query($sql,$link); if (!$query4) { die('Invalid query: ' . mysql_error()); } $current_year=mysql_result($query4,0); echo "Current year - $current_year"; ?> <br> <?php ////////// Check for Max year if (($max_year_db)<($current_year)) { echo ("$max_year_db<$current_year"); $query5 = mysql_query("insert into DT values (1,'".$current_year."','".$current_year."-1')",$link); die("Opt 1 executed"); } else { echo ("$max_year_db>=$current_year"); $max_count = ($max_count)+1; echo ("Count is: $max_count") ; $query6 = mysql_query("insert into DT values '".$max_count."','".$max_year_db."','".$max_year_db."-".$max_count."')",$link); die ("Opt 2 executed"); } ?> </html> -------------------------------------------------------------------------------------------------------------------- [!--coloro:#FF6666--][span style=\"color:#FF6666\"][!--/coloro--]Before executing this file the table in operation(DT) has following entries :[!--colorc--][/span][!--/colorc--] [!--coloro:#9999FF--][span style=\"color:#9999FF\"][!--/coloro--] Count Year Year_Order -------- ------- ------------- 1 2005 2005-1 [!--colorc--][/span][!--/colorc--] [!--coloro:#FF6666--][span style=\"color:#FF6666\"][!--/coloro--]when I run the above PHP code I get the output as :[!--colorc--][/span][!--/colorc--] [!--coloro:#9999FF--][span style=\"color:#9999FF\"][!--/coloro--]Table Entries - 120062006-1Table Entries - 120052005-1 Max year - 2006 Max Counter corresponding to max year - 1 Current date - 2006-04-13 Current year - 2006 2006>=2006Count is: 2Opt 2 executed[!--colorc--][/span][!--/colorc--] [!--coloro:#FF6666--][span style=\"color:#FF6666\"][!--/coloro--] The table output is:[!--colorc--][/span][!--/colorc--] [!--coloro:#9999FF--][span style=\"color:#9999FF\"][!--/coloro--]Count Year Year_Order -------- ------- ------------- 2 2006 2006-2 1 2006 2006-1 1 2005 2005-1 [!--colorc--][/span][!--/colorc--] [!--coloro:#FF6666--][span style=\"color:#FF6666\"][!--/coloro--]i.e. two entries are made to the table,in addition to existing one, whereas only one should be done I want the output to be :[!--colorc--][/span][!--/colorc--] [!--coloro:#9999FF--][span style=\"color:#9999FF\"][!--/coloro--] Count Year Year_Order -------- ------- ------------- 1 2006 2006-1 1 2005 2005-1 [!--colorc--][/span][!--/colorc--] [!--coloro:#FF6666--][span style=\"color:#FF6666\"][!--/coloro--]and on next execution it should be :[!--colorc--][/span][!--/colorc--] [!--coloro:#9999FF--][span style=\"color:#9999FF\"][!--/coloro--] Count Year Year_Order -------- ------- ------------- 2 2006 2006-2 1 2006 2006-1 1 2005 2005-1 [!--colorc--][/span][!--/colorc--] [!--coloro:#FF6666--][span style=\"color:#FF6666\"][!--/coloro--]The DT table has thre fileds namely Count, Year, Year_Order as int,int and varchar(25) reapectively Can somebody help me out with this problem. Thanks[!--colorc--][/span][!--/colorc--]