| Re: Query with PHP and MySql [message #182264 is a reply to message #182262] |
Fri, 26 July 2013 09:32   |
Denis McMahon
Messages: 634
Registered: September 2010
Karma:
|
Senior Member |
|
|
On Thu, 25 Jul 2013 23:06:58 -0700, Manju Bishnoi wrote:
> Please do reply as soon as possible.
Hi
You haven't given us anywhere near enough information to determine if
this is:
a) A problem with your php.
b) A problem with your sql.
The role of php in an system like yours is limited to taking data from
the web forms, assembling it into sql queries, calling the sql daemon to
process those queries, and then presenting the results of the queries
back to the web user.
The most common problem[1] is assembling invalid sql statements. That is
an sql problem, and you need to work out what the correct sql is.
To test this, you need to check out the sql error handling features for
the php interface to mysql that you're using, and see what errors you are
getting. You then need to analyse the sql that you are generating,
probably with reference to the table definitions, to see why it is
generating those errors.
You also need to check whether you are getting php execution errors that
might be causing the invalid sql to be generated, or even preventing the
database calls happening. To do this, you need to enable appropriate php
error logging and check the relevant log files.
I have no experience of wamp, so I have no idea where to look for the
relevant log or configuration files on your system, or what the optimum
settings are for debugging. Sorry that I can't help any further.
[1] It seems to me, anyway, that most people coming here with a php / sql
problem are generating broken sql with valid php code, rather than having
php specific issues. Similar to those people who blame php for their
broken webpages when the problem is that they're telling php that
generate invalid / broken html. The php is just doing what they tell it
to.
--
Denis McMahon, denismfmcmahon(at)gmail(dot)com
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]