pdo query alter table where column name not existing?

Question

 <?php
   $month=$_SESSION['month'];
    $colname=$_SESSION['colname'];
require('connect.php');
global $pdo;
 $stmt=$pdo->prepare('SHOW COLUMNS FROM `selections` LIKE ":s%"');
$stmt=bindParam(':s',$colname);$stmt->execute();$row =$stmt->fetch()?true:false;
if($row==false){$sql=$pdo->prepare("ALTER TABLE  `$month` ADD  `$colname` VARCHAR( 120)NOT NULL DEFAULT 'absent'");
$sql->execute();}else{die("error".print_r($sql>errorinfo()));
}
 ?>

code error Call to undefined function bindParam(); bindparm error here $month is month select dynamically by user and $colname is also select by user

<?php
$month=$_SESSION['month'];
$colname=$_SESSION['colname'];
$tot='present';
require('connect.php');
  global $pdo;
$stmt=$pdo->prepare("UPDATE `$month` SET `$colname`=:a WHERE roll =:foo");
 $stmt=bindparam(':a',$tot);
  foreach( $value as $value)
           {
      $stmt>bindParam(':foo',$value);
       $stmt->execute();
          }
    if($stmt==false)
   {    
     die("error".print_r($stmt->errorinfo()));
      } ?>

Please format the code

user924016
– user924016

2013-12-30 07:50:05 +00:00
Commented Dec 30, 2013 at 7:50 — user924016
– user924016, Commented Dec 30, 2013 at 7:50
@user3144122 , why do you revert the formatting edit ?

Raptor
– Raptor

2013-12-30 08:07:13 +00:00
Commented Dec 30, 2013 at 8:07 — Raptor
– Raptor, Commented Dec 30, 2013 at 8:07

Raptor · Accepted Answer · 2013-12-30 07:59:54Z

2

Error 1

You probably mean :

$stmt->bindParam(':s',$colname);

Error 2

Also, you haven't started your session by session_start()

Error 3

It should be:

die("error".print_r($sql->errorinfo(), true));

Error 4

You may want:

$stmt->bindParam(':foo',$value);

instead of:

$stmt>bindParam(':foo',$value);

by the way, you prefer to write codes in single line?

answered Dec 30, 2013 at 7:59

Raptor

54.4k47 gold badges254 silver badges405 bronze badges

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

Comments

Awlad Liton · Accepted Answer · 2013-12-30 10:08:56Z

-1

try this:

session_start();
$month=$_SESSION['month'];
$colname=$_SESSION['colname'];
require('connect.php');
global $pdo;
$stmt=$pdo->prepare('SHOW COLUMNS FROM `selections` LIKE :s');
$query->bindValue(":s", $stmt);
$stmt->execute();
$row =$stmt->fetch()?true:false;
if($row==false){
  $sql=$pdo->prepare("ALTER TABLE  `$month` ADD  `$colname` VARCHAR( 120 )NOT NULL DEFAULT 'absent'");
  $sql->execute();
}else{
  die("error".print_r($sql>errorinfo()));
}

For second ERROR:

$month=$_SESSION['month'];
$colname=$_SESSION['colname'];
$tot='present';
require('connect.php');
global $pdo;
$stmt=$pdo->prepare("UPDATE `$month` SET `$colname`=:a WHERE roll =:foo");
$stmt=bindparam(':a',$tot);
 //I don't know what are in the $value
foreach( $value as $v){
    $stmt->bindParam(':foo',$v);
    if( !$stmt->execute())
    {
        die("error".print_r($stmt->errorinfo()));
    }
}

edited Dec 30, 2013 at 10:08

answered Dec 30, 2013 at 8:02

Awlad Liton

9,3513 gold badges30 silver badges53 bronze badges

4 Comments

user3144122 Over a year ago

sir my second code not work properly where data insert into data base

Awlad Liton Over a year ago

@user3144122 : First try it. If not worked then tell me the output of var_dump($value);

user3144122 Over a year ago

thank you sir its working thank you for your kind help for your valuable time....

Awlad Liton Over a year ago

@user3144122 : If it worked please Click the tick (check mark) on left under the vote arrows.It will be a green mark if it is accepted correctly.

Collectives™ on Stack Overflow

pdo query alter table where column name not existing?

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related