php mysql

shylock · 12-21-2004, 12:20 AM

Would anyone have a clue why, when trying to access a file in a mysql db through a browser window, the page won't come up? (FC2 - php/mysql) The home page does pull some of the info out of the db and the images are in a directory; when clicking on the image the page is to go to that particular products' info but the screen flashes and remains on the home page.

I've found that for some reason I can't restart mysqld through a terminal command line but when I go into the services panel mysqld is actually alive. I can access information in the db via terminal command line but that's about it as well.

**gotissues68** · 12-21-2004, 05:30 PM

Sounds like more of an issue with the HTML built to go to the product page then php or mysql themselves. Do you have a link and I'll take a look :)

shylock · 12-24-2004, 01:53 AM

I sent an email with the ip address to your techsupport account

**gotissues68** · 12-24-2004, 02:33 AM

the link didn't work =(

*ninja edit* Works ok now, didn't work the other day when I tried from work.. looking now. Can you PM me like exact links that aren't working?

shylock · 12-24-2004, 09:48 AM

Yeah, sorry about that. I switch often between FC2 and XP because of different things that I need. I'll leave FC2 on all day today. I haven't blocked anyone from the outside for http and I do have a semblance of the project running in XP using Apache/MySQL so it should have worked. Nonetheless, sorry about the mixup and thanks for your attempt.

I've sent an email to you regarding the product details page. Thanks for your time and effort. I'm sure you know how much it is appreciated.

shylock · 12-26-2004, 05:57 AM

Ok, with the help of "gotissues68", I was able to figure out why my pages weren't showing up as they should; and it goes a little something like this (hit it):

In the newer version of the php.ini file, the register_globals status is set to "Off" for a variety of security issues - read up on it by viewing your php.ini file or on the 'net. I set the status to "On" and I am now able to see everything that I should. Apparently GLOBAL variables aren't really like any more.

Big ups to gotissues68

Skie · 12-26-2004, 09:46 AM

If you wrote that PHP, then I would strongly suggest re-writting it to not use Register Globals. If you're using something someone else wrong, like phpBB2, then they knew for at least a few years that this would happen, and they still wrote their stuff the way they did.

**gotissues68** · 12-26-2004, 11:54 AM

I agree Skie, however I did review the source and it looks like mostly a bunch of GET requests so he should be relatively safe security wise. It wouldn't take maybe more then 30 minutes time to re-write it properly but if it were written prior to REGISTER_GLOBALS off then it would be a pretty darn decent piece of code =)

shylock · 12-27-2004, 10:42 PM

Thanks very much for the help guys. At this point in time I'll reserve getting rid of the global variables because I have too much work to do. There are a LOT of pages, etc, involved with the site; therefore I'll do the editing on weekends or whatever. Oh, I almost forgot. All the code for the site was written a couple of years ago (2002), before the register_globals Off thing. If I understand correctly it might actually be ok for me to leave it as is, yes?

shylock · 01-11-2005, 10:23 AM

Would you all know of an html editor for Linux/FC2 which is similar to Macromedia Dreamweaver? In-line html editing is a real pain sometimes

**gotissues68** · 01-11-2005, 10:38 AM

I don't know of one off-hand no. I know you can run Dreamweaver via Crossover office but it of course costs money I think it runs 30 bucks or something and works pretty well. I use something called Jext http://www.jext.org which is a text editor but has syntax highlighting and macro's and what not. Let me know and I can put up a trial copy of crossover for you that I have.

shylock · 01-11-2005, 10:41 AM

Any kind of help would be nice and I'll try just about anything. At this moment I'm using a simple text editor and I'm sure we all know how long and time-consuming that can be. Thanks.

Skie · 01-11-2005, 01:58 PM

You can take a look at Quanta which should be on your system if you have KDE. If not, you can download it here: http://sourceforge.net/project/showf...?group_id=4113. This is a KDE application, so you'll need some KDE files in order for it to run. It's not exactly WYSIWYG, but it fairly powerfull.

The only other decent HTML editor that I know of is Nvu which is the Composer of Mozzila. Linspire (Lindows) took Composer and turned it into its own stand alone application and enhanced it. You can download it here: http://www.nvu.com/download.html.

You can also purchase Zend Stuido. This is the only commercial HTML editor that I'm aware of for Linux. At least the only one worth mentioning. You can get it here: http://www.zend.com/store/products/zend-studio.php. However, it's geared more towards PHP then just plain HTML.

Beyond those 3, I'm not aware of any decent HTML editor.

12-21-2004, 12:20 AM	#1 (permalink)
shylock Registered User Join Date: Dec 2004 Location: BC Posts: 28 OS: WinXP Pro/FC2	php mysql Would anyone have a clue why, when trying to access a file in a mysql db through a browser window, the page won't come up? (FC2 - php/mysql) The home page does pull some of the info out of the db and the images are in a directory; when clicking on the image the page is to go to that particular products' info but the screen flashes and remains on the home page. I've found that for some reason I can't restart mysqld through a terminal command line but when I go into the services panel mysqld is actually alive. I can access information in the db via terminal command line but that's about it as well. Last edited by shylock; 12-21-2004 at 12:35 AM. Reason: forgot a word

12-21-2004, 05:30 PM	#2 (permalink)
gotissues68 Senior Member Join Date: Sep 2002 Location: Vancouver Washington, Mountain View CA and Atlanta GA you pick the week! Posts: 716 OS: Linux/FreeBSD	Sounds like more of an issue with the HTML built to go to the product page then php or mysql themselves. Do you have a link and I'll take a look :) __________________

12-24-2004, 01:53 AM	#3 (permalink)
shylock Registered User Join Date: Dec 2004 Location: BC Posts: 28 OS: WinXP Pro/FC2	link I sent an email with the ip address to your techsupport account

12-24-2004, 02:33 AM	#4 (permalink)
gotissues68 Senior Member Join Date: Sep 2002 Location: Vancouver Washington, Mountain View CA and Atlanta GA you pick the week! Posts: 716 OS: Linux/FreeBSD	the link didn't work =( ninja edit Works ok now, didn't work the other day when I tried from work.. looking now. Can you PM me like exact links that aren't working? __________________ Last edited by gotissues68; 12-24-2004 at 02:40 AM.

12-24-2004, 09:48 AM	#5 (permalink)
shylock Registered User Join Date: Dec 2004 Location: BC Posts: 28 OS: WinXP Pro/FC2	ip Yeah, sorry about that. I switch often between FC2 and XP because of different things that I need. I'll leave FC2 on all day today. I haven't blocked anyone from the outside for http and I do have a semblance of the project running in XP using Apache/MySQL so it should have worked. Nonetheless, sorry about the mixup and thanks for your attempt. I've sent an email to you regarding the product details page. Thanks for your time and effort. I'm sure you know how much it is appreciated.

12-26-2004, 05:57 AM	#6 (permalink)
shylock Registered User Join Date: Dec 2004 Location: BC Posts: 28 OS: WinXP Pro/FC2	register_globals Ok, with the help of "gotissues68", I was able to figure out why my pages weren't showing up as they should; and it goes a little something like this (hit it): In the newer version of the php.ini file, the register_globals status is set to "Off" for a variety of security issues - read up on it by viewing your php.ini file or on the 'net. I set the status to "On" and I am now able to see everything that I should. Apparently GLOBAL variables aren't really like any more. Big ups to gotissues68

12-26-2004, 09:46 AM	#7 (permalink)
Skie Manager, Alternative Comp Join Date: Mar 2003 Location: Chicago burbs Posts: 2,194 OS: Gentoo Linux, CentOS, OS X My System	If you wrote that PHP, then I would strongly suggest re-writting it to not use Register Globals. If you're using something someone else wrong, like phpBB2, then they knew for at least a few years that this would happen, and they still wrote their stuff the way they did. __________________

12-26-2004, 11:54 AM	#8 (permalink)
gotissues68 Senior Member Join Date: Sep 2002 Location: Vancouver Washington, Mountain View CA and Atlanta GA you pick the week! Posts: 716 OS: Linux/FreeBSD	I agree Skie, however I did review the source and it looks like mostly a bunch of GET requests so he should be relatively safe security wise. It wouldn't take maybe more then 30 minutes time to re-write it properly but if it were written prior to REGISTER_GLOBALS off then it would be a pretty darn decent piece of code =) __________________

12-27-2004, 10:42 PM	#9 (permalink)
shylock Registered User Join Date: Dec 2004 Location: BC Posts: 28 OS: WinXP Pro/FC2	Thanks very much for the help guys. At this point in time I'll reserve getting rid of the global variables because I have too much work to do. There are a LOT of pages, etc, involved with the site; therefore I'll do the editing on weekends or whatever. Oh, I almost forgot. All the code for the site was written a couple of years ago (2002), before the register_globals Off thing. If I understand correctly it might actually be ok for me to leave it as is, yes? Last edited by shylock; 12-27-2004 at 10:48 PM.

01-11-2005, 10:23 AM	#10 (permalink)
shylock Registered User Join Date: Dec 2004 Location: BC Posts: 28 OS: WinXP Pro/FC2	html editor Would you all know of an html editor for Linux/FC2 which is similar to Macromedia Dreamweaver? In-line html editing is a real pain sometimes

01-11-2005, 10:38 AM	#11 (permalink)
gotissues68 Senior Member Join Date: Sep 2002 Location: Vancouver Washington, Mountain View CA and Atlanta GA you pick the week! Posts: 716 OS: Linux/FreeBSD	I don't know of one off-hand no. I know you can run Dreamweaver via Crossover office but it of course costs money I think it runs 30 bucks or something and works pretty well. I use something called Jext http://www.jext.org which is a text editor but has syntax highlighting and macro's and what not. Let me know and I can put up a trial copy of crossover for you that I have. __________________

01-11-2005, 10:41 AM	#12 (permalink)
shylock Registered User Join Date: Dec 2004 Location: BC Posts: 28 OS: WinXP Pro/FC2	Any kind of help would be nice and I'll try just about anything. At this moment I'm using a simple text editor and I'm sure we all know how long and time-consuming that can be. Thanks.

01-11-2005, 01:58 PM	#13 (permalink)
Skie Manager, Alternative Comp Join Date: Mar 2003 Location: Chicago burbs Posts: 2,194 OS: Gentoo Linux, CentOS, OS X My System	You can take a look at Quanta which should be on your system if you have KDE. If not, you can download it here: http://sourceforge.net/project/showf...?group_id=4113. This is a KDE application, so you'll need some KDE files in order for it to run. It's not exactly WYSIWYG, but it fairly powerfull. The only other decent HTML editor that I know of is Nvu which is the Composer of Mozzila. Linspire (Lindows) took Composer and turned it into its own stand alone application and enhanced it. You can download it here: http://www.nvu.com/download.html. You can also purchase Zend Stuido. This is the only commercial HTML editor that I'm aware of for Linux. At least the only one worth mentioning. You can get it here: http://www.zend.com/store/products/zend-studio.php. However, it's geared more towards PHP then just plain HTML. Beyond those 3, I'm not aware of any decent HTML editor. __________________