Jason Pruim wrote:
On Sep 26, 2008, at 11:22 AM, muhsin wrote:
Could you guys share your development setup, like what kinds of
software (IDE's/Editors) you are using for developing php scripts?
It might sound silly but I am just curios, as I just got started in
php programming en i have firefox + kate/bluefish + LAMP built with
gentoo.
Im mostly thinking that with only firefox and some logs left /var/log
or so, its not enough for me..Im looking for something like an IDE
which can allow me to debug code in steps in central manner approach
(ide), simplicity and efficiency...u know what i mean? :-D
Just kiddin bout simplicity ;-)
this has been discussed quite a bit over the years, but I just thought
I'd pipe up since I was in your spot a little over a year ago... What
I did then, and still do when I can't figure it out from the error log
is just a lot of echo "N"; through the application. That way, when I
see it makes it to 5 but not 6 I check the code between 5 and 6 and I
can usually spot the problem now.
If nothing else, it'll help you narrow down the problem before asking
questions here which most people are more then happy to do :)
Also... If you are dealing with databases (Since this is the DB list
:)) I'd recommend to echo out your db statements to make sure you are
doing what you think you are doing... Can't tell you how many times
that screwed me up...
Just my experience, take it or leave it :)
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
11287 James St
Holland, MI 49424
www.raoset.com
japruim@xxxxxxxxxx
Thanks Jason,
Actually its a Db/mysql-5.0.60-r1 issue which makes me wonder about
debugging techniques php.
Im stuck with this on my early scripts that im experimenting.These are
the echo of the SQL part:
INSERT INTO movietype (movietype_id, movietype_label) VALUE (1, 'Sci
Fi'), (2, 'Drama'), (3, 'Adventure'), (4, 'Comedy'), (5, 'Horror'), (6,
'Action'), (7, 'Kids')
INSTERT INTO people (people_id, people_fullname, people_isactor,
people_isdirector) VALUE (1, 'Jim Carrey', 1, 0), (2, 'Tom Shadyac', 0,
1), (3, 'Lawrence Kasdan', 0,1), (4, 'Kevin Kline', 1, 0), (5, 'Ron
Livingston', 1, 0), (6, 'Mike Judge', 0, 1)
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 'INSTERT
INTO people (people_id, people_fullname, people_isactor,
people_isdirect' at line 1
Followed by:
Duplicate entry '1' for key 1
And i just can narrow down whats hapenning on that part, which one of my
early scripts ...any idea?
The error is probably related the 2nd dB statement , but i cant figure
out whats making it throwing error :-
Cheers
--
Extra details:
OSS:Gentoo Linux-2.6.24
profile:amd64
Hardware:x86-64 msi geforce 8600GT asus p5k-se
location:/home/muhsin
language(s):C/C++,basic,VHDL,bash
Typo:40WPM
server(s) owned:
ftp://muhsinzubeir.homeftp.net
http://muhsinzubeir.homeftp.net
