select query through function.. to fetch data from db

Question

How do I fetch data from db using select query in a function?

Example

function ec_select_query($student, $row = '', $fields=array()) {
    $qry = "SELECT * FROM student";
    $qry = mysql_query($qry);

    while($row = mysql_fetch_assoc($qry)){}

    return $row;
}

Put your question with some sort of well formatted code man? — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Mar 27, 2015 at 6:06

ajaykumartak · Accepted Answer · 2015-03-27 06:54:53Z

1

If you want to return all rows then first save it in an array in while loop then return this array.

function ec_select_query($student,$row='',$fields=array())
{
   $qry = "SELECT * FROM student";
   $qry = mysql_query($qry);
   $result = array();   
   while($row = mysql_fetch_assoc($qry))
   {
       $result[] = $row;
   }     
    return $result;
 }

edited Mar 27, 2015 at 6:54

answered Mar 27, 2015 at 6:10

ajaykumartak

7769 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

DavidPostill Over a year ago

Could you please edit your answer to give an explanation of why this code answers the question? Code-only answers are discouraged, because they don't teach the solution.

Sudhir · Accepted Answer · 2015-03-27 09:49:38Z

1

Its is running code. Modify it according to your needs

$con = mysql_connect('localhost','root','') or die("Unable to connect to MySQL");
mysql_select_db('demo', $con) or die("Database not found");

function ec_select_query($student)
 {
   $query = "SELECT * FROM $student";
   $result = mysql_query($query);
   $row = array();
   $getData = array();
   while($row = mysql_fetch_array($result))
    {
       $getData[]=$row;
    } 
    return $getData;
 }
$information = ec_select_query('accountplans');
echo "<pre>"; print_r($information); die;

edited Mar 27, 2015 at 9:49

answered Mar 27, 2015 at 9:44

Sudhir

83312 silver badges33 bronze badges

Comments

Jay Dhameliya · Accepted Answer · 2015-03-27 07:55:50Z

Try it

function select_query($table, $where=array(),$fields=array()){

    $select_fields = $table."*";

    if(!empty($fields) && is_array($fields)){
        $select_fields = implode(",", $fields);
    }

    $sql = "select ".$select_fields." from ".$table." where 1=1 ";

    if(!empty($where) && is_array($where)){
        foreach ($where as $key => $value) {
            $sql .= " AND ".$value;
        }
    }
    $query = mysql_query($sql);
    $result = array();
    while($row = mysql_fetch_assoc($result)){
        $result[] = $row;
    }
    return $result;
}

Call Function

$fields = array("id","name","city");
$where = array('name = "abc"','city like "aaa"');

$students = select_query("studendts", $where, $fields);

Khalid · Accepted Answer · 2015-03-27 09:09:07Z

0

This code might help you :

 function ec_select_query($student,$row='',$fields=array())
 {
    $q = "SELECT * FROM student";
    $q = mysql_query($qry);
    while($row = mysql_fetch_array($qry))
    {
        return $row;
    } 
 }

edited Mar 27, 2015 at 9:09

Khalid

4,8285 gold badges29 silver badges50 bronze badges

answered Mar 27, 2015 at 6:15

Iññoceñt Ùšmâñ

3341 gold badge6 silver badges16 bronze badges

Comments

Pankaj katiyar · Accepted Answer · 2015-03-27 09:21:52Z

0

It is easiest way to produce entire data in array

 function db_set_recordset($sql) {
        $qry = mysql_query($sql);
        $row= array();
        while($out = mysql_fetch_assoc($qry)) {

                $row[] = $out;

        }
        return $row;
} 

$qry     = "SELECT * FROM student";
$result  = db_set_recordset($qry);

answered Mar 27, 2015 at 9:21

Pankaj katiyar

46410 silver badges26 bronze badges

Collectives™ on Stack Overflow

select query through function.. to fetch data from db

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related