Ip Address!!
I had inserted security assist pages except UPDATEPAGE.PHP..
When a new user register's how do we store the ipaddress of the user in DB...? The field is already there in DB, but no values..!
Its urgent please help.
Super Suite
Get all extensions for one suite price
Design Extender
Design and create unlimited websites
Data Bridge
Develop database-driven websites
eCart
Build a responsive shopping cart + checkout
MySQLi Server Behaviors
Generate streamlined MySQLi
Free PayPal Toolkit
Paypal, PayPal Credit, and Skype
Help
12/07/2011 5:36 am | #1 Kumel I had inserted security assist pages except UPDATEPAGE.PHP..
When a new user register's how do we store the ipaddress of the user in DB...? The field is already there in DB, but no values..!
Its urgent please help.
12/07/2011 6:58 am | #2 Jason ByrnesWebAssist
in the registration page, edit the insert record behavior. Select the ip address column and click the lightning bolt icon next to value. From the bindings panel expand the server collection and select the remote address binding.
12/12/2011 7:59 pm | #3 Kumel thats cool.. how about in update page? like a user upload a image. then it must store the IP address while uploading too.. i did the same method. but the field value is BLANK.. What do i do?
12/13/2011 9:38 am | #4 Jason ByrnesWebAssist
on the profile page, edit the update record behavior. Select the ip address column and click the lightning bolt icon next to value. From the bindings panel expand the server collection and select the remote address binding.
12/17/2011 10:23 am | #5 Kumel edit the update record behavior.???????????????
Its not a update record page..
Its just a page where it insert's record in DB.. i have attached the file please check..
All the records are getting added but not the IP.
12/19/2011 6:38 am | #6 Jason ByrnesWebAssist
to help troubleshoot, change line 154:
$WA_redirectURL = "SnapsDetails.php";
to:
$WA_redirectURL = "";
then add the following code just after the <body> tag to output the SQL Insert Record command:
<?php echo("IP: ". (isset($_SERVER["REMOTE_ADDR"]))?$_SERVER["REMOTE_ADDR"]:"N/A"."<br />SQL: ".$WA_Sql); ?>
post back the results after trying an insert.
12/19/2011 11:23 am | #7 Kumel Nah! Not working.. page is showing but still its the same.. Only IP ADDRESS IS shown in the page.. after clicking "upload" the values are not inserting in DB
12/19/2011 11:28 am | #8 Jason ByrnesWebAssist
i did not say adding that code would fix the problem, i said it would help me troubleshoot the probelm by outputting the insert SQL to the page.
I asked you to post back the SQL Statement that is written to the page, please post that information back to help troubleshoot the problem. I cannot troubleshoot with that information.
12/19/2011 11:39 am | #9 Kumel I asked you to post back the SQL Statement that is written to the page, please post that information back to help troubleshoot the problem. I cannot troubleshoot with that information.
????????????????????????
WHAT DOES THIS MEAN? Can you give me an example?
12/19/2011 11:42 am | #10 Jason ByrnesWebAssist
Really?
I asked you to add this code to the page after the <body> tag:
<?php echo("IP: ". (isset($_SERVER["REMOTE_ADDR"]))?$_SERVER["REMOTE_ADDR"]:"N/A"."<br />SQL: ".$WA_Sql); ?>
the purpose of this code is to write the IP address and the Insert SQL Statement to the page after you press the submit button.
I need to to copy that information from the page into your reply post. I need to know what the Insert SQL Statement is.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.
©1999-2025 WebAssist.com Corporation. All rights reserved and all that jazz.
Account or customer service questions?
Please user our contact form.
Need technical support?
Please visit support to ask a question
Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...
Uploading file...
