Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > BOOK: Beginning PHP 6, Apache, MySQL 6 Web Development ISBN: 9780470391143
|
BOOK: Beginning PHP 6, Apache, MySQL 6 Web Development ISBN: 9780470391143
This is the forum to discuss the Wrox book Beginning PHP 6, Apache, MySQL 6 Web Development by Timothy Boronczyk, Elizabeth Naramore, Jason Gerner, Yann Le Scouarnec, Jeremy Stolz; ISBN: 9780470391143
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning PHP 6, Apache, MySQL 6 Web Development ISBN: 9780470391143 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 8th, 2012, 10:06 AM
Authorized User
 
Join Date: Feb 2012
Posts: 13
Thanks: 2
Thanked 0 Times in 0 Posts
Angry Fatal error: Call to undefined function mysql_real_ascape_string()

ny1 here, i ve been working on chapter 12, page 375 with the user_update.php
i am using XAMPP in win7.

i'm getting a
Fatal error: Call to undefined function mysql_real_ascape_string() in C:\xampp\htdocs\user_personal.php on line 24

code shown below:-

<?php
$query = 'SELECT
username, first_name, last_name, city, email, state, hobbies
FROM
mem_info u JOIN
user_data i ON u.user_id = i.user_id
WHERE
username = "' . mysql_real_ascape_string($_SESSION
['username'], $db) . '"'; (line 24)
$result = mysql_query($query, $db) or die(mysql_error($db));

$row = mysql_fetch_array($result);
extract($row);
mysql_free_result($result);
mysql_close($db);
?>
<ul>
<li>First Name: <?php echo $first_name; ?></li>
<li>Last Name: <?php echo $last_name; ?></li>
<li>City: <?php echo $city ?></li>
<li>State: <?php echo $state; ?></li> 1
<li>Email: <?php echo $email; ?></li>
<li>Hobbies/Interest: <?php echo $hobbies; ?></li>


i m only getting the line

Welcome to your personal infomation area.

and nothing, plz ny1 who ve gone through this
 
Old March 8th, 2012, 12:31 PM
Friend of Wrox
 
Join Date: May 2011
Posts: 125
Thanks: 0
Thanked 24 Times in 24 Posts
Default

Greetings,

This: mysql_real_ascape_string is not quite the same as this: mysql_real_escape_string which is why your getting an error.
 
Old March 9th, 2012, 10:20 AM
Authorized User
 
Join Date: Feb 2012
Posts: 13
Thanks: 2
Thanked 0 Times in 0 Posts
Thumbs up

hi @UseLess

thnkz for your time and correction
it really works now...
i've been working on this for a while bt you did it right
hope ll cont. to help other in time needs.

many thnkz again...





Similar Threads
Thread Thread Starter Forum Replies Last Post
Fatal error: Call to undefined function pg_query() Gu3rr1lla BOOK: Professional PHP6 0 August 11th, 2011 07:37 PM
Fatal error: Call to undefined function mysql_pcon surendran Beginning PHP 2 May 23rd, 2006 10:41 PM
Call to undefined function mysql_connect() tks_muthu PHP Databases 2 June 14th, 2005 01:23 AM
Fatal error: Call to ... domxml_open_mem() Philibuster PHP Databases 0 January 1st, 2005 10:34 PM
error Call to undefined function: query() gmanon Wrox Book Feedback 1 November 20th, 2003 06:34 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.