Query with PHP and MySql [message #182262] |
Fri, 26 July 2013 06:06 |
Manju Bishnoi
Messages: 1 Registered: July 2013
Karma: 0
|
Junior Member |
|
|
Hi all,
I am using Wamp server with the package of Mysql, apache and PHP.. The problem i am facing is that i am unable to load more of data from FrontEnd(PHP) to Backend(MySql). Like i created 20 tables in one go in MySql and i connected all the tables with each other. And then i entered data into the form but it is not entering into the database. Values are directly inserting from database itself but is not working for frontend. And its not a problem of writing the wrong code, that i checked. The problem is occuring because in 1 database various tables are there otherwise it is working for small databases.Can anyone please help me to solve this problem. I also wanted to know that it is a proble in MySql or PHP. Please do reply as soon as possible.
Thank you
Regards:
Manju Bishnoi
|
|
|
Re: Query with PHP and MySql [message #182263 is a reply to message #182262] |
Fri, 26 July 2013 08:21 |
The Natural Philosoph
Messages: 993 Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 26/07/13 07:06, Manju Bishnoi wrote:
> Hi all,
> I am using Wamp server with the package of Mysql, apache and PHP.. The problem i am facing is that i am unable to load more of data from FrontEnd(PHP) to Backend(MySql). Like i created 20 tables in one go in MySql and i connected all the tables with each other. And then i entered data into the form but it is not entering into the database. Values are directly inserting from database itself but is not working for frontend. And its not a problem of writing the wrong code, that i checked. The problem is occuring because in 1 database various tables are there otherwise it is working for small databases.Can anyone please help me to solve this problem. I also wanted to know that it is a proble in MySql or PHP. Please do reply as soon as possible.
>
> Thank you
>
> Regards:
> Manju Bishnoi
do yu have the correct PHP client mysql libraries installed and configured?
--
Ineptocracy
(in-ep-toc’-ra-cy) – a system of government where the least capable to lead are elected by the least capable of producing, and where the members of society least likely to sustain themselves or succeed, are rewarded with goods and services paid for by the confiscated wealth of a diminishing number of producers.
|
|
|
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: 0
|
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
|
|
|
Re: Query with PHP and MySql [message #182266 is a reply to message #182262] |
Fri, 26 July 2013 11:00 |
Jerry Stuckle
Messages: 2598 Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 7/26/2013 2:06 AM, Manju Bishnoi wrote:
> Hi all,
> I am using Wamp server with the package of Mysql, apache and PHP.. The problem i am facing is that i am unable to load more of data from FrontEnd(PHP) to Backend(MySql). Like i created 20 tables in one go in MySql and i connected all the tables with each other. And then i entered data into the form but it is not entering into the database. Values are directly inserting from database itself but is not working for frontend. And its not a problem of writing the wrong code, that i checked. The problem is occuring because in 1 database various tables are there otherwise it is working for small databases.Can anyone please help me to solve this problem. I also wanted to know that it is a proble in MySql or PHP. Please do reply as soon as possible.
>
> Thank you
>
> Regards:
> Manju Bishnoi
>
You have one of two problems. Your PHP is wrong, or your SQL is wrong.
But you haven't given us anything to go on.
Turn on error messages and display them (for debugging purposes). In
your php.ini file, put:
error_reporting = E_ALL
display_errors=on
Ensure you are checking the return value of ALL MySQL calls to see that
they functioned correctly.
If all else fails, post the failing code (if it's long, cut it down to
the minimum necessary to recreate the problem) here.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
Re: Query with PHP and MySql [message #182272 is a reply to message #182262] |
Sat, 27 July 2013 07:41 |
Thomas 'PointedEars'
Messages: 701 Registered: October 2010
Karma: 0
|
Senior Member |
|
|
Manju Bishnoi wrote:
> I am using Wamp server with the package of Mysql, apache and PHP.. The
> problem i am facing is that i am unable to load more of data from
> FrontEnd(PHP) to Backend(MySql). Like i created 20 tables in one go in
> MySql and i connected all the tables with each other. And then i entered
> data into the form but it is not entering into the database. Values are
> directly inserting from database itself but is not working for frontend.
> And its not a problem of writing the wrong code, that i checked. The
> problem is occuring because in 1 database various tables are there
> otherwise it is working for small databases.Can anyone please help me to
> solve this problem. I also wanted to know that it is a proble in MySql or
> PHP. Please do reply as soon as possible.
<http://www.catb.org/~esr/faqs/smart-questions.html>
HTH
PointedEars
--
Prototype.js was written by people who don't know javascript for people
who don't know javascript. People who don't know javascript are not
the best source of advice on designing systems that use javascript.
-- Richard Cornford, cljs, <f806at$ail$1$8300dec7(at)news(dot)demon(dot)co(dot)uk>
|
|
|
|