On Sep 26, 2008, at 1:17 PM, muhsin wrote:
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 :-
Looking at it the first thing that stands out to me is the way you are
breaking up the values... If I was doing it, my insert would look
like: INSERT INTO people (people_id, people_fullname, people_isactor,
people_isdirector) VALUES ("1", "Jim Carrey", "1", "0");
Notice also that I used the keyword VALUES (The S on the end) and a
semi colon on the end of the line, it may be there, but it didn't come
through :)
One other thing to try is to try and submit that directly to the
database... See if that gives you any other errors which occasionally
happens.
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
11287 James St
Holland, MI 49424
www.raoset.com
japruim@xxxxxxxxxx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
