Bagaimana untuk tengok gambar yg suda diupload?
pertama pergi ke www.google.com SIGN IN akaun google anda
Kemudian Klik More dan Klik Photos
Anda juga boleh padam gambar-gambar yang diupload dalam blogger
Blog About Anythings.
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`) )
<?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()); ?>
<?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>
<?php session_start(); ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Login Successful</title> </head> <body> <h2>Login Successful</h2> <p>Hello <b><?php echo $_SESSION["fullname"] ?></b> <a href="logout.php">[LOGOUT]</a></p> </body> </html>
<?php session_start(); session_destroy(); header('Location: login.php'); #redirect to login page ?>
Private Sub CreateInvoiceQuery()
Dim InsertCom = Me.InvoiceDataAdapterX.Adapter.InsertCommand
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()
Debug.WriteLine(invoice_id.ToString)
End Sub
HarryD Blog © 2013. All Rights Reserved |