Monday, March 27, 2017
How to integrate kcfinder-filemanager in ckeditor(CKEditor in PHP Tutorial)
How to integrate kcfinder-filemanager in ckeditor(CKEditor in PHP Tutorial)
In this video, you will know how to integrate kcfinder-filemanager in ckeditor
links for ckeditor: http://ckeditor.com/
links for kcfinder https://kcfinder.sunhater.com/integrate
How to Display Mysql Data in a Select List of Bootstrap framework With php pdo?
Bootstrap link : http://getbootstrap.com/
.php mysql pdo connection
index.php file
<?Php
$dbhost = 'localhost';
$dbname = 'selectlist';
$dbuser = 'root';
$dbpass = '';
try{- $dbcon = new PDO("mysql:host={$dbhost};dbname={$dbname}",$dbuser,$dbpass);
$dbcon->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}catch(PDOException $ex){
die($ex->getMessage());
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->- <title>Bootstrap 101 Template</title>
<!-- Bootstrap -->
<!-- Latest compiled and minified CSS -->- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
</head>
<body>
<h1>Dynamic Select List in php mysql!</h1>
<div class="col-md-4">
<div class="form-group">
<label for="sel1">Select list:</label>
<select class="form-control" id="sel1">
<?php
$sqlquery = $dbcon->prepare('SELECT * FROM selectlist ORDER BY id DESC');- $sqlquery->execute();
while($row=$sqlquery->fetch(PDO::FETCH_ASSOC))
{
extract($row)
?>- <option>
<?php
echo $row['title'];
?>
</option>
<?php
}
?>
</select>
</div>
</div>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
</body>- </html>
How Can we Convert MySQL Rows into JSON Format in PHP PDO
How Can we Convert MySQL Rows into JSON Format in PHP PDO
In this video tutorial you will know How To Parse JSON With PHP
JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate.
JSON is a data exchange format between web/mobile applications.
It can easily convert data into plain text in human readable format.
Easily understand Get And Post Methods in PhP
Easily understand Get And Post Methods in PhP
Above Scripts
- <?php
- $x = 'Hello';
- echo $x;
- ?>
- <a href= "index.php?id">get</a>
- <?php
- if(isset($_GET['id']))
- {
- echo '<br>hello i got it';
- }
- ?>
- <form action="index.php" method="post">
- <input type="submit" value='post' name="submit">
- </form>
- <?php
- if(isset($_POST['submit']))
- {
- echo '<br>hello i got it';
- }
- ?>
Subscribe to:
Posts (Atom)