thedigicraft / Atom.CMS

Atom.CMS
56 stars 52 forks source link

Pages - add and edit #85

Closed BloodWolf89 closed 9 years ago

BloodWolf89 commented 9 years ago

Hello, Thanks for doing this project to teach people.

I am having an odd issue and I loaded my back up and it does the same thing. I messed something up between Video 40 to 44.

The Issue: When I update a page all the fields but the user get the content of the first field.

Another issue.. When I try to add a new page.. Well.. Here is the high detail error output..........

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Query: UPDATE pages SET user = 2, slug = '2', title = '1', label = '1', header = '1', body = '1' WHERE id ="

I will pack up the file and upload it so you awesome peeps can check it out lol password is default and email is in db!

BloodWolf89 commented 9 years ago

Here is the link..

https://www.dropbox.com/s/ee7cwnomebfd058/WTF%20HAPPENED.rar?dl=0

BloodWolf89 commented 9 years ago

Only things that update is Title, Slug and User. Everything else takes the value of the title.. Here is a pastbin of the index file.

http://pastebin.com/ujTCg6eM

el3302 commented 9 years ago

looking at the code you have set $title, $label, $header, $body to $_POST['title'] that might be a problem.

BloodWolf89 commented 9 years ago

Wow, Thanks! hahaha 32 hours of no sleep didn't help! Well Thank you.. now the only problem I have is that the pages do not update. I seen an updated if statement for the query last night.. I will try that.

Thank you el3302

BloodWolf89 commented 9 years ago

It worked! Thank you for your help el3302! and Thanks Alan for doing all of this! Great work!

by the way, The if(statement) that I updated was the

if (isset($_POST['id']) AND $_POST['id'] != '') {