Hello again! Thank you for requesting me.Please provide details. If you have files that you need to share, please zip them up and upload them to http://ge.ttOnce uploaded, you will be given a link on the right. Click on the 'Copy Link' option and then paste it here.Thank you
I need to do the highlighted part in the file MyGroupProjectPart the other word document is just instructions for the whole project in case you have a doubt. You will notice that classmate who did the first part made a wonderful job. He got 100% in his individual project.
Hello again.It never ceases to disappoint me how horrible many instructors are.Your classmate should have received D at best.1.) Every page that uses a the database creates a new database connection in that file itself.The first professional PHP site I ever worked on had bout 2000 PHP pages. Imagine if a "good" developer got out of college and then went to work and created 2000 PHP files over the course of many years and created a new database connection, with the host, username, and password XXXXX in to each and every page.Now imagine that the company changes host addresses or other connection parameters. You have just created a MASSIVE company issue that will cost a ton of money to correct. With your project, the site could expand as large as it needs to be and updates would require changing a single line of code. Your classmate's would require thousands of lines to be altered.2.) He used a table for a form. That is very 1995 and violates the basic concepts of web design and the current W3C recommendations for good web design.
3.) His database does not have any primary key on two of the tables. That is a violation of 1st normal form, or the very most basic rule of relational databases. It is a HUGE error. It is actually going to pose an issue with your part. It is difficult to delete a record that has no ID. And the sentEmail records are supposed to refer to the record. It is impossible to make reference to a record that has no ID. So the database is complete rubbish. I will have to alter it.Simply put. This site is bad. Very bad. In the real world, your classmate would get a talking to. It is very likely that he will at some point. They teach you a lot of bad habits in college. Usually because the instructors are such horrible developers.But it is what it is. By when do you need this?
Yeah, I also noticed some of your points. But we should please the professor but if there is something that violates the established rules you may make changes just make comments. Do you think you can have it ready for Wednesday night or Thursday? if not just let me know. Take your time. Also, let know if there is any additional fee from your part. Anyway I always give you tip, but just in case. I want you happy and well paid.
This fellow created his tables based on his individual project database. My classmates do not have anything yet, I am the only one because I am doing the second part.
I have to login using the school credentials and then register(only once). I tested that part and worked as indicated in the instructions. In order to register you must be in the school network. You can not do it. Remember this project is not a real web, is fake.
Let me know when you are online
I am getting this error when I try to send you a message let see if this one pass
You don't have permission to access "http://www.justanswer.com/homework/7pwhi-for-doctor-help-group-project.html" on this server.
Let me try again;
I have a question that may sound silly, but I wanted to make sure before I test the program. In necessaryAlterations we have DELETE FROM apartmentoffers; and DELETE FROM apartmentRequest; Do I need to enter this statements just like this without telling the database what I am deleting?
I deleted the tables and created them and made all the changes that you gave me in the file.sql. However, when I input offers or requests I do not get the email. The delete option works but the accept option is not showing up on the browser. In other words everything works except the emails and functionality of accept offer/request. I tried to compare of what we did in my last project but could not figure out. It seems to me that a link is missing. I am sending screenshots, open the link below.
http://wikisend.com/download/381778/Login and Not Loging screenshots.docx
The moderator of the group wants me to add the other part that we did not do and wants me to fix some errors that she gets when accepts the offer/request. I also noticed that the emails are not being stored in the sentEmail table. She wants me to remove the select statements and put the email in session variables ans pass it to insert statements. But I do not want to do anything unless you give me the OK. I highlighted in blue the part that I need to add. See link below.
These screenshots were taken on my computer using my database. I forgot how to make copy of the cmd database.
Let me know what the die message is for the prepare statement. You can also do this on the mysql command line:SHOW CREATE TABLE sentEmail \GPlease use the \G instead of the semicolon.Send me the die statement and the command line results from the create table statement.The prepare is failing, which means that there is something wrong with that table. Perhaps you forgot to type in the default CURRENT_TIMESTAMP ?
Also, the blue highlighted part in the requirements that you just sent me are not in the requirements that you previously sent me at all. I have both copies open.
I look forward to hearing back from you.
I hope is this...
http://ge.tt/5zZ71Vf/v/0?c New Photo
Hello again,The error is very obvious. It is due to your wonderful team mate who created the database in the first place. Who apparently granted access to each table within the database instead of granting your web user access to the database itself. I have never seen anyone grant access to each table independently. It is horrible practice and leads to things like this. The error you're getting is because the user does not have access to this new table. In contrast, my user on my computer has access to the entire database because that is the sane way of doing things.So, you see, there are no errors in the database or the code. It is simply that the GRANTS are set up really poorly. Run this on the command line (assuming you are logged in as root):GRANT SELECT, INSERT, UPDATE, DELETE ON kmandadi.sentEmail TO 'kmandadi'@'localhost';Though, most people would have done:GRANT SELECT, INSERT, UPDATE, DELETE ON kmandadi.* TO 'kmandadi'@'localhost';In the first place so that any new table in the database would be reachable from the web app.Your team mates will have to run this additional GRANT command also.Now for the blue part. As I mentioned, the blue highlighted part was not in the original requirements that you sent me at all. I can implement this additional functionality, but it is not part of what you requested in this question. I have both the original document you sent open and this new one. The blue-highlighted part does not exist in the original. The requirement isn't in the document at all.For items that were not part of your additional request, I am required to kindly request that you enter a new question. Please remember to start it with **For TheDoctor**. And let me know by when you will need this additional part.Thank you
I understand I will make a new request. Yeah I was changing the credentials manually it seems that is going to work. But let you tomorrow, because it is bedtime.