PHP and MySQL. Help to decide on a book


 
Thread Tools Search this Thread
Top Forums Web Development PHP and MySQL. Help to decide on a book
# 1  
Old 06-04-2014
PHP and MySQL. Help to decide on a book

Hi all,

I am studying PHP and MySQL and I have landed to use this book "Web Database Applications with PHP and MYSQL". I could see it has all I need (based on my limited experience on the subject and my requirements) to quickly learn how to build such applications as a web store, or any database driven application. The only problem is it is an old book (2004) and I was wondering if any one here can help me with her/his experience whether to keep using this book or if there are other alternatives or resources s/he would like to suggest.

Thank you in advance

~faizlo
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Checking files in remote server and decide to copy file or not

Hi there, I have a problem in my script, I need to check whether file exists in remote server or not, if the file exists, then stop copy else copy the file to the server.. my code is something like this while read $server do if ssh $server "cd $directory_name; if ; then echo "Error:... (2 Replies)
Discussion started by: beezy
2 Replies

2. Emergency UNIX and Linux Support

Migration of website... PHP/Mysql -which path for DB.php

Hi, I have two websites: website1.com and website2.com I didn't write either but have successfully moved all the files from website1.com to website2.com I (thought) I installed all the correct php modules and website2 is mostly up and running. However, my boss found that when we go to a... (15 Replies)
Discussion started by: Astrocloud
15 Replies

3. Programming

MySQL - PHP

Hello every one i have question i want to build DATAbase using PHP as interface i use shell to access to linux . i have in linux psql and SQLplus i'll call all html files that has db tabels from shell directory. what should to do before design php pages. can build the database sql design... (3 Replies)
Discussion started by: Scotch
3 Replies

4. AIX

Help Me to Decide

Dear friends I am an AIX administrator but now I am taking DB2 trainings.. DB2 is interesteing but if I want to success well I have to givap administering AIX systems because to do both of them its really tiresome and needs lot of time.. So anybody please advice me if you were at my place what... (0 Replies)
Discussion started by: Vit0_Corleone
0 Replies

5. Solaris

How to decide installing a Software group

Hello, I need to install a Jboss AS 4.2 asap. But I dont want to use the GUI. I need to install a solaris 10 server with the minimal packages but I dont know how deep I should customize and select the packages. You guys , how you decide to select a package installation level ? Each server's... (7 Replies)
Discussion started by: shadowfaxxxx
7 Replies

6. Shell Programming and Scripting

Script which can decide where to point i/p

Dear friends, :) I need your help again. This time I have written 2 scripts i.e. A.sh & B.sh and both of them takes “serial no” as input. Both the scripts are exactly same except one thing, both are pointing to different tables. Now I want to write another script that will decide whether to... (4 Replies)
Discussion started by: anushree.a
4 Replies

7. UNIX for Dummies Questions & Answers

How to decide which unix i have to use

I've got an old laptop and i want to try unix on it, but i'm a unix newbie, so i don't know what i have to choose. We're talking about a laptop with an intel 80C386SX-20 CPU in it, with 2 MB Ram and 40 MB harddisk. Not really powerfull specs. Is it possible to install a unix version on it. Or... (8 Replies)
Discussion started by: rolfvandekrol
8 Replies
Login or Register to Ask a Question
MYSQL_INSERT_ID(3)							 1							MYSQL_INSERT_ID(3)

mysql_insert_id - Get the ID generated in the last query

SYNOPSIS
Warning This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include: omysqli_insert_id(3) o PDO::lastInsertId int mysql_insert_id ([resource $link_identifier = NULL]) DESCRIPTION
Retrieves the ID generated for an AUTO_INCREMENT column by the previous query (usually INSERT). o $ link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection is found or established, an E_WARNING level error is generated. The ID generated for an AUTO_INCREMENT column by the previous query on success, 0 if the previous query does not generate an AUTO_INCRE- MENT value, or FALSE if no MySQL connection was established. Example #1 mysql_insert_id(3) example <?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } mysql_select_db('mydb'); mysql_query("INSERT INTO mytable (product) values ('kossu')"); printf("Last inserted record has id %d ", mysql_insert_id()); ?> Caution mysql_insert_id(3) will convert the return type of the native MySQL C API function mysql_insert_id() to a type of long (named int in PHP). If your AUTO_INCREMENT column has a column type of BIGINT (64 bits) the conversion may result in an incorrect value. Instead, use the internal MySQL SQL function LAST_INSERT_ID() in an SQL query. For more information about PHP's maximum integer values, please see the integer documentation. Note Because mysql_insert_id(3) acts on the last performed query, be sure to call mysql_insert_id(3) immediately after the query that generates the value. Note The value of the MySQL SQL function LAST_INSERT_ID() always contains the most recently generated AUTO_INCREMENT value, and is not reset between queries. mysql_query(3), mysql_info(3). PHP Documentation Group MYSQL_INSERT_ID(3)