trg86

Any insight? Thanks!

Another quick question. I do eventually plan on having the data sent to a database as well, but also still e-mailing as well. I know I need to clean the data before it is sent to the database and I have it cleaning the data for the email as well. Below is a snippet of code from one of the fields, I wanted to make sure I can do it the way that I am in this line. i.e. 'mysql_real_ecape_string' and 'html_entities' on the same line like this. Let me know if it is incorrect. $name = mysql_real_escape_string, htmlentities($_POST['name'], ENT_QUOTES, 'UTF-8');

I do have it programmed as an HTML email. Would I make the htmlentities the same encoding as the php file itself or the same encoding at the html email that is being created? $name = htmlentities($_POST['name'], ENT_QUOTES, 'UTF-8'); That is now how I have it set, to clean the input data. UTF-8 is the encoding of the document itself.

It appears as if I am misinformed about the use of stripslashes, thank you for the feedback. What would you reccommend to clean the inputs of any malicious data? I only have it sending in an email, no database or anything.

Okay, I would like your opinion. I am in the process of rewriting my web form processor and I wanted to ask if this line of code is sufficient for making sure the input is clean. ( i.e. cutting any malicious attempt from a user filling out the form ) Please keep in mind that the form data is only sent in an email, no MySQL database involved. This is an example of code of just one of the inputs from the form, so you have a reference of what I programmed and asking about. Thanks! $name = stripslashes(trim($_POST['name']));

Thanks. I have tried all of that and the problem is persistant in all browsers for any computer that tries to use the form. It is quite literally a sudden problem.

Okay, the form processor that I wrote awhile ago and have been using since has all of a sudden just stopped working. After clicking the submit button on the form now, all it is returning is a "The connection to the server was reset while the page was loading" page. This has never happened before and it has just started happening all of a sudden, any idea what it may be? Thanks!!

Psycho, Thank you very much for the reply, I looked at your example code for debugging and wrote it into mine, for testing purposes. I am beginning to think it is not being executed for some reason, as I am still receiving the data in it's e-mail form and being re-directed to the success page, basically, I am not getting any different result than I was before. Would it be helpful if I post more of my code? Is there anything specific you want to see? Ugh, this is one of those annoying glitches, mainly because nothing was changed besides the database info for the new server...it's really odd to me how it could just stop working after working flawlessly on a different server...mind boggling I tell you!!

Thanks for the reply David. Yes, I am positive that the username and password are correct, after-all, I still login to phpMyAdmin successfully, which is the same username and password. My account has full privileges, that is definitely not the issue. I am using echo mysql_error() but I am not getting any error messages. Additionally, I also have error_reporting(E_ALL); ini_set("display_errors", 1); in use.

Thanks for your reply. As I said in my original post, everything was working fine for the entire development process so far, until I moved it to the new server. All I changed within my programming, after the server move, was the connection info to the new database, none of my other programming was changed/moved. There are no errors on the page, it still sends the $_POST data to my e-mail inbox and still loads the success page after submission, it just doesn't want to post to the new database for some reason...I can't seem to figure this out.

Okay, I know some of you the past month or so know of the project I am working on right now. I have been pulling my hair out trying to figure out what is causing this issue today. I just got done moving my database from one server (most development) to another server (where it needs to be when its done). Now, the only thing I had to change after the move within my programming was the MySQL login/database info (i.e. username, password, database name, host). But...this is the problem. It no longer wants to insert the data from the form into the database, it's pretty much like it is not firing, even though it works fine on the other server. Does anybody have any suggestions on what could be causing this issue? Thanks ahead of time!!

Thanks for your reply Jessica. By any chance, would you be able to give me code examples? I am not really sure how to go about doing it, thanks!

Hi there guys. I yet again have something I am wanting to do with my project, but I have never really practiced or used before. What would be the easiest way for me to display a list of the currently logged in users (by their username) logged into my system? I can post snippets of my code if you are needing to see something specific. I know doing something like this will involve the users session. Thanks in advance!

Good evening guys! I am in need of a little bit of help again. I am trying to figure out how to make an item that is already in a database and seen by all registered users, have the option to be seen by only one user and become that users unique content, making it invisible to other users. Just so you have a better handle on what I am talking about. I have already developed a php/MySQL form/database system. A user goes to the website and fills out the form, which is then stored in the database I have programmed. Now, authorized personnel, via a login page, can access and view the stored form data in a beautiful user interface I have designed for this. Currently, by default, all of the form entries are located on one page for viewing, as well as some options I have already added, such as editing/updating the data, 'archiving' the data, which moves it to an archive page, and being able to delete the data completely. The part I am trying to figure out, is how a user can go to the default page that holds all of the entries and be able to grab one of them and make it belong to them, i.e. a telemarketer claiming a lead, which would move it to their default main page that they see after they log in, now leaving it only viewable by them, instead of every registered user in the system. Thanks for your help ahead of time! Thanks!

Thank you for the suggestion David, I successfully got what I needed working using the NOW() in the MySql insert. Is there anyway to format it to display in 12-hour format? I'm not a big fan of the 24-hour format with the time. Thanks!