PHP: mysql_insert_id()

July 16, 2009 by  
Filed under Tips and Tutorials

tn-phpSometimes it is necessary to get the ID value of the last record you inserted into a MySQL database.

For example, let’s say you have a shopping cart function that added records into the database. But you need to print out a receipt that includes the item tracking number. And this tracking number would be the record’s ID value, which is also the PRIMARY KEY of the table.

An easy way to do this in PHP is by using the function mysql_insert_id().
NOTE: This will only work for AUTO_INCREMENT fields.

Pretend STEP 1 is a form with a list of items. If you change the QUANTITY of the item, and submit, you will be at STEP 2, which is the sample code below.
Read more

Related Products:

Code Girls: The Untold Story of the American Women Code Breakers of World War IICode Girls: The Untold Story of the American Women Code Breakers of World War II"Code Girls reveals a hidden army of female cryptographers, whose work played a crucial role in ending World War II.... Mundy has rescued a piece of f... Read More >
Bluetooth Speakers,URPOWER Hi-Fi Portable Wireless Stereo Speaker with 7 LED Visual Modes and Build-in Microphone Support Hands-free Function, for iPhone 7 Plus,7,Samsung,Tablets and More-Z3Bluetooth Speakers,URPOWER Hi-Fi Portable Wireless Stereo Speaker with 7 LED Visual Modes and Build-in Microphone Support Hands-free Function, for iPhone 7 Plus,7,Samsung,Tablets and More-Z3URPOWER-Z3 Bluetooth Speaker

The URPOWER-Z3 Bluetooth speaker offers great quality sound with Bluetooth 3.0 technology. With the ultra-compac... Read More >
The Code of Trust: An American Counterintelligence Expert's Five Rules to Lead and SucceedThe Code of Trust: An American Counterintelligence Expert's Five Rules to Lead and Succeed

A counterintelligence expert shows readers how to use trust to achieve anything in business and in life.

Robin Dreeke is a 28-year veteran of... Read More >

if $IE

July 11, 2009 by  
Filed under Geek Fun & Humor, PHP

I was working on a web project and I usually start with Firefox to test things. Then Safari, Chrome, and then IE. By the time I got to IE, I noticed that my hard work was just not viewable. Argh. So I tweeted out:

tweet-browsercheck

function browserCh() 
{ 
     $a = $_SERVER['HTTP_USER_AGENT']; 
     $IE = ((eregi("MSIE",$a) || eregi("Microsoft",$a)))==1; 

     if($IE) 
        return 'Bad Browser!';
}

I got a laugh at some of the responses.. :)

@honging : daynah, i prefer: <style type="text/css">* html body { display: none; }</style> ;)

@j_holtslander: @daynah that was kinda hot. LOL.

@robflynn43: @daynah Haha, browserCh() made me happy. You win a high five, redeemable any time you see me. =)

@ialexs@daynah :D (re: bad browser)

Related Products:

The 50 Funniest American Writers: According to Andy BorowitzThe 50 Funniest American Writers: According to Andy BorowitzEver wondered who makes a very funny person laugh? Wonder no more. Brought together in this Library of America collection are America’s fifty funnie... Read More >
PHP for Beginners: Your Guide to Easily Learn PHP In 7 DaysPHP for Beginners: Your Guide to Easily Learn PHP In 7 Days Are You Ready To Learn PHP Easily? This book contains the steps, strategies, and concepts you need to learn PHP – an extremely popular scripting l... Read More >
The Humor Code: A Global Search for What Makes Things FunnyThe Humor Code: A Global Search for What Makes Things FunnyPart road-trip comedy and part social science experiment, a scientist and a journalist “shed fascinating light on what makes us laugh and why” (Ne... Read More >

iPhone App Review: PHP Ref

October 16, 2008 by  
Filed under Apple, Reviews

PHP RefName: PHP Ref
Written By: Joseph Frizalone
Category: Utilities
Price: $.99
Size: 1.3 MB
Requirements: iPhone / iPod Touch

This is a great app for any PHP developer. It’s a quick reference to all 5149 standard PHP functions. You can search for a function or scroll through a list of them. Tap on the function and a description of its purpose and parameters will be displayed. The only improvement I would like is an example of how the function can be used. Other than that, it’s pretty nice.

PHP Ref PHP Ref PHP Ref

Related Products:

Apple iPhone 6 16 GB Unlocked, Space Gray (Certified Refurbished)Apple iPhone 6 16 GB Unlocked, Space Gray (Certified Refurbished)What's in the box: Certified Refurbished iPhone 6 Space Gray 16GB Unlocked , USB Cable/Adapter. Comes in a Generic Box with a 1 Year Limited Warranty.
Apple iPhone 6 Plus 64GB Gold (Factory Unlocked)Apple iPhone 6 Plus 64GB Gold (Factory Unlocked)Apple iPhone 6 Plus Unlocked Cellphone, Gold, 64 GB (Refurbished)

How to Connect to a MySQL Database using PHP

March 29, 2005 by  
Filed under Code Snippets, PHP, Scripts and Coding

I was helping my coworker yesterday to create her first PHP-Database program. She already knew how phpMyAdmin worked, so I created a sample page for her to show how to connect to the database and then retrieve data from a query. Maybe this sample page could help you too. I commented as much of the code as I could. Let me know if you have any questions.

Read more

Related Products:

MySQL Crash CourseMySQL Crash Course

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual cor... Read More >

MySQL Cookbook: Solutions for Database Developers and AdministratorsMySQL Cookbook: Solutions for Database Developers and Administrators

MySQL’s popularity has brought a flood of questions about how to solve specific problems, and that’s where this cookbook is essential. When you... Read More >

The Obesity Code: Unlocking the Secrets of Weight LossThe Obesity Code: Unlocking the Secrets of Weight LossFung zeroes in on why insulin resistance has become so prevalent and offers specific outside-the-box solutions that have emerged as the key to maximiz... Read More >

Random Splash Pages

April 26, 2002 by  
Filed under Code Snippets, PHP

I was looking through my email and found this email from Grace:

Hi Daynah! It’s me, Grace. I would like to ask a question if you don’t mind -_-; Sorry if I am bothering you. I would like to ask if how can I make random splash pages with php? Or do you know any scripts I could download for
that? Thank you so much. And hope you are having a great week =)

Here is a piece of code that Albert (my boyfriend) wrote. It creates an array of random images to use. It’s pretty simple to modify if you want to create random splash pages. If you have comments/questions, please leave them below.

<?php

// Function name: randomimage($showimage)
// Purpose: Create an array with random data for an image
// Use: Please link http://php-princess.net/
function randomimage($showimage)
{

    // ARRAY OF SPLASH IMAGES
    $bgimages = array('images/splash1.jpg','images/splash2.jpg',
                      'images/splash3.jpg','images/splash4.jpg',
                      'images/splash1.jpg','images/splash2.jpg',
                      'images/splash3.jpg','images/splash4.jpg');

    $bgtext = array ('Picture of Splash 1','Picture of Splash 2',
                     'Picture of Splash 3','Picture of Splash 4',
                     'Picture of Splash 1', 'Picture of Splash 2', 
                     'Picture of Splash 3', 'Picture of Splash 4');

    $bgmax = count($bgimages)-1;

    // Check if viewing additional image option is 
    // set / look for non-integer value passing
    if ((!isset($showimage)) || (!ereg ("^[0-9]{1,2}$", $showimage)))
    {
        srand((double)microtime()*1000000);    
        print_r($names);  

        srand ((double) microtime() * 10000000);

        $rand_keys = array_rand ($bgimages, 2);

        // obtain random image from array
        $bgimage = $bgimages[$rand_keys[0]];
        $bgalt   = $bgtext[$rand_keys[0]];
        $bgkey   = $rand_keys[0];
    }    

    return array($bgimage,$bgalt,$bgkey);
}

// Creates a list of the variables with random image 
list($bgimage,$bgalt,$bgkey) = randomimage($showimage);

// Put printout into variable $mainbody
$mainbody = ''.$bgalt.'';

// Print out $mainbody
print "$mainbody";

?>

Related Products:

Code Complete: A Practical Handbook of Software Construction, Second EditionCode Complete: A Practical Handbook of Software Construction, Second Edition

Widely considered one of the best practical guides to programming, Steve McConnell’s original CODE COMPLETE has been helping developers write bet... Read More >

Clean Code: A Handbook of Agile Software CraftsmanshipClean Code: A Handbook of Agile Software CraftsmanshipEven bad code can function. But if code isn’t clean, it can bring a development organization to its knees. Every year, countless hours and significa... Read More >
Code: The Hidden Language of Computer Hardware and SoftwareCode: The Hidden Language of Computer Hardware and Software

What do flashlights, the British invasion, black cats, and seesaws have to do with computers? In CODE, they show us the ingenious ways we manipulat... Read More >