Learning PHP and MySQL
Monday, August 07, 2006
Example 06-10 Using extract with the EXTR_PREFIX_ALL directive
<?php
$Apple="Computer";
$shapes=array('SodaCan' => 'Cylinder',
'NotePad' => 'Rectangle',
'Apple' => 'Sphere',
'Orange' => 'Sphere',
'PhoneBook' => 'Rectangle');
extract($shapes,EXTR_PREFIX_ALL,"shapes");
// $shapes_SodaCan, $shapes_NotePad, $shapes_Apple, $shapes_Orange, and
//$shapes_PhoneBook are now set
echo "Apple is $Apple.<br>";
echo "Shapes_Apple is $shapes_Apple";
echo "<br>";
echo "Shapes_NotePad is $shapes_NotePad";
?>
Example 06-11 Using EXTR_PREFIX_ALL on a numeric array
<?php
$shapes=array( 'Cylinder','Rectangle');
extract($shapes,EXTR_PREFIX_ALL,"shapes");
echo "Shapes_0 is $shapes_0 <br>";
echo "Shapes_1 is $shapes_1";
?>
Posted by krautgrrl on 08/07 at 10:25 AM
Chapter 6 Code • (0) Comments • (98) Trackbacks • Permalink
Chapter 6 Code • (0) Comments • (98) Trackbacks • Permalink
Friday, August 18, 2006
Example 07-01 Creating the books and authors tables
CREATE TABLE books ( title_id INT NOT NULL AUTO_INCREMENT,
title VARCHAR (150),
pages INT,
PRIMARY KEY (title_id));
CREATE TABLE authors ( author_id INT NOT NULL AUTO_INCREMENT,
title_id INT NOT NULL,
author VARCHAR (125),
PRIMARY KEY (author_id));
Posted by krautgrrl on 08/18 at 10:40 AM
Chapter 7 Code • (0) Comments • (27) Trackbacks • Permalink
Chapter 7 Code • (0) Comments • (27) Trackbacks • Permalink
Example 07-02 The SQL to create and populate a purchases table that links user_ids and title_ids
This code is for:
The SQL to create and populate a purchases table that links user_ids and title_ids to a purchase_id
CREATE TABLE `purchases` ( purchase_id int(11) NOT NULL auto_increment,
user_id varchar(10) NOT NULL,
title_id int(11) NOT NULL,
purchased timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (purchase_id));
INSERT INTO `purchases` VALUES (1, 'mdavis', 2, '2005-11-26 17:04:29');
INSERT INTO `purchases` VALUES (2, 'mdavis', 1, '2005-11-26 17:05:58');
Posted by krautgrrl on 08/18 at 10:41 AM
Chapter 7 Code • (5) Comments • (391) Trackbacks • Permalink
Chapter 7 Code • (5) Comments • (391) Trackbacks • Permalink
Monday, August 07, 2006
Example 08-01 The contents of the my_backup.sql file
-- MySQL dump 10.9
--
-- Host: localhost Database: test
-- ------------------------------------------------------
-- Server version 4.1.11-Debian_4-log
--
-- Table structure for table `authors`
--
DROP TABLE IF EXISTS `authors`;
CREATE TABLE `authors` ( `author_id` int(11) NOT NULL auto_increment,
`title_id` int(11) NOT NULL default '0',
`author` varchar(125) default NULL, PRIMARY KEY (`author_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `authors`
--
/*!40000 ALTER TABLE `authors` DISABLE KEYS */; LOCK TABLES `authors` WRITE;
INSERT INTO `authors` VALUES (1,1,'Ellen Siever'),(2,1,'Aaron Weber'),(3,2,'Arno ld Robbins'),(4,2,'Nelson Beebe');
UNLOCK TABLES;
/*!40000 ALTER TABLE `authors` ENABLE KEYS */;
Posted by krautgrrl on 08/07 at 05:10 PM
Chapter 8 Code • (3) Comments • (256) Trackbacks • Permalink
Chapter 8 Code • (3) Comments • (256) Trackbacks • Permalink
Example 08-02 Book titles in CSV format
1,Linux in a Nutshell,476
2,Classic Shell Scripting,256
Example 08-03 Creating a simple index
CREATE UNIQUE INDEX `authind` ON `authors` (`author`);
Example 08-04 Using CONCAT to put fields together
SELECT CONCAT(`title`,' has ',`pages`,' pages.') FROM `books`;
Example 08-05 Calculating the length of a string
SELECT CONCAT(`title`,' has ', LENGTH(`title`), ' characters.') FROM `books`;
Example 08-06 Changing the case of the title
SELECT UCASE(`title`), LCASE(`title`) from `books`;
Example 08-07 Using the LEADING option to remove zeros
SELECT TRIM(LEADING '0' from '0000Example00000');
Example 08-08 Using TRIM with the TRAILING option
SELECT TRIM(TRAILING '0' from '0000Example00000');
Example 08-09 Looking for the string in our author names
SELECT LOCATE`author`,LOCATE('on',`author`) FROM `authors`;
Example 08-10 Adding the formatting to a phone number using LEFT, RIGHT, and SUBSTR
SELECT CONCAT('(', LEFT('6128238193',3),
')', SUBSTR('6128238193',4,3),
'-',
RIGHT('6128238193', 4));
Posted by krautgrrl on 08/07 at 05:15 PM
Chapter 8 Code • (26) Comments • (1) Trackbacks • Permalink
Chapter 8 Code • (26) Comments • (1) Trackbacks • Permalink
Example 08-11 Using WEEKDAY to get the day of the week
SELECT WEEKDAY('1964-10-12');
Statistics
This page has been viewed 375167 times
Page rendered in 0.2857 seconds
Total Entries: 224
Total Comments: 16
Total Trackbacks: 307338
Most Recent Entry: 09/27/2006 12:39 pm
Most Recent Comment on: 10/26/2007 10:00 am
Total Members: 2
Total Logged in members: 0
Total guests: 8
Total anonymous users: 0
Most Recent Visitor on: 02/10/2012 09:08 am
The most visitors ever was 1103 on 11/20/2007 12:50 pm
