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:

The Joy of PHP: A Beginner's Guide to Programming Interactive Web Applications with PHP and mySQLThe Joy of PHP: A Beginner's Guide to Programming Interactive Web Applications with PHP and mySQLThird Edition now with bonus chapters. Have you ever wanted to design your own website or browser application but thought it would be too difficult o... Read More >
The Code of the Extraordinary Mind: 10 Unconventional Laws to Redefine Your Life and Succeed On Your Own TermsThe Code of the Extraordinary Mind: 10 Unconventional Laws to Redefine Your Life and Succeed On Your Own Terms

* New York Times Bestseller
* USA Today Bestseller
* Audible Top Ten Non-Fiction Audiobooks

What if everything we think we know about h... Read More >

Modern PHP: New Features and Good PracticesModern PHP: New Features and Good Practices

PHP is experiencing a renaissance, though it may be difficult to tell with all of the outdated PHP tutorials online. With this practical guide, you... 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:

Humor in UniformHumor in UniformThis side-splitting collection of humor delivers hundreds of the best jokes, anecdotes, cartoons, quotes, and stories from men and women in the armed ... Read More >
The Joy of PHP: A Beginner's Guide to Programming Interactive Web Applications with PHP and mySQLThe Joy of PHP: A Beginner's Guide to Programming Interactive Web Applications with PHP and mySQLThird Edition now with bonus chapters. Have you ever wanted to design your own website or browser application but thought it would be too difficult o... Read More >
You Can't Make This Stuff Up: Ridiculously Funny Stories by Real CopsYou Can't Make This Stuff Up: Ridiculously Funny Stories by Real CopsOne of the most popular questions cops get asked is "What's the funniest thing that's ever happened to you on the job?" Well, we set out to gather a f... 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:

How to Build a Billion Dollar App: Discover the Secrets of the Most Successful Entrepreneurs of Our TimeHow to Build a Billion Dollar App: Discover the Secrets of the Most Successful Entrepreneurs of Our Time

THE ULTIMATE GUIDE TO BUILDING AN APP-BASED BUSINESS - NOW REVISED AND UPDATED FOR 2017

'A must read for anyone who wants to start a mobile a... Read More >

PhP: Learn PHP Programming Quick & EasyPhP: Learn PHP Programming Quick & EasyWant to learn the in-demand skill of PHP programming… AND do it fast?

Are you new to computer programming or just want to brush up on some skills... Read More >

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:

Modern PHP: New Features and Good PracticesModern PHP: New Features and Good Practices

PHP is experiencing a renaissance, though it may be difficult to tell with all of the outdated PHP tutorials online. With this practical guide, you... Read More >

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 >

Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5 (Learning Php, Mysql, Javascript, Css & Html5)Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5 (Learning Php, Mysql, Javascript, Css & Html5)The fully revised, updated and extended 4th edition of the hugely popular web development book - includes CSS, HTML5, jQuery and the mysqli extension.... 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:

PhP: Learn PHP Programming Quick & EasyPhP: Learn PHP Programming Quick & EasyWant to learn the in-demand skill of PHP programming… AND do it fast?

Are you new to computer programming or just want to brush up on some skills... Read More >

Code Name VerityCode Name VerityOct. 11th, 1943-A British spy plane crashes in Nazi-occupied France. Its pilot and passenger are best friends. One of the girls has a chance at surviv... Read More >
Code Talker: A Novel About the Navajo Marines of World War TwoCode Talker: A Novel About the Navajo Marines of World War Two"Readers who choose the book for the attraction of Navajo code talking and the heat of battle will come away with more than they ever expected to find... Read More >