Mr.HaraRock Programmer: มกราคม 2019

วันศุกร์ที่ 25 มกราคม พ.ศ. 2562

How to Connection to Databases PHP by PDO

Hi! Every One ສະບາຍດີມືນີ້ມາພົບກັບການ ຂຽນ File Connect to DB ແບບ PDO ຊຶ່ງຈະມີຂັ້ນຕອນທີ່ງ່າຍດາຍ ແຕ່ຈະຂຽນໃນຮູບແບບ Mysql
1. phpinfo ເພື່ອຫາ Extension ໃນ ເຄື່ອງເຮົາວ່າຮອງຮັບການຂຽນແບບ PDO ໄດ້ບໍ
=======================================
<?php
phpinfo();
?>
=======================================
Run ຜ່ານ localhost/PDO(PDO ແມ່ນຊື່ໄຟລ໌ Server ຈຳລອງຂອງເຮົາ ໃຫ້ຕັ້ງຊື່ຕາມເລີຍ)/phpinfo.php

Extension to PDO

ຖ້າເຄື່ອງໃຜບໍ່ມີ ໃຫ້ໄປຫາ Download Key Word : download pdo extension php ແລ້ວໄປຕິດຕັ້ງ
ເມື່ອຕິດຕັ້ງແລ້ວ ມາເຂົ້າສູ່ການຂຽນ ຕິດຕໍ່ກັບຖານຂໍ້ມູນເລີຍ

con.php
=======================================
<?php
$serverName = "localhost";
$userName = "root";
$userPassword = "44@44";
$dbName = "mydatabase";
$conn = new PDO('mysql:host=localhost;dbname=mydatabase', $userName, $userPassword);
$conn->exec("set names utf8");

if($conn){
echo "Successfully to Connection ";
}else{
echo "Can't to Successfully Connection";
}

?>
=======================================
references Read More : http://php.net/manual/en/book.pdo.php

วันอังคารที่ 22 มกราคม พ.ศ. 2562

Excel Easy Export

ສະບາຍດີ ມື້ນີ້ຈະມາສອນແລະ ນຳສະເໜີ ການຂຽນ Excel Easy Export With PHP by OOP ຈະມີຂັ້ນຕອນທີ່ງ່າຍແລະ ສາມາເຮັດຕາມໄດ້ ດັ່ງນີ້ ===================================================
<!DOCTYPE HTML>
<html>

<head>
<title>OOP Export to Excel</title>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE-Edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<body>
<style type="text/css">
body{
font-family:'Saysettha MX',Phetsarath OT,Saysettha OT,sans-serif;
font-size:12.5px;
}

</style>
<?php
$localhost = "localhost";
$root = "root";
$pass = "44@44";
$db_staffdata = "mydatabase";
$con = new mysqli($localhost,$root,$pass,$db_staffdata);
mysqli_query($con,"set names utf8");
if($con->connect_errno) {
echo $con->connect_error;
exit;
}
?>
<?php
$filName = "Export.csv";
$objWrite= "utf8_unicode_ci";
$objWrite = fopen("Export.csv","w","utf8_unicode_ci");
mb_convert_encoding($Do, 'UTF-16LE', 'UTF-8');
mb_convert_encoding($SEl, 'UTF-16LE', 'UTF-8');
?>
<?php
$SEl = " SELECT * FROM user ORDER BY UserID ASC ";
$Table = $con->query($SEl);

fputs($objWrite, $bom =( chr(0xEF) . chr(0xBB) . chr(0xBF) ));
fwrite($objWrite, ",\"UserID\",\"UserName\",\"Email\"\n");
$i=0;
while($S= $Table->fetch_assoc())
{
$i++;
fwrite($objWrite, ",\"$S[UserID]\",\"$S[UserName]\",\"$S[Email]\"\n");

}
fclose($objWrite);
echo "<a href=$filName><img src='' width='40' title='Export to Excel' height='40' class='non-printable'/></a>";
?>
</body>
</html>

===================================================
out put

Click For Download

after to Download And Opening

Support MS 2010 to Higher Version

Result

database, table user and fields

Bring it on !!!! ຈົບແລ້ວສຳຫລັບບົດຄວາມນີ້ ແນວທາງງ່າຍໆ ໝູ່ເພື່ອນທ່ານທີ່ສົນໃຈ ສາມາດເຂົ້າມາເບິ່ງ ຫລື ສົນໃຈໃຫ້ຂຽນບົດຄວາມໃດ ສາມາດ Comment ໄດ້ເດິ້ ຫວັງວ່າສິເປັນປະໂຫຍດແກ່ ຜູ້ເຂົ້າມາອ່ານທຸກຄົນ

วันศุกร์ที่ 18 มกราคม พ.ศ. 2562

How to Random mysql PHP By OOP

ສະບາຍດີ !!! ບົດຄວາມນີ້ ມາແນະນຳກ່ຽວກັບການ SELECT + Rand ເປັນການ Random ເອົາ ຈາກ Table user
ຊຶ່ງຈະມີຂັ້ນຕອນງ່າຍໆ ມາລອງເຮັດກັນເລີຍ

=======================================
rand.php
=======================================
<?php
// connect oop mysqli
$localhost = "localhost"; //localhost server ຈຳລອງຜ່ານ web server Xampp,Appserv
$root = "root"; // root ຂອງການຕິດຕັ້ງ ໃນ web server
$pass = "44@44"; // ລະຫັດຜ່ານທີ່ຕິດຕັ້ງໄວ້ ໃນ web server
$db = "mydatabase"; // database ທີ່ຕ້ອງການຈະຕິດຕໍ່
$con= new mysqli($localhost,$root,$pass,$db); // connection
mysqli_query($con,"set names utf8"); // set ພາສາ ເພື່ອອ່ານພາສາລາວ ໄທ ອື່ນໆ
// check connection or die
// ເມື່ອ Error ຈະຂຶ້ນສະແດງ ຂໍ້ຄວາມຕ່າງໆ ແຕ່ຖ້າຫາກ Connection ສຳເລັດ ສະບໍ່ມີຂໍ້ຄວາມຫຍັງຂຶ້ນ
if($con->connect_errno){
echo $con->connect_error;
exit;
}
?>
<html>
<head>
<meta charset="utf-8">
<title>Customer</title>
</head>
<body>
<center>
<br/>
<h3> TEST SELECT TABLE Random With OOP </h3>
<br/>
<form name="FrmRandom" id="FrmRandom" method="post">
<?php
if(isset($_POST["Random"])){
$strSQL = " SELECT * FROM user order by RAND() LIMIT 5 ";
$objQuery = $con->query($strSQL);
}
?>
<input type="submit" name="Random" id="Random" value="Random" style="width: 100px; height: 40px ; color: green; margin: 5px 10px 5px 10px; font-size:18px; " >
<table border="1" width="900" cellpadding='0' cellspacing='0'>
<tr>
<th width="61">ID</th>
<th width="207">Name</th>
<th width="100">Email</th>
</tr>
<?php
while($value = $objQuery->fetch_array()) {
?>
<tr>
<td align='center'><?php echo $value["UserID"];?></a></td>
<td align='center'><?php echo $value["UserName"];?></td>
<td align='center'><?php echo $value["Email"];?></td>
</tr>
<?php } ?>
</table>
</form>
<br/>
<h3> TEST SELECT Normal TABLE With OOP </h3>
<br/>
<?php
$strSQL = " SELECT * FROM user ORDER BY UserID ASC";
$objQuery = $con->query($strSQL);
?>
<table border="1" width="900" cellpadding='0' cellspacing='0'>
<tr>
<th width="61">ID</th>
<th width="207">Name</th>
<th width="100">Email</th>
</tr>
<?php
while($value = $objQuery->fetch_array()) {
?>
<tr>
<td align='center'><?php echo $value["UserID"];?></a></td>
<td align='center'><?php echo $value["UserName"];?></td>
<td align='center'><?php echo $value["Email"];?></td>
</tr>
<?php } ?>
</table>
</body>
<?php $con->close(); ?>
</html>
=======================================

Out Put Rand And Normal Select

วันพุธที่ 16 มกราคม พ.ศ. 2562

How to Login PHP By OOP (2)

ຕໍ່ຈາກບົດຄວາມ How to Login PHP By OOP (1) Link Click
ມາເບິ່ງໃນສ່ວນ ໜ້າ Login.php

========================================================
1. login.php
========================================================
<?php
ob_start();
session_start();
?>
<?php
// connect oop mysqli
$localhost = "localhost"; //localhost server ຈຳລອງຜ່ານ web server Xampp,Appserv
$root = "root"; // root ຂອງການຕິດຕັ້ງ ໃນ web server
$pass = "44@44"; // ລະຫັດຜ່ານທີ່ຕິດຕັ້ງໄວ້ ໃນ web server
$db = "mydatabase"; // database ທີ່ຕ້ອງການຈະຕິດຕໍ່
$con= new mysqli($localhost,$root,$pass,$db); // connection
mysqli_query($con,"set names utf8"); // set ພາສາ ເພື່ອອ່ານພາສາລາວ ໄທ ອື່ນໆ
// check connection or die
// ເມື່ອ Error ຈະຂຶ້ນສະແດງ ຂໍ້ຄວາມຕ່າງໆ ແຕ່ຖ້າຫາກ Connection ສຳເລັດ ສະບໍ່ມີຂໍ້ຄວາມຫຍັງຂຶ້ນ
if($con->connect_errno){
echo $con->connect_error;
exit;
}
// end to connection statement
?>

<!DOCTYPE HTML>
<html>
<head>
<title>Login</title>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE-Edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<style type="text/css">
body{
font-family:'Saysettha MX',Phetsarath OT,Saysettha OT,sans-serif;
font-size:12.5px;
src:url(saysettha-web/fonts/saysettha_web.woff);
src:url(saysettha-web/fonts/saysettha_web.eot);
}
@font-face{
font-family:'Saysettha MX',Phetsarath OT,Saysettha OT,sans-serif;
font-size:12.5px;
src:url(saysettha-web/fonts/saysettha_web.woff);
src:url(saysettha-web/fonts/saysettha_web.eot);
}
</style>
<body>
<form action="" name="frm" id="frm" method="post">
<p align="center">
<?php
if(isset($_POST["ok"])){
$username = $_POST["username"];
$username = $con->real_escape_string($username);
$password = $_POST["password"];
$password = $con->real_escape_string($password);

$Login = $con->query(" SELECT * FROM login
WHERE UserName ='".$username."'
AND Pass = '".$password."'
");
$lognum = $Login->num_rows;
$row = $Login->fetch_assoc();
if($lognum > 0){

$_SESSION['ID'] = $row['ID'];
$_SESSION['UserName'] = $row['UserName'];
$_SESSION['Pass'] = $row['Pass'];
$_SESSION['Name'] = $row['Name'];

echo "<span style ='color:#008000';> ";
echo "ຍິນດີຕ້ອນຮັບເຂົ້າສູ່ລະບົບ";
echo "</span>";
echo "<meta http-equiv='refresh' content='1;url=./main.php'>";
echo "</p>";
}else{


echo "<span style ='color:#F08080';> ";
echo "password And Username ບໍ່ຖືກຕ້ອງ";
echo "</span>";
echo "<meta http-equiv='refresh' content='1;url=./login.php'>";

}
}
?>
</p>
<h2 align="center"> From Login </h2>
<table border="1" width="500" cellpadding="1" cellspacing="1" align="center">
<tr>
<td>User Name </td>
<td><input type="text" placeholder="Username" name="username" id="username" required=""></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="password" id="password" required placeholder="Password" ></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="ok" id="ok" value="LOGIN" ></td>
</tr>
</table>
</form>
</body>

</html>
========================================================
2. main.php
========================================================
<?php
ob_start();
session_start();

echo "Test Login to Main.php".'<br>';
echo "======================".'<br>';
echo 'ID Login = '.$_SESSION['ID'].'<br>' ;
echo 'UserName = '.$_SESSION['UserName'].'<br>' ;
echo 'Your Password = '.$_SESSION['Pass'].'<br>' ;
echo 'Your Name = '.$_SESSION['Name'].'<br>' ;
echo "======================";

?>
========================================================

Out Put

main.php (welcome when login success)

How to Login PHP By OOP (1)

ມາເຖິງບົດຄວາມ ການ Login ແບບງ່າຍ ດ້ວຍ PHP By OOP

1. Databases
2. table login
3. login.php
4. main.php

How to Login PHP By OOP (2)
========================================================
1. databases : mydatabase
========================================================
Copy below :

-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 16, 2019 at 11:30 AM
-- Server version: 5.1.37
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `mydatabase`
--

-- --------------------------------------------------------

--
-- Table structure for table `customer`
--

CREATE TABLE IF NOT EXISTS `customer` (
`CustomerID` varchar(50) NOT NULL,
`Name` varchar(50) NOT NULL,
`Email` varchar(50) NOT NULL,
`CountryCode` varchar(50) NOT NULL,
`Budget` varchar(50) NOT NULL,
`Used` varchar(50) NOT NULL,
`bath` int(255) NOT NULL,
PRIMARY KEY (`CustomerID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`CustomerID`, `Name`, `Email`, `CountryCode`, `Budget`, `Used`, `bath`) VALUES
('C001', 'ບົວສະຫວັນ', 'win.weerachai@gmail.com', 'THB', '1', '5', 0),
('C0022', 'John Smith2', 'john.smith@gmail.com2', 'UK', '10', '552', 22),
('C003', 'James Borns', 'jame.born@gmail.com', 'USS', '1000', '5000', 0),
('C005', 'HaraRock', 'HaraRock@gmail.com', 'A5', '200', '12345', 12345),
('C004', 'BEH', 'Beh@gmail.com', 'THB', '100', '55', 55),
('C006', 'KK', 'H@gmail.com', 'LAOS', '1234', '1234', 25);

-- --------------------------------------------------------

--
-- Table structure for table `events`
--

CREATE TABLE IF NOT EXISTS `events` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`title` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`start` date NOT NULL,
`end` date NOT NULL,
`color` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`notify` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `events`
--

-- --------------------------------------------------------

--
-- Table structure for table `login`
--

CREATE TABLE IF NOT EXISTS `login` (
`ID` int(20) NOT NULL AUTO_INCREMENT,
`UserName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`Pass` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`ID`, `UserName`, `Pass`, `Name`) VALUES
(1, 'b', 'b', 'Hararock');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
`UserID` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
`UserName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`Email` varchar(50) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`UserID`, `UserName`, `Email`) VALUES
('C001', 'Win', 'win.@gmail.com'),
('C002', 'John', 'john@gmail.com');