PHP & MySQL

Tuesday, 8 March 2022

PHP#33MySQL#29 - Đếm lượt truy cập (KẾT THÚC KHÓA HỌC)

//hitcounter.php<?phpsession_start(); ?><!doctype html><html><head><meta charset="utf-8"><title>Untitled Document</title></head><body><?php include("../connect.php");//cập nhật số luowhtj truy cập:$sl="update counter set cnt=cnt+1";mysqli_query($link,$sl);//Lấy dữ liệu số lượt truy cập để hiển thị ra web:$sl2="select * from counter";$kq=mysqli_query($link,$sl2);$d=mysqli_fetch_array($kq);//Định dạng:$chuoi=str_pad($d['cnt'],6,"0",STR_PAD_LEFT);$luottrycap="";for($i=0;$i<strlen($chuoi);$i++){ $tam=substr($chuoi,$i,1); $luottrycap.="<img...

Saturday, 5 March 2022

PHP#32MySQL#28 - Ajax3 + EMAIL

//connect.php<?php$link=@mysqli_connect("localhost","root","") or die("Khong the ket noi den server");mysqli_select_db($link,"webtintuc") or die ("Kiem tra lai ten database!");mysqli_query($link,"set names 'utf8'");?&...

Thursday, 3 March 2022

PHP#31MySQL#27 - Ajax2

//checkuser.php<!doctype html><html><head><meta charset="utf-8"><title>Untitled Document</title><script type="text/javascript" src="jquery-3.6.0.js"></script></head><body><script type="text/javascript"> $(document).ready(function(){ $("#username").blur(function(){ $.ajax({ type:"POST", url:"xuly_checkuser.php", ...

PHP#30MySQL#26 - Ajax

...

Thursday, 24 February 2022

PHP#29MySQL#25 - Captcha & Bình chọn

//CAPTCHA: vidu.php<?phpsession_start();//phát sinh 6 ký tự ngẫu nhiên:$dodai=6;$chuoi="QWERTYUIOPASDFGHJKLZXCVBNM0123456789";$capt="";for($i=1;$i<=$dodai;$i++){ $vitri=rand(0,35); $capt.=substr($chuoi,$vitri,1);}$_SESSION['captcha']=$capt;?><!doctype html><html><head><meta charset="utf-8"><title>Untitled Document</title></head><body><form action="xuly.php" name="form1"id="form1" method="post"> <p> <label for="textfield">Ho Ten:</label> ...

PHP#28MySQL#24 - GIỎ HÀNG 3 (xong)

//datbao.php<?phpsession_start();if(!isset($_SESSION['giohang'])) $_SESSION['giohang']=array();?><!doctype html><html><head><meta charset="utf-8"><title>Untitled Document</title></head><body><form id="f" name="form1" method="post" action="xuly.php"> <p>Đăng Ký Đặt Báo <p> <label for="loaibao">Loại báo:</label> <select name="loaibao" id="loaibao"> <?php include("connect.php"); $sql="select...

Saturday, 19 February 2022

PHP#27MySQL#23 - GIỎ HÀNG 1+2

PHẦN 2: //datbao.php<?phpsession_start();if(!isset($_SESSION['giohang'])) $_SESSION['giohang']=array();?><!doctype html><html><head><meta charset="utf-8"><title>Untitled Document</title></head><body><form id="f" name="form1" method="post" action="xuly.php"> <p>Đăng Ký Đặt Báo <p> <label for="loaibao">Loại báo:</label> <select name="loaibao" id="loaibao"> <?php include("connect.php"); $sql="select...

Thursday, 17 February 2022

PHP#26MySQL#22 - Hướng đối tượng Phần 3+4

//lib.php<?phpclass tintuc{ private $link; //chứa mã kết nối //kết nối: function connect($host, $user, $pass, $db) { $this->link=@mysqli_connect($host,$user,$pass) or die("Không thể kết nối đến Server!"); mysqli_select_db($this->link,$db) or die("Không tồn tại DB này!"); mysqli_query($this->link,"set names 'utf8'"); } //Xây dựng hàm query: function query($sl) { $kq=mysqli_query($this->link,$sl) or die(mysqli_error()); return $kq; } //Xây dựng hàm fetch: function fetch($kq) { $d=mysqli_fetch_array($kq); return $d; } //Hàm...

Wednesday, 16 February 2022

PHP#25MySQL#21 - Hướng đối tượng Phần 1 - Xây dựng Hàm - Tin theo Loại - Class

<!doctype html><html><head><meta charset="utf-8"><title>Untitled Document</title></head><body><?php include("../connect.php");//Xây dựng hàm: hàm nhận tham số đầu vào là id của 1 loại và hàm trả về danh sách các tiêu đề tin thuộc loại tin đó: function tin_loai($idLT) { global $link; //biến toàn cục $sl="select * from tin where idLT=$idLT"; $kq=mysqli_query($link,$sl); while($d=mysqli_fetch_array($kq)) { echo $d['TieuDe']."<br/>"; } } echo "Các tin của loại tin có id=1:...

PHP#25MySQL#21 - Hướng đối tượng Phần 1 - Xây dựng Hàm

<!doctype html><html><head><meta charset="utf-8"><title>Untitled Document</title></head><body><?php /*//Xây dựng hàm: function ten_ham(các_tham_số) { //Thân hàm: chứa các lệnh return giá trị; //có thể có hoặc không }*/ //Hàm không có return: function tinhtong($ts1, $ts2) { $tam=$ts1+$ts2; echo "Kết quả là: $tam <br/>"; } //Gọi hàm: tinhtong(15,7); tinhtong(23,48); //Hàm có return: function tinhtong2($ts1, $ts2) { $tam=$ts1+$ts2; return $tam; } //Gọi hàm : Đối với dạng có...

Monday, 14 February 2022

PHP#24MySQL#20 Cookie, Xử lý, Ý kiến bạn đọc, bình luận

...

Saturday, 12 February 2022

PHP#23MySQL#19 - Đăng nhập, Session, Thoát user, Xử lý

...

Saturday, 22 January 2022

PHP#22MySQL#18 - Xóa, Sửa TIN & admin index (thể loại, loại tin)

//tin.php<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Untitled Document</title></head><body><?php if(isset($_GET['lang'])) $lang=$_GET['lang']; else $lang="vi"; ?><form id="form1" name="form1" method="get" action=""> <p> <label for="lang">Ngon ngu:</label> ...

Thursday, 20 January 2022

PHP#21MySQL#17 - Upload, Xử lý, Thư viện, chèn Ckeditor

//upload.php<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta charset="utf-8" /><title>Untitled Document</title> <script type="text/javascript" src="ckeditor/ckeditor.js"></script></head><body><form action="process.php" method="post" enctype="multipart/form-data" name="form1" id="form1"> <p> <label for="upImg">Chon anh:</label> ...

PHP#21MySQL#17 - tin_them.php, process.php - Thêm tin mới, Xử lý tin mới

//tin_them.php<!doctype html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <script type="text/javascript" src="ckeditor/ckeditor.js"></script> </head> <body> <?php include("../connect.php"); if(isset($_GET['lang'])) $lang=$_GET['lang']; else $lang='vi'; ?> <form id="form1" name="form1" method="get" action=""> <p> <label for="lang">Ngon ngu:</label> <select name="lang"...

Tuesday, 18 January 2022

PHP#20MySQL#16 - upfiles.php

<!doctype html><html><head><meta charset="utf-8"><title>Untitled Document</title></head><body><form method="post" enctype="multipart/form-data" name="form1" id="form1"> <input type="hidden" name="MAX_FILE_SIZE" value="102400"/> <label for="upfile">File:</label> <input type="file" name="upfile" id="upfile"> <input type="submit" name="submit" id="submit" value="Submit"></form><?phpif(isset($_FILES['upfile'])){ //Thư mục để chứa...

PHP#20MySQL#16 - tin.php : Lọc tin theo Ngôn ngữ, Thể loại, Loại & Phân trang

//tin.php <!doctype html><html><head><meta charset="utf-8"><title>Untitled Document</title><style> .ht{ font-weight: bold; color:#E80206; font-size:20px;}</style></head><body><?php include("../connect.php"); if(isset($_GET['lang'])) $lang=$_GET['lang']; else $lang="vi";?><form method="get" id="form1" name="form1" action=""> <p> <label for="idTL">Ngôn ngữ:</label> <select name="lang" id="lang" onChange="form1.submit();"> ...

PHP#20MySQL#16 - Xóa LOẠI TIN

//loaitin.php (phần Xóa)<!doctype html><html><head><meta charset="utf-8"><title>Loại Tin</title></head><body><?php include("../connect.php"); if(isset($_GET['lang'])) $lang=$_GET['lang']; else $lang="vi";?><form method="get" id="form1" name="form1"> <p> <label for="loaitin">Chọn ngôn ngữ:</label> <select name="lang" id="lang" onChange="form1.submit();"> <option value="vi">Việt</option> ...

Saturday, 15 January 2022

PHP#19MySQL#15 - Loại tin, Thêm, Sửa, Xử lý

//connect.php<?php $link=@mysqli_connect("localhost","root","") or die("Không tìm thấy Sever"); mysqli_select_db($link,"tintuc") or die("Không tồn tại DB"); mysqli_query($link,"set names 'utf8'"); ?&...

Thursday, 13 January 2022

PHP#18MySQL#14 - Thêm, Xóa, Sửa, Lọc theo ngôn ngữ, lọc theo thể loại, loại

//theloai.php<!doctype html><html><head><meta charset="utf-8"><title>Thể Loại</title></head><body><?php include("../connect.php"); if(isset($_GET['lang'])) $lang=$_GET['lang']; else $lang="vi";?><form method="get" id="form1" name="form1"> <p> <label for="select">Chọn ngôn ngữ:</label> <select name="lang" id="lang" onChange="form1.submit();"> <option value="vi">Việt</option> ...

Wednesday, 12 January 2022

PHP#17MySQL#13 - Trang xử lý THÊM dữ liệu (process.php) - Chuyển trang trong PHP: header("location:theloai.php");

<?php include("../connect.php"); if(isset($_POST['themtl'])) { $sl="insert into theloai values(NULL,'{$_POST['lang']}', '{$_POST['TenTL']}', '{$_POST['TenTL_KhongDau']}', {$_POST['ThuTu']}, {$_POST['AnHien']})"; if(mysqli_query($link,$sl)) header("location:theloai.php"); else echo $sl; }?&...

PHP#17MySQL#13 - Admin/theloai_them.php - $_GET['lang']) sau đó selected ngôn ngữ

<!doctype html><html><head><meta charset="utf-8"><title>Untitled Document</title></head><body><?php if(isset($_GET['lang'])) $lang=$_GET['lang']; else $lang="vi";?><form method="post" id="form1" name="form1" action="process.php"> <p> <label for="lang">Ngôn ngữ:</label> <select name="lang" id="lang"> <option value="vi">Việt</option> <option value="en"<?php if($lang=="en")...

PHP#17MySQL#13 - Admin/theloai.php - Lọc thể loại theo ngôn ngữ, selected ngôn ngữ, chuyển trang kèm theo ngôn ngữ

<!doctype html><html><head><meta charset="utf-8"><title>Thể Loại</title></head><body><p><?php if(isset($_GET['lang'])) $lang=$_GET['lang']; else $lang="vi";?> <form id="form1" name="form1" method="get" action=""> <label for="lang">Chọn ngôn ngữ:</label> <select name="lang" id="lang" onChange="form1.submit();"> <option value="vi">Việt</option> <option value="en"<?php if($lang=="en") echo "selected";?>>English</option> ...

Tuesday, 11 January 2022

PHP#17MySQL#13 - tin cũ hơn

//chitiettin.php<!doctype html><html><head><meta charset="utf-8"><title>Untitled Document</title></head><body><?php if(isset($_GET['idTin'])) { $idTin=$_GET['idTin']; include("connect.php"); $sl="select idLT, TieuDe, TomTat, Content from tin where idTin=$idTin"; $kq=mysqli_query($link,$sl); $d=mysqli_fetch_array($kq)?><h1 align="center"><?php echo $d['TieuDe'];?></h1><div><?php echo $d['TomTat'];?></div><div><?php echo $d['Content'];?></div><?php...

Saturday, 8 January 2022

PHP#16MySQL#12 - index.php, include

https://app.mediafire.com/fwx971t2bbggr //index.php<!doctype html><html><head><meta charset="utf-8"><title>Untitled Document</title><link href="c2.css" rel="stylesheet" type="text/css"></head><body><div id="container"> <div id="header"> </div> <div id="thanhmenu"><?php include("menu.php");?></div> <div id="main1"> <div id="main1_1"><?php include("tinnoibat.php");?></div> <div id="main1_2"><?php...

Thursday, 6 January 2022

PHP#15MySQL#11 chèn link, rót dữ liệu, phân trang

//tinmoi.php<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <style type="text/css"> #tinmoi {width: 660px;} #tinmoi .tinmoinhat { width:330px; float:left; color:#336699; height: 175px; overflow: hidden; } #tinmoi .tinmoitieptheo { float:left; width:329px; height: 175px; overflow:...

Tuesday, 4 January 2022

PHP#14MySQL#10 - Slider (Chính thức làm web)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" dir="ltr"> <head profile="http://gmpg.org/xfn/11"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Featured Content Slider Using jQuery - Web Developer Plus Demos</title> <link rel="stylesheet" type="text/css" href="style.css" /> <script type="text/javascript" src="jquery.min.js" ></script> <script...

PHP#14MySQL#10 - tintuc.sql - Menu (Chính thức làm web tin tức) tinxemnhieu.php , tinnoibat.php, tinmoi.php

//tinxemnhieu.php<style type="text/css"> <!-- #tinxemnhieu { width: 250px; border: 1px solid #0099CC; overflow: hidden; white-space: nowrap; } #tinxemnhieu h4 { background-color: #0099CC; margin-top: 0px; margin-bottom: 0px; padding-top: 5px; padding-bottom: 5px; padding-left: 10px; color: #FFFF00; } #tinxemnhieu a { color: #CC3399; text-decoration: none; } #tinxemnhieu a:hover { color: #FFCC00; } #tinxemnhieu p { margin-top: 0px; margin-bottom: -1px; background-color: #FFFFCC; padding-top: 5px; padding-bottom: 5px; padding-left:...

Thursday, 30 December 2021

PHP#13MySQL#9 - TabsMenu

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="60" colspan="3"> </td> </tr> <tr> <td colspan="3" bgcolor="#FF9933"> ...