close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

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 |

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.

Sign in to reply to this post

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.

Sign in to reply to this post

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?

Sign in to reply to this post

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.

Sign in to reply to this post

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
Sign in to reply to this post

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.

Sign in to reply to this post

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

Sign in to reply to this post

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.

Sign in to reply to this post

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?

Sign in to reply to this post

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.

Sign in to reply to this post
loading

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...