Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › SecurityAssist › Ip Address!!

Ip Address!!

Thread began 12/07/2011 8:36 am by Kumel | Last modified 12/26/2011 4:52 am by kumel619425561 | 2283 views | 19 replies |

12/07/2011 8:36 am | #1 Kumel

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.

12/07/2011 9: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 10: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 12:38 pm | #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 1:23 pm | #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.

Attached Files

IPPPPPPPP.zip

12/19/2011 9:38 am | #6 Jason ByrnesWebAssist

to help troubleshoot, change line 154:

php:

$WA_redirectURL = "SnapsDetails.php";

to:

php:

$WA_redirectURL = "";

then add the following code just after the <body> tag to output the SQL Insert Record command:

php:

<?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 2:23 pm | #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 2:28 pm | #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 2:39 pm | #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 2:42 pm | #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.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.