Monday, March 2, 2015
PHP MySQL HTML Code: Create database & Create Table, Add, edit Search...
PHP MySQL HTML Code: Create database & Create Table, Add, edit Search...: create database DBname; CREATE TABLE people (name VARCHAR(30), age INTEGER, height FLOAT, date DATETIME); INSERT INTO people VALUES (...
Create database & Create Table, Add, edit Search Delete in MySQL
create database DBname;
CREATE TABLE people (name VARCHAR(30), age INTEGER, height FLOAT, date DATETIME);
INSERT INTO people VALUES ( "Jim", 45, 1.75, "2006-02-02 15:35:00" ), ( "Peggy", 6, 1.12, "2006-03-02 16:21:00" )
UPDATE people SET age = 7, date = "2006-06-02 16:21:00", height = 1.22 WHERE name = "Peggy"
SELECT name FROM people WHERE age < 12
DELETE FROM people WHERE age < 12
Labels:
Add,
Create database,
CREATE TABLE,
edit Search Delete,
MySQL
Friday, February 6, 2015
Open a Connection to MySQL
<?php
$servername = "localhost";
$username = "username";
$password = "password";
// Create connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>
$servername = "localhost";
$username = "username";
$password = "password";
// Create connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>
Thursday, January 29, 2015
HTML Comment
<!--This is a comment. Comments are not displayed in the browser-->
<p>This is a paragraph.</p>
<p>This is a paragraph.</p>
Wednesday, January 21, 2015
PHP with HTML
<html>
<title>HTML with PHP</title>
<body>
<h1>My Example</h1>
<?php //your php code here ?>
<b>Here is some more HTML</b>
<?php //more php code ?>
</body>
</html>
_________________________________________________________________
<?php Echo "<html>";
Echo "<title>HTML with PHP</title>";
Echo "<b>My Example</b>";
//your php code here
Print "<i>Print works too!</i>"; ?>
PHP Sessions
A session is a way to store information (in the form of variables) to be used across multiple pages. Unlike a cookie, specific variable information is not stored on the users computer. It is also unlike other variables in the sense that we are not passing them individually to each new page, but instead retrieving them from the session we open at beginning of each page.
Call this code mypage.php
<?php // this starts the session session_start();
// this sets variables in the session
$_SESSION['color']='red';
$_SESSION['size']='small';
$_SESSION['shape']='round';
print "Done"; ?>
Now we are going to make a second page. We again will start with session_start() (we need this on every page) - and we will access the session information we set on our first page. Notice we aren't passing any variables, they are all stored in the session.
Call this code mypage2.php
<?php // this starts the session session_start();
// echo variable from the session,
we set this on our other page
echo
"Our color value is ".$_SESSION['color'];
echo "Our size value is ".$_SESSION['size'];
echo "Our shape value is ".$_SESSION['shape']; ?>
All of the values are stored in the $_SESSION array, which we access here. Another way to show this is to simply run this code:
<?php session_start(); Print_r ($_SESSION); ?>
Modify or Remove a Session
<?php
// you have to open the session to be able to modify or remove it session_start();
// to change a variable, just overwrite it
$_SESSION['size']='large';
//you can remove a single variable in the session unset($_SESSION['shape']);
// or this would remove all the variables in the session, but not the session itself
session_unset();
// this would destroy the session variables
session_destroy(); ?>
Subscribe to:
Posts (Atom)