Showing posts with label Tutorials. Show all posts
Showing posts with label Tutorials. Show all posts

How to make bootable Windows 7 installer USB Drive Using CMD

Step 1:

Plug-in your USB drive:
  • Make sure all your USB Drive content copy to your harddisk

Step 2:

Open Command Prompt(CMD) as an Administrator 
  1. Go to Start menu
  2. Search for CMD
  3. Right Click then select Run as administrator
Search for CMD

Run as administrator

PHP simple login system with session

Step 1 : Create database

You should already create database name. then create table name Users
You can create from phpmysql or other tools.

Sql Code
CREATE TABLE `users` (
  `ID` int(2) NOT NULL AUTO_INCREMENT,
  `Fullname` varchar(32) NOT NULL,
  `Username` varchar(32) NOT NULL,
  `Password` varchar(32) NOT NULL,
  PRIMARY KEY (`ID`)
)

Step 2 :  Create php file 

Create file name database.php, login.php  and login_success.php on your directory


Step 3 :  php code database connection

database.php
<?php
$dbhost = "localhost"; 
$dbuser = "root"; //your username database
$dbpass = ""; //Your password database
$dbname = "test"; //Your database name

$dblink = mysql_connect($dbhost,$dbuser,$dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
?>

Step 4 : login code and html form

<?php 
session_start();
include("database.php");
if(isset($_POST['login'])){
 $username = $_POST['username'];
 $password = $_POST['password'];
 if(!empty($username) && !empty($password)){ //Username and password must filled
  $sql_login ="SELECT `ID`, `Fullname`, `Username`, `Password` FROM `users` WHERE `Username`='".$username."' AND `Password`='".$password."'";
  $result = mysql_query($sql_login,$dblink);//execute the sql command
  $rows = mysql_fetch_assoc($result);
  
  if($rows['Username'] == $username && $rows['Password'] == $password){ 
   $_SESSION['fullname'] = $rows['Fullname'];
   header('Location: login_success.php');
  }else{ //Wrong username or password
   echo "<script>alert('invalid username or password please try again')</script>";
  }
  mysql_close();
 }else{
  echo "<font color=\"red\">Username and Password field are required</font>";
 }
}
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Login</title>
</head>
<body>
<div style="width:350px;margin:0 auto;background-color:#0099FF;margin-top:50px;padding:5px;border:1px solid #666">
  <h2>Login</h2>
  <center>
  <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post">
    <p>Username
      <input type="text" name="username" maxlength="32" />
    </p>
    <p>Password
      <input type="password" name="password" maxlength="32" />
    </p>
    <p><input type="submit" name="login" value="LOGIN" /></p>
  </form>
  </center>
</div>
</body>
</html>

Step 5 : login_success.php and logout.php code

login_success.php
now create new file name logout.php
logout.php code

Finish now its time to test

before that you need to insert user on your database.
for example
Login form

login successful

Get identity or autonumber after Insert Query


Example Code for creating invoice
 




Private Sub CreateInvoiceQuery()
        Dim InsertCom = Me.InvoiceDataAdapterX.Adapter.InsertCommand
        If invoice_id = Nothing Then
            InsertCom.CommandText = "INSERT INTO `invoice` (`date_created`, `customerid`) VALUES (?, ?)"

            InsertCom.Parameters(0).Value = CType(Me.DateTimePicker1.Value, Date)
            InsertCom.Parameters(1).Value = 1
            InsertCom.Connection.Open()
            InsertCom.ExecuteNonQuery()
            InsertCom.CommandText = "SELECT @@IDENTITY"
            invoice_id = InsertCom.ExecuteScalar
            NoInvoiceTextBox.Text = invoice_id.ToString("D6")
            InsertCom.Connection.Close()
            InsertCom.Dispose()
        End If
        Debug.WriteLine(invoice_id.ToString)
    End Sub