FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » Query with PHP and MySql
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Query with PHP and MySql [message #182262] Fri, 26 July 2013 06:06 Go to next message
Manju Bishnoi is currently offline  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 Go to previous messageGo to next message
The Natural Philosoph is currently offline  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 Go to previous messageGo to next message
Denis McMahon is currently offline  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 Go to previous messageGo to next message
Jerry Stuckle is currently offline  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 Go to previous messageGo to next message
Thomas 'PointedEars'  is currently offline  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>
Re: Query with PHP and MySql [message #182273 is a reply to message #182262] Sat, 27 July 2013 07:53 Go to previous message
Luuk is currently offline  Luuk
Messages: 329
Registered: September 2010
Karma: 0
Senior Member
On 26-07-2013 08:06, Manju Bishnoi wrote:
> Please do reply as soon as possible.

OK

;)
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: A curious thing...about tags.
Next Topic: Variable variables?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 09 16:38:20 GMT 2024

Total time taken to generate the page: 0.02060 seconds