Friday, May 29, 2015

Drop Down Value Fetch through ID and show name






<select class="form-control" name="country_id" value="">
<!--  DDL #######################################################################-->
<?php
include("config.php");
$select=mysql_query("select * from countrylists");
?>
<?php
while($row=mysql_fetch_array($select))

{
?><option value="<?php echo $row["id"]  ?>"><?php echo $row["name"] ?></option>


<?php
}
?>
<!--  DDL #######################################################################-->
</select>

Tuesday, May 26, 2015

CKEDITOR CODE


// ADD CKEDITOR folder also by downloading 

<!DOCTYPE html>
<html>
  <head>





<!-- CKEDITOR Script Start -->

<script src="ckeditor/ckeditor.js"></script>

<link rel="stylesheet" href="sample.css">

<script>



var editor;



// The instanceReady event is fired, when an instance of CKEditor has finished

// its initialization.

CKEDITOR.on( 'instanceReady', function( ev ) {

editor = ev.editor;



// Show this "on" button.

document.getElementById( 'readOnlyOn' ).style.display = '';



// Event fired when the readOnly property changes.

editor.on( 'readOnly', function() {

document.getElementById( 'readOnlyOn' ).style.display = this.readOnly ? 'none' : '';

document.getElementById( 'readOnlyOff' ).style.display = this.readOnly ? '' : 'none';

});

});



function toggleReadOnly( isReadOnly ) {

// Change the read-only state of the editor.

// http://docs.ckeditor.com/#!/api/CKEDITOR.editor-method-setReadOnly

editor.setReadOnly( isReadOnly );

}



</script>

<!-- CKEDITOR Script Closed -->


 
 
 
 
 
    <meta charset="UTF-8">
    <title>Poison Information </title>

    <meta content='width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no' name='viewport'>
    <!-- Bootstrap 3.3.2 -->

  </head>
  <body class="skin-blue">
 
<?php include("header.php");?>

<div class="content-wrapper">
<?php include("navbar.php");?>
        <!-- Content Header (Page header) -->
        <section class="content-header">

          <h1>
Poison Information
          </h1>

          <ol class="breadcrumb">
            <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
            <li><a href="#">Poison Information</a></li>
            <li class="active"> Poison Information Form</li>
          </ol>
        </section>

<!-- Main content -->
        <section class="content">
<div class="row form-group">
            <!-- right column -->
            <div class="col-md-12">
              <!-- general form elements disabled -->
              <div class="box box-warning">
<div class="box-body">




<!-- insert form here -->
<form method="post" action="main_poison_information_heading.php">
<div class="row form-group">
<div class="col-lg-12">
<div class="col-lg-6">
Main Poison Information Heading
</div>

<div class="col-lg-6">
<input type="text" name="main_heading" placeholder="Main Heading"class="form-control" id="exampleInputEmail1">
</div>




</div>

<!-- CKEDITOR TEXTAREA START -->

<div class="col-lg-12">
<div class="col-lg-12">
<textarea name="ckeditor" id="email_content" class="ckeditor" id="email_content" cols="100" rows="10"></textarea>
</div>
</div>

<!-- CKEDITOR TEATAREA Closed -->

<div class="col-lg-12">
<div class="col-lg-12">
<input type="submit"name="sub" value=" Add Poison Information Headings">
<a href="search.php"><input type="button" name="sub" value=" Search Poison"></a>
</div>
</div>
</div>
</form>



             <!-- insert form here -->
  </div><!-- /.box-body -->
              </div><!-- /.box -->
            </div><!--/.col (right) -->
          </div>   <!-- /.row -->
        </section><!-- /.content -->
      </div>
<?php
include("footer.php");
?>

</body>
</html>

View Pop Up on fetch Page in PHP [Consider CSS Part ]





<!DOCTYPE html>
<html>
  <head>
    <meta charset="UTF-8">
    <title>TechNaitra | Dashboard</title>
    <meta content='width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no' name='viewport'>
    <!-- Bootstrap 3.3.2 -->
<!-- Start CSS For Pop Up on View Button -->
<style>
.modalDialog {
position: fixed;
font-family: Arial, Helvetica, sans-serif;
top: 0;
right: 0;
bottom: 0;
left: 0;
background: rgba(0,0,0,0.8);
z-index: 99999;
opacity:0;
-webkit-transition: opacity 400ms ease-in;
-moz-transition: opacity 400ms ease-in;
transition: opacity 400ms ease-in;
pointer-events: none;
}

.modalDialog:target {
opacity:1;
pointer-events: auto;
}

.modalDialog > div {

position: relative;
margin: 20px;
padding: 30px;
border-radius: 10px;
background: #fff;
background: -moz-linear-gradient(#fff, #999);
background: -webkit-linear-gradient(#fff, #999);
background: -o-linear-gradient(#fff, #999);
}

.close {
background: #fff;
color: #FFFFFF;
line-height: 25px;
position: absolute;
right: -12px;
text-align: center;
top: -10px;
width: 24px;
text-decoration: none;
font-weight: bold;
-webkit-border-radius: 12px;
-moz-border-radius: 12px;
border-radius: 12px;
-moz-box-shadow: 1px 1px 3px #000;
-webkit-box-shadow: 1px 1px 3px #000;
box-shadow: 1px 1px 3px #000;
opacity:1 !important;
}

.close:hover { background: #00d9ff; }
</style>

<!-- Close CSS For Pop Up on View Button -->
  </head>
  <body class="skin-blue">
 
<?php

include("sidebar.php");
?>

<div class="content-wrapper">
<!-- Nav bar here -->
<?php include("navbar.php"); ?>
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            Student Admission Form
          </h1>
          <ol class="breadcrumb">
            <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
            <li><a href="#">Forms</a></li>
            <li class="active">Student Admission Form</li>
<li class="active">Show</li>
          </ol>
        </section>






<!-- Main content -->
        <section class="content">
          <div class="row">
            <div class="col-xs-12">



<div class="box">
                <div class="box-header">
                  <h3 class="box-title">Data Table With Full Features</h3>
                </div><!-- /.box-header -->
                <div class="box-body">

<?php
error_reporting(0);

include("config.php");
$select = mysql_query("select * from drug_list");
//echo "$select";
?>
<table class="table table-bordered table-striped">
<tr>

<th>Brand Name</th>
<th>Ingredients</th>
<th>Purpose</th>
<th>Category</th>
<th>Class</th>
<th>State</th>
<th>Colour</th>
<th colspan="3">Operations</th>


</tr>

<?php
while($row=mysql_fetch_array($select))
{
?>
<tr>
<td><?php echo $row['brand_name']."<br>"; ?> </td>
<td><?php echo $row['ingredients']."<br>"; ?> </td>
<td><?php echo $row['purpose']."<br>"; ?> </td>
<td><?php echo $row['category']."<br>"; ?> </td>
<td><?php echo $row['class']."<br>"; ?> </td>
<td><?php echo $row['state']."<br>"; ?> </td>
<td><?php echo $row['colour']."<br>"; ?> </td>


        <td> <a href="edit_drugs_list.php?

brand_name=<?php echo $row['brand_name']?>&
ingredients=<?php echo $row['ingredients']?>&
purpose=<?php echo $row['purpose']?>&
category=<?php echo $row['category']?>&
class=<?php echo $row['class']?>&
state=<?php echo $row['state']?>&
colour=<?php echo $row['colour']?>&
odour=<?php echo $row['odour']?>&
toxic_dose_specified=<?php echo $row['toxic_dose_specified']?>&
lethal_dose_specified=<?php echo $row['lethal_dose_specified']?>&
antidote_specified=<?php echo $row['antidote_specified']?>&
first_aid_measures=<?php echo $row['first_aid_measures']?>&
quantity=<?php echo $row['quantity']?>

">


Edit </a> </td>

<td> <a href="delete_drugs_list.php?drug_list_id=<?php echo $row['drug_list_id']?>">Delete</a> </td>



<td>
<a href="#w<?php echo $row['drug_list_id']?>" >View Details</a>
<div id="w<?php echo $row['drug_list_id']?>" class="modalDialog">
<div>
<a href="#close" title="Close" class="close">X</a>

<table border="1"><tr><td>Drug List_Id</td><td><?php echo $row['drug_list_id']?></td></tr>
<tr><td>Brand Nname</td><td><?php echo $row['brand_name']?></td></tr>
<tr><td>Ingredients</td><td><?php echo $row['ingredients']?></td></tr>
<tr><td>Purpose</td><td><?php echo $row['purpose']?></td></tr>
<tr><td>Category</td><td><?php echo $row['category']?></td></tr>
<tr><td>Class</td><td><?php echo $row['class']?></td></tr>
<tr><td>State</td><td><?php echo $row['state']?></td></tr>
<tr><td>Colour</td><td><?php echo $row['colour']?></td></tr>
<tr><td>Odour</td><td><?php echo $row['odour']?></td></tr>
<tr><td>Toxic Dose Specified</td><td><?php echo $row['toxic_dose_specified']?></td></tr>
<tr><td>Lethal Dose Specified</td><td><?php echo $row['lethal_dose_specified']?></td></tr>
<tr><td>antidote Specified</td><td><?php echo $row['antidote_specified']?></td></tr>
<tr><td>First Aid Mmeasures</td><td><?php echo $row['first_aid_measures']?></td></tr>
<tr><td>Quantity</td><td><?php echo $row['quantity']?></td></tr></table>
</div>
</div>

</td>
</tr>

<?php
}
?>



















  </table>
                </div><!-- /.box-body -->
              </div><!-- /.box -->
            </div><!-- /.col -->
          </div><!-- /.row -->
        </section><!-- /.content -->
      </div><!-- /.content-wrapper -->