neworder( if(isset($_POST['submit'])) { $names = trim($_POST['mname']); $section = trim($_POST['section']); $stmt = $neworder->runQuery("SELECT * FROM marketsection WHERE market=:odn and section =:sc"); //$stmt->execute(array(":odn"=>$names)); $stmt->bindparam(":odn",$names) ; $stmt->bindparam(":sc",$section) ; //$row = $stmt->fetch(PDO::FETCH_ASSOC); $stmt->execute() ; if($stmt->rowCount() > 0) { $msg[] = " This Market section Has been registerd Before, Register Another"; } else { if($neworder->marketsection($names,$section)) { $msg[] = "$section... REGISTERED SUCCESSFULLY "; } else { $msg[] = "sorry , Some thing went wrong, try again"; } } } ?> Register Market

Registering Market Section

'; foreach ($msg as $item) { echo "
  • $item
  • "; //echo $pins ; } echo ''; ?>

    Summary

    prepare("select * from marketsection") ; $querry->execute() ; //$rw = $stmt->fetch(PDO::FETCH_ASSOC); $counter = 0; while($rw = $querry->fetch(PDO::FETCH_ASSOC)) { $counter = $counter + 1 ; echo "" ; //echo "" ; echo "" ; echo "" ; echo "" ; ///echo "" ; ?> " ; } ?>

    PREVIEW

    SN MARKET NAMES SECTIONS
    ACTION
    ".$rw['transdate']."".$counter."".$rw['market']."".$rw['section']."".$rw['LEVEL']."
    EDIT' class='btn btn-danger' onclick="return confirm('Are You Sure you want to delete this User ?')">DELETE