Comments by Member 10390715 (Top 78 by date)

Here is my code:
<pre lang="PHP">
0)
{
//echo "Error: ". $_FILES["file"]["error"]."<br />";
//exit;
}
//neu dung upload
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],"nhan_vien/".$_FILES["file"]["name"]);
$luutru = "Lưu trữ tại: "."nhan_vien/".$_FILES["file"]["name"];
$Hinh = $_FILES["file"]["name"];
}
$sql = "INSERT INTO tt_nhanvien VALUES ( '$Card_ID','$Ma_nv','$Ten', '$Phong_ban', '$Chuc_vu','$Hinh')";
$result = mysql_query($sql,$db);
if($result)
{
echo "<p align='center'> Thêm thông tin thành công!</p>";
// nếu thêm thông tin thành công thì in ra thông tin chi tiết
$sql= "SELECT * FROM tt_nhanvien WHERE Ten LIKE '$Ten'"; // chỉ chọn đúng tên laptop request
$result = mysql_query($sql);
//xuat dữ liệu
if(mysql_num_rows($result)<>0)
{
echo "<table width='800' border='1' align='center'cellpadding='0' cellspacing='0' border='1' style='border-collapse:collapse #FF6600'>";
while($row = mysql_fetch_row($result))
{
$Card_ID= $row[0];
$Ma_nv = $row[1];
$Ten = $row[2];
$Phong_ban = $row[3];
$Chuc_vu = $row[4];
$Hinh = "nhan_vien/".$row[5];
$Hinh = "<img src ='$Hinh' alt='$Ten'>";
echo "<tr><td align='center' colspan='2' bgcolor='#FFEEE6' >$Ten</td></tr>";

echo"<tr>";
echo"<td align='center' valign='middle'>$Hinh</td>";
echo "<td>";
echo "<table align='center'";
echo "<td> Card ID:$Card_ID</td></tr>";
echo "<tr><td> Mã nhân viên:$Ma_nv</td></tr>";
echo "<tr><td> Tên:$Ten</td></tr>";
echo "<tr><td> Phòng ban:$Phong_ban</td></tr>";
echo "<tr><td> Chức vụ:$Chức vụ</td></tr>";
echo "</table>";
echo "</td>";
echo "<tr align='right'><td> Quay về trang menu</td></tr>";
echo "</tr>";
}
echo "</table>";
}
}
}
else
{
echo "<p align='center'>MỜI BẠN NHẬP THÔNG TIN!</p>";
echo "<p align='center'><td> Quay về trang menu</td></tr>";
}

?>
</pre>

Now, I not really too necessary. Because, earlier I can't convert binary become image and I try to copy image to /www/ folder automatic.
I can write code upload to server, but in the same PC.If you know, I willing to learn. Thanks

I have 2 subroutine:
def connect_remote():
try:
db=MySQLdb.connect("192.168.137.1","root_a","","luan_van")
return 1
except MySQLdb.OperationalError, e:
if e[0] ==2003:
return 0 #this code uses to check connection alive

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;
using System.IO.Ports;
using System.Threading.Tasks;
using System.Media;

using Emgu.CV;
using Emgu.CV.Structure;
using Emgu.CV.UI;
using Emgu.CV.CvEnum;
using Emgu.CV.GPU;

namespace GUI
{
public partial class Form2 : Form
{
//frmchinh frm_chinh;
int intlen = 0;// timer 1
int[] khoa = new int[50];//RFID
int i = 0;// RFID
private Capture capture; //takes images from camera as image frames
private bool captureInProgress;
private bool flat = true; // rfid
public Form2()
{
InitializeComponent();
load_table();//load table tự động
timer1.Start();
open_camera();
Application.Idle += send_always;// goi event lien tuc
}

private void btn_save_Click(object sender, EventArgs e)
{
try
{

//chụp ảnh bằng webcam
capture_anh();
// chuyển ảnh thành byte
byte[] imageBt = null;

FileStream fstream = new FileStream("E:\\DAMH2.jpg", FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fstream);
imageBt = br.ReadBytes((int)fstream.Length);

txt_datevao.Text = dateTimePicker1.Value.ToString();

// kết nối cơ sở dữ liệu

string constring = "Data Source=DELL-PC;Initial Catalog=GUI ;Integrated Security=True";
string Query = "insert into tbl_thongtin(CardID,BienSoXe,ThoiGianVao,Image) values(' " + this.txt_ID.Text + " ',' " + this.txt_soxe.Text + " ',@date,@image);";


SqlConnection conDataBase = new SqlConnection(constring);
SqlCommand cmdDataBase = new SqlCommand(Query, conDataBase);
SqlDataReader myReader;
cmdDataBase.Parameters.AddWithValue("@date", DateTime.Now);
cmdDataBase.Parameters.AddWithValue("@image", imageBt);




try
{
conDataBase.Open();
myReader = cmdDataBase.ExecuteReader();
MessageBox.Show("SAVE");
while (myReader.Read())
{
}

}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
load_table();
show_data(txt_ID.Text);


}
catch
{
MessageBox.Show("KHÔNG PHÁT HIỆN BIỂN SỐ");
}



}

private void btn_delete_Click(object sender, EventArgs e)
{
string constring = "Data Source=DELL-PC;Initial Catalog=GUI;Integrated Security=True";
string Query = "delete from tbl_thongtin where CardID=' " + this.txt_ID.Text + " ';";
SqlConnection conDataBase = new SqlConnection(constring);
SqlCommand cmdDataBase = new SqlCommand(Query, conDataBase);
SqlDataReader myReader;
try
{
conDataBase.Open();
myReader = cmdDataBase.ExecuteReader();
MessageBox.Show("DELETE");
while (myReader.Read())
{

}

}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
load_table();
txt_ID.Text = "";
}

private void btn_update_Click(object sender, EventArgs e)
{
byte[] imageBt = null;
FileStream fstream = new FileStream("E:\\DAMH2.jpg", FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryRea