LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 01-14-2004, 08:07 AM   #1
Siebe
LQ Newbie
 
Registered: Jan 2004
Distribution: RedHat 9.1
Posts: 10

Rep: Reputation: 0
MySQL editor


Hi,

I have been running Linux for some days now, and I was wondering, do you know a good program that can access my MySQL server and edit tables/databases etc? I know I can run PHPMyAdmin with Apache and PHP but I would prefer a "normal" program.

Oh and, does anyone know how I can make PHP be less strict
e.g.

echo "Hello, World"; will work just as good as echo 'Hello, World'; (sinlge quotes). And.. I can't use variables in my strings -> echo '$var is cool'; won't work.

Thanks
 
Old 01-14-2004, 08:13 AM   #2
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 197Reputation: 197
Re: MySQL editor

Quote:
Originally posted by Siebe
Hi,

I have been running Linux for some days now, and I was wondering, do you know a good program that can access my MySQL server and edit tables/databases etc? I know I can run PHPMyAdmin with Apache and PHP but I would prefer a "normal" program.
Define your terms when you say "normal"? I thought all programs were normal, its just the differences that set them aside from others.

You may want to check out http://sourceforge.net or http://freshmeat.net as they have tons of different applications you can search and browse thru, etc.
 
Old 01-14-2004, 08:17 AM   #3
Siebe
LQ Newbie
 
Registered: Jan 2004
Distribution: RedHat 9.1
Posts: 10

Original Poster
Rep: Reputation: 0
lol, "normal" as in a program, not a php editor or something like that.

Thanks, I'll check out the links
 
Old 01-14-2004, 08:49 AM   #4
poison
Member
 
Registered: Dec 2003
Location: Layer 7 =D
Distribution: Slackware, LFS, Rock Linux
Posts: 165

Rep: Reputation: 30
Quote:
I have been running Linux for some days now, and I was wondering, do you know a good program that can access my MySQL server and edit tables/databases etc
www.mysql.com -> MySQLCC ^^ it's really nice ...
Quote:
echo "Hello, World"; will work just as good as echo 'Hello, World'; (sinlge quotes). And.. I can't use variables in my strings -> echo '$var is cool'; won't work.
in single quoted strings variable interpolation doesn't occur =)
and the only characters you have to escape are ' (a single quote itself) and backslashs...so your literal could include double quotes without escsaping them ...like
Code:
$var='<img src="some_uri" alt="some pic" />';
if you want variables to be replaced by their values, you have to use double quoted strings...
Code:
echo "$var is cool";
will work...
or
Code:
echo "{$var}iable is cool";
to give the parser a hint that there is a variable
that's one of the many great features of PHP =D

Last edited by poison; 01-14-2004 at 08:56 AM.
 
Old 01-14-2004, 08:56 AM   #5
Siebe
LQ Newbie
 
Registered: Jan 2004
Distribution: RedHat 9.1
Posts: 10

Original Poster
Rep: Reputation: 0
Yes, I know, but when I use " it will show something like

<2 weird characters> string <2 weird characters>
something similar to

~<string>~
 
Old 01-14-2004, 09:03 AM   #6
poison
Member
 
Registered: Dec 2003
Location: Layer 7 =D
Distribution: Slackware, LFS, Rock Linux
Posts: 165

Rep: Reputation: 30
if you post that 2 lines I can tell you what you've done wrong...
but no, the behaviour of singe quotes and double quotes can not be changed (without hacking the source) because it's the way it was intended to work and it's the right way to go =)
 
Old 01-14-2004, 09:05 AM   #7
Siebe
LQ Newbie
 
Registered: Jan 2004
Distribution: RedHat 9.1
Posts: 10

Original Poster
Rep: Reputation: 0
Err, than why does it work on my WinXP system? (the quote thing)
Anyway, a simple

echo "Hello, World";

will cause it aswell. But when I do

echo 'Hello, World';

everything is just fine. I have learned PHP some years ago, and I never experienced something like this.
 
Old 01-14-2004, 10:24 AM   #8
poison
Member
 
Registered: Dec 2003
Location: Layer 7 =D
Distribution: Slackware, LFS, Rock Linux
Posts: 165

Rep: Reputation: 30
hmmm...maybe you saved it in some weird encoding...that was a thing I dealt with some time ago....
or ....wait a moment...you run *shivers* RedHat ? you don't have an outdated prebeta of PHP with redhat specific code you'll most likely get with it ?
compile PHP from source and it will work ^^

regards
 
Old 01-14-2004, 12:18 PM   #9
Siebe
LQ Newbie
 
Registered: Jan 2004
Distribution: RedHat 9.1
Posts: 10

Original Poster
Rep: Reputation: 0
LOL, yes I'm using RedHat 9

Ok, I will download a new PHP and compile it.. Erm, know WHERE I have to compile it to? And how to compile it lol
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock welery Linux - Software 19 03-06-2014 07:19 AM
vi editor and mysql slackerboy Slackware 8 12-19-2012 05:34 AM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 16 12-10-2012 02:34 AM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 01:52 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM


All times are GMT -5. The time now is 12:36 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration