FrontAccounting forum — Problem in Database information retrieval.

Re: Problem in Database information retrieval.

null@example.com (kvvaradha) — Wed, 10 Sep 2014 04:56:12 +0000

Thanks, both of you. i found the solution actually.

The problem is loging.php doesnot have the db connection. i mean, it doesnot have direct php script to query database. May be this is for security reasons. so i just created jshttprequest call method to perform my operations.,..

Now my issue is resolved.

Re: Problem in Database information retrieval.

null@example.com (apmuthu) — Wed, 10 Sep 2014 03:12:06 +0000

Unless you post the code in it's entirety, we cannot debug phantom entities.

Re: Problem in Database information retrieval.

null@example.com (barbarian) — Tue, 09 Sep 2014 11:37:04 +0000

Have you included the connect_db file?

Re: Problem in Database information retrieval.

null@example.com (kvvaradha) — Tue, 09 Sep 2014 04:44:37 +0000

Actually , the table name is 0_kv_sys_prefs. The problem is , its not working any mysql operations. it works after logged into the working area. the results gets exactly.

Which one prevent the Mysql functions in the login.php

is it preventing for sql injection or hijacking issues?

and guide me the safest thing to handle this operation.

Re: Problem in Database information retrieval.

null@example.com (apmuthu) — Mon, 08 Sep 2014 05:29:00 +0000

If kv_ is the TBPREFIX then it it is redundant. If it is a custom table, then check what condition makes it a specific record tied in with the $_POST variables from the login form. Also see if the scope and visibilityof the variables used is correct. Which file are you putting this code in?

Re: Problem in Database information retrieval.

null@example.com (kvvaradha) — Sun, 07 Sep 2014 13:22:04 +0000

mysql operations doesnot work on login.php. What should i do now?

Problem in Database information retrieval.

null@example.com (kvvaradha) — Sun, 07 Sep 2014 12:37:37 +0000

Hi, actually i created a custom table and add some fields, which are necessary to bring to the login page. but the problem is when use the following functions it will return the proper result on some other page. but the same query does not work on login.php page.

Can you help me to identify the problem in the query using in login page...

$sql="SELECT * FROM ".TB_PREF."kv_sys_prefs LIMIT 1";

$result = db_query($sql, "could not Process");

$kv_week_day_details = db_fetch($result);

echo json_encode($kv_week_day_details);