mysql select * or desired parameters in php function

Question

I have a function which selects the * values from a particular table, I need to configure that if I pass * in parameter then it selects all or the selected parameters.

My function is as follows:

  public function select($tablename){
          $select = mysql_query("SELECT * FROM $tablename");
          if(!$select){
              echo "cant select table mane";
              }
          while ($row = mysql_fetch_array($select)){

              print_r($row);
              }
          }

How can I pass the dynamic colum name in place of *

Avoid mysql, it is deprecated. Use mysqli or PDO instead.

Alex
– Alex

2013-03-22 12:20:01 +00:00
Commented Mar 22, 2013 at 12:20 — Alex
– Alex, Commented Mar 22, 2013 at 12:20
you should have searched it before posting here

Deepanshu Goyal
– Deepanshu Goyal

2013-03-22 12:22:27 +00:00
Commented Mar 22, 2013 at 12:22 — Deepanshu Goyal
– Deepanshu Goyal, Commented Mar 22, 2013 at 12:22

Yogesh Suthar · Accepted Answer · 2013-03-22 12:19:20Z

1

public function select($tablename,$column=NULL){
      if($column == null) {
          $select = mysql_query("SELECT *  FROM $tablename");
      } else {
          $select = mysql_query("SELECT ".$column."  FROM $tablename");
      }

call it using select("abcd_table","id,name"); OR for all just select("abcd_table");

By Alex

Avoid mysql, it is deprecated. Use mysqli or PDO instead

answered Mar 22, 2013 at 12:19

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

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

Comments

brainraider · Accepted Answer · 2013-03-22 12:29:46Z

1

That's even easier:

public function select( $tablename , $columnName = array() ){
   $columnName = $columnName ? implode( ',' , $columnName ) : '*';
   $select     = mysql_query( 'SELECT ' . $columnName . ' FROM ' . $tableName );
   if(!$select){
      echo "cant select table mane";
   }
   while ($row = mysql_fetch_array($select)){
      print_r($row);
   }
}

answered Mar 22, 2013 at 12:29

brainraider

615 bronze badges

Comments

Zoe - Save the data dump · Accepted Answer · 2019-05-25 14:25:40Z

1

Add one more parameter $columnname type array in your function.

   public function select($tablename,$columnname = array()){
      if(count($columnname)){
         $columnname = implode(",",$columnname);
         $select = mysql_query("SELECT {$columnname} FROM $tablename");
      }  
      else{
        $select = mysql_query("SELECT * FROM $tablename");
      }
      #code continue
   }

Calling will be like below

To select all fields,

select($tablename);

To select some fields,

select($tablename,array('field','field2'));

Note: Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO, or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

edited May 25, 2019 at 14:25

Zoe - Save the data dump

28.4k22 gold badges130 silver badges163 bronze badges

answered Mar 22, 2013 at 12:20

Rikesh

26.5k14 gold badges82 silver badges90 bronze badges

Comments

suspectus · Accepted Answer · 2013-03-22 12:19:44Z

0

public function select($tablename, $selectrow){
          $select = mysql_query("SELECT $selectrow FROM $tablename");
          if(!$select){
              echo "cant select table mane";
          }
          while ($row = mysql_fetch_array($select)){
              print_r($row);
          }
}

answered Mar 22, 2013 at 12:19

suspectus

17.4k8 gold badges56 silver badges63 bronze badges

Comments

Prashant Shukla · Accepted Answer · 2013-03-22 12:26:25Z

0

try this modified function

public function select($tablename,$array_fields){
    if(!empty($array_fields)){
      $fieldstr = implode(',',$array_fields);
      $fieldstr = trim($fieldstr,',');
    }else{
        $fieldstr = '*';
    }
      $select = mysql_query("SELECT $fieldstr FROM $tablename");
      if(!$select){
          echo "cant select table mane";
          }
      while ($row = mysql_fetch_array($select)){

          print_r($row);
          }

}

answered Mar 22, 2013 at 12:26

Prashant Shukla

3291 gold badge2 silver badges18 bronze badges

Comments

user7282 · Accepted Answer · 2013-03-22 12:26:38Z

0

 public function select($tablename,$column="*"){

          $select = mysql_query("SELECT $column FROM $tablename");
          if(!$select){
              echo "cant select table mane";
              }
          while ($row = mysql_fetch_array($select)){

              print_r($row);
              }
          }

call like select("table","*") or call like select("table","col1,col2")

edited Mar 22, 2013 at 12:26

answered Mar 22, 2013 at 12:18

user7282

5,1969 gold badges44 silver badges73 bronze badges

Collectives™ on Stack Overflow

mysql select * or desired parameters in php function

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related