twitch987 Posted January 13, 2009 Author Share Posted January 13, 2009 in all honesty i thought thats what it did.. i thought the $id was defined for each result, and place into the hidden form field to be passed to updated.php ..i've got a long way to go lol. that would be brilliant thanks its at http://83.170.107.1/~toxxicst/sqltest/properties.zip the idea behind the update page was to have it in a password protected directory so not just anyone could use it.. the index page (yet to be styled obviously) is going to be on the website for all visitors to see.. can you think of a way to keep the update process out of the index page? Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736381 Share on other sites More sharing options...
ngreenwood6 Posted January 13, 2009 Share Posted January 13, 2009 try uploading the attached zip file to your server. I would then look at the code until you understand it. As far as the password protection you would have to create a login type system and only allow access to that page to certain members. You will have to look into sessions for that kind of functionality. Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736437 Share on other sites More sharing options...
ngreenwood6 Posted January 13, 2009 Share Posted January 13, 2009 forgot to upload the file lol. here it is [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736439 Share on other sites More sharing options...
ngreenwood6 Posted January 13, 2009 Share Posted January 13, 2009 I already know what you are going to say. replace your update.php with this one. [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736448 Share on other sites More sharing options...
ngreenwood6 Posted January 13, 2009 Share Posted January 13, 2009 Actually you will have to replace the index.php with this one too. I forgot that you weren't setting the id on the index page. [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736456 Share on other sites More sharing options...
twitch987 Posted January 13, 2009 Author Share Posted January 13, 2009 lol ur psychic now too eh? thanks for the notations in the PHP - very helpful.. im afraid we're having the same problem though its not updating http://83.170.107.1/~toxxicst/sqltest/index.php Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736465 Share on other sites More sharing options...
ngreenwood6 Posted January 13, 2009 Share Posted January 13, 2009 replace your updated.php file with this one. [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736484 Share on other sites More sharing options...
ngreenwood6 Posted January 13, 2009 Share Posted January 13, 2009 nevermind that one is wrong. you didn't copy and paste the changes that I told you to. when you set the form you must tell its method to post like this: <form method="post" action="updated.php"> replace your update.php file with this one. edit: if you wanted to use the GET method you would set its method to get which puts the variables in the url. That is what it is doing instead of posting them. when data is posted it doesnt pass through the url. [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736489 Share on other sites More sharing options...
twitch987 Posted January 13, 2009 Author Share Posted January 13, 2009 AHA! We're up and running!! Thanks alot man! I did change the post method when you mentioned it but i edited the online version through my ftp client.. the one i zipped was my old local copy.. sorry i can be dumb sometimes lol. You've been a brilliant help thanks so much.. anyone else woulda started charging for their time by now lol Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736494 Share on other sites More sharing options...
ngreenwood6 Posted January 13, 2009 Share Posted January 13, 2009 I know what it was like when I was a beginner trying to learn the language. If someone would have helped me like I just helped you it would have made it much easier to learn. Thats why I help people out. Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736497 Share on other sites More sharing options...
premiso Posted January 13, 2009 Share Posted January 13, 2009 I know what it was like when I was a beginner trying to learn the language. If someone would have helped me like I just helped you it would have made it much easier to learn. Thats why I help people out. Helping is fer newbs. If you really appreciate the help here, donate to the site. Without donations the site may one day disappear!!! Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736501 Share on other sites More sharing options...
twitch987 Posted January 13, 2009 Author Share Posted January 13, 2009 Well i appreciate it alot thanks man. considering i only started trying to learn php yesterday (and hadn't a clue about MySQL) its fair to say i would never have done it without ya premiso: "helping is for newbs" Wow i bet that makes ngreenwood feel real appreciated, great speech. this post has been going for over a day how long have been waiting to say that? If you really wana inspire people to donate, try be a little more tactful. Calling the people who DO help out newbs will just piss them off, which really will make the site disappear. Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736506 Share on other sites More sharing options...
premiso Posted January 13, 2009 Share Posted January 13, 2009 Well i appreciate it alot thanks man. considering i only started trying to learn php yesterday (and hadn't a clue about MySQL) its fair to say i would never have done it without ya premiso: "helping is for newbs" Wow i bet that makes ngreenwood feel real appreciated, great speech. this post has been going for over a day how long have been waiting to say that? If you really wana inspire people to donate, try be a little more tactful. Calling the people who DO help out newbs will just piss them off, which really will make the site disappear. Wow dude, take a chill pill. Sarcasm...if I really thought helping is fer(notice for spelled wrong) newbs, you would notice I would not have 1,900 posts. Give me some credit for trying to make a joke. Next time I will spell out the sarcasm for you. Edit: And it was more of a joke meant for ngreenwood at any rate. I have helped him out many times on the forum and it is nice seeing him paying it forward. See this post for proof. Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736509 Share on other sites More sharing options...
twitch987 Posted January 13, 2009 Author Share Posted January 13, 2009 good idea. Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736512 Share on other sites More sharing options...
ngreenwood6 Posted January 13, 2009 Share Posted January 13, 2009 yeah twitch he was just making a joke. premiso has helped me out many times when I was trying to figure some stuff out. It's too bad that when I was learning I hadn't heard of this site lol. thanks for sticking up for me tho edit: can't spell lol Quote Link to comment https://forums.phpfreaks.com/topic/140494-solved-phpmysql-confusion/page/2/#findComment-736524 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.