Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #10213 > unrolled thread

Query with PHP and MySql

Back to article view | Back to comp.lang.php

Contents

  Query with PHP and MySql Manju Bishnoi <manjubishnoi09@gmail.com> - 2013-07-25 23:06 -0700
    Re: Query with PHP and MySql The Natural Philosopher <tnp@invalid.invalid> - 2013-07-26 09:21 +0100
    Re: Query with PHP and MySql Denis McMahon <denismfmcmahon@gmail.com> - 2013-07-26 09:32 +0000
    Re: Query with PHP and MySql Jerry Stuckle <jstucklex@attglobal.net> - 2013-07-26 07:00 -0400
    Re: Query with PHP and MySql Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-07-27 09:41 +0200
    Re: Query with PHP and MySql Luuk <luuk@invalid.lan> - 2013-07-27 09:53 +0200

#10213 — Query with PHP and MySql

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

[toc] | [next] | [standalone]

#10214

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.

[toc] | [prev] | [next] | [standalone]

#10215

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@gmail.com

[toc] | [prev] | [next] | [standalone]

#10217

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@attglobal.net
==================

[toc] | [prev] | [next] | [standalone]

#10225

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@news.demon.co.uk>

[toc] | [prev] | [next] | [standalone]

#10226

On 26-07-2013 08:06, Manju Bishnoi wrote:
> Please do reply as soon as possible.

OK

;)

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.php

csiph-web