The security is pretty simple I almost finish it. All what I need are the missing codes, you will see. It wil take you maybe 5 minutes.
I am getting this error when I click on view offers an requests. It looks like something is not linking.
Warning: mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it. in X:\xampp\htdocs\ProjectFinal_atlanta\Database.class.php on line 11
No connection could be made because the target machine actively refused it.
Yeah mysql was not running. But, I am getting another error. I fixed the password XXXXX I did the last time. If I open the file from last week and it runs just perfect but if I try one that we just did I am getting this error. I also tried logout and login and get the same thing. What do you think is the problem? The system is connected to appache, mysql and cmd is opened and working
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) in X:\xampp\htdocs\ProjectFinal_atlanta\Database.class.php on line 11
Access denied for user 'root'@'localhost' (using password: NO)
You may think that you fixed the password XXXXX the file, but you did not. Open up Database.class.php. Make certain that it is the new copy of Database.class.php that you have open.Look at the error message. It states that there is no password. So you either did not save the changes to the file or you did not make the change correctly. It is attempting to connect with "root" and no password. Make certain that you update that variable and that you save your changes, and that you have the correct copy of the file open.PHP does not lie. If it says that there is no password (which is what that error is saying), then there is no password. You didn't successfully update that file. Make the changes, then go back to your browser and press CTRL-F5.
Thanks I reset the system again and it works. Now I going to deal with the email part. Thanks for your patience. I just rate you, make sure you get your money and let me know if I owe you something else. Your knowledge is extremely valuable.
I think we have a SMTP server set up and is giving this error. I tried the program that you gave me but I do not know I did not get anything probably is because of this set up.
Warning: mail(): Failed to connect to mailserver at "smtp1.spsu.edu" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in X:\xampp\htdocs\ProjectFinal_atlanta\Notifications.class.php on line 45
THIS IS PART OF php.ini that I think has to do with the error.
; XAMPP: Comment out this if you want to work with an SMTP Server like Mercury
SMTP = smtp1.spsu.edu
smtp_port = 25
; For Win32 only.
; XAMPP IMPORTANT NOTE (1): If XAMPP is installed in a base directory with spaces (e.g. c:\program files\xampp) fakemail and mailtodisk do not work correctly.
; XAMPP IMPORTANT NOTE (2): In this case please copy the sendmail or mailtodisk folder in your root folder (e.g. C:\sendmail) and use this for sendmail_path.
; XAMPP: Comment out this if you want to work with fakemail for forwarding to your mailbox (sendmail.exe in the sendmail folder)
;sendmail_path = "\"\xampp\sendmail\sendmail.exe\" -t"
; XAMPP: Comment out this if you want to work with mailToDisk, It writes all mails in the \xampp\mailoutput folder
;sendmail_path = "\xampp\mailtodisk\mailtodisk.exe"
; Force the addition of the specified parameters to be passed as extra parameters
; to the sendmail binary. These parameters will always replace the value of
; the 5th parameter to mail(), even in safe mode.
; Add X-PHP-Originating-Script: that will include uid of the script followed by the filename
mail.add_x_header = Off
; Log all mail() calls including the full path of the script, line #, to address and headers
;mail.log = "\xampp\php\logs\php_mail.log"
By the way, PHP will automatically use the default SMTP server for the server you are running on if you make absolutely no change to php.iniSo if you touched nothing and uploaded this to your school's server, it would work. Or if you touched nothing and ran the software I gave you, it would work.
You are not going to be able to change your school's ini file, so why alter ini settings now? Were you directed to do so? It seems to be way out of scope for the project. Unless you received that address from your course and were explicitly instructed to alter your php.ini file, you should not be doing it. I tested that address, and it is not accepting connections. So it would seem like you weren't instructed to do this.
If you put the ini file back to default and use the test software, it would work.
In a previous lab work the professor made us to change a the php.ini a little bit. That was the first week of class. The purpose unknown. But after that date I have not changed anything. So, should I install the test mail server tool where I have the xampp or in my program files?
Hello again; I checked with the instructor and he wants us to use the settings that I showed you on a previous message. I think that he wants the project this way because he wants to test it himself. But I still have a doubt as far as meeting all requirements. Ok, if use my school email address it works fine, I do get the message in my inbox but if I use a fake one or any other email address I do get the error. It only accepts school's email addresses but if I want to see the message I need to use my personal school email address.
The above linked document probably explains what we did in the past and how we did it. You know he loves to take points I just want to make sure that we are not missing anything. Otherwise I would leave it as is and use my email address for all the offers/requests that use in the data base. If I owe you something else just let me know. Thanks
I just noticed that the reset button on search.php does not clear the city or the dates. In chrome displays a drop down calendar but in IE or Firefox doesn't. In IE and Firefox displays the final days selected in Y/D/M instead of M/D/Y. Do you think we can fix these details?
the outcome of date range boxes
I know you are going to be upset, I am too. I can swallow everything that he says except the validation point because is only true if you INSERT the record using cmd not if you use the program that we designed. The other one is the search issue, per the instructions he stated "by city and date" not "by city or date". My question: How can you implement validation when using cmd? I am afraid to challenge him because he is not happy with the database.class. I understand most of what you did, but not all.
I do not have a link. I sent him a zip file with the codes. In my system the site works fine it does not allow me to add anything to the database unless all the text fields are filled out. I will take the chance and challenge him. Thanks anyway.
Challenging your professor cannot hurt, and as a student, you should never back away from doing so when it is necessary. I have been a student several times in my life. Instructors make mistakes.Can you send me exactly what you turned in? I would like to take a look and see if there is any merit to what he is saying. I wouldn't bring up the database.class.php thing with him. He didn't remove any points for that and he does not seem to be "upset" about it. He was just trying to provide you with what he things is constructive constructive feedback. However, I have been the project lead and lead engineer for high-profile, massive web-based information systems that receive millions of hits a day and bring in massive revenues. And I am telling you that your instructor is not quite right about that. If you were creating a completely procedural system, then yes, he is right. But you implemented object orientation and created a data model for your system. At the very least, it a database-wrapper, which was common practice for real-word web applications before MVC became popular. The way that he wants you to do things is actually not really done in the real world. It is amateur and does not reflect how things really should be implemented.In any case, he didn't take points off for that, so do not get hung up on it.I am assuming that the class is over and you cannot resubmit?
A B is not a bad grade. However, you definitely should have received points for the user input validation, which would have given you a better grade. If you can send the the exact zip file that you sent in, that would be great.
This is the file.
Hello; The professor did not change the points. He stated that he only used the cmd window to set up the database. For learning purposes only: how do you implement the same validation parameters that we have in the site within the cmd? I think we are missing a code in database.class.php. He is right, through the cmd you can do anything and it takes and moves the data or no data to the site pages.
He only sent one sentence, "I only used the cmd window to set up the database". But, he did not explain me what should I have done to prevent this to happening. I agree with you that the user never use cmd. But, an intruder may alter the data through the cmd..
Let me know when you are online in order to make the deposit for the next task. I have something new for you.