Learn VBA & Macros in 1 Week!

PHP - Illegal String Offset 'user_id'

Full Excel VBA Course - Beginner to Expert

Illegal String Offset 'user_id'	View Content

Hi guys, why am i getting this error: Illegal string offset 'user_id'

but when echo $value it brings the correct output.

Thanks

	    $user_id = 5;
    $user_name = "obodo";
    $_SESSION['test'] = array('user_id' => $user_id, 'user_name' => $user_name);
	
    foreach( $_SESSION['test'] as $value )
    {
         
	         echo $value['user_id'];   //give error
        /* echo $value //works  */
      
    }

Full Excel VBA Course - Beginner to Expert

Illegal String Offset

Similar Tutorials

View Content

I am writing a script that downloads stock data and graphs the prices using libchart charting library. After downloading data to array $prices, I use the following line to add a new data point to my chart: $serie1->addPoint(new Point($prices[$i]['date'], $prices[$i]['price']); $prices contains both date and price keys. However, this throws off illegal string offset error for both keys. I have checked with isset, both variables contain values. I have also tried typecasting, date with (string) and price with (float), but these threw off new errors. What could be causing the illegal string offset error? Is there a way to silence it?
Edited by codingcasually, 01 November 2014 - 03:55 AM.

Add The User_id To The Random String

Similar Tutorials

View Content

In the PHP script I'm using, in the Upload Form the user selects an image to Upload, the Form renames it like so:

$allowedExts = array("gif", "jpeg", "jpg", "pdf", "png");
$temp = explode(".", $_FILES["file"]["name"]);
$extension = strtolower( end($temp) );

if (!in_array($extension,$allowedExts))
{
echo ("Error - Invalid File Name");

}
$length = 20;
$randomString = (time());
$thumbnail = $randomString . "." . $extension;

The random string works successfully, but I'd like to add the user_id to the beginning of it and a dash, like this: user_id - So, the new file name would be something like: user_id-randomString.extension Can you please help me add that?

Update Only One Row Where User_id = 'testid' // User_id=testid In A Lot Of Rows!

Similar Tutorials

View Content

Hey Guys,
A very noob question...Here it goes:

I want to update the field user_id on my database table, there a lot of rows that the user_id is the same... "testID", I just want to update only ONCE.

mysql_query("UPDATE `users` SET status = '$StatusCheck' WHERE user_id = 'testID'");

Right now it's updating ALL the rows that have the user_id "testID". I just want to update only one.

Any ideas?
Thanks in advance!
Cheers!

Cannot Use String Offset As An Array

Similar Tutorials

View Content

Hi,
I know the problem that I am having is related to the change in PHP5 about strings and arrays, however I do not understand why my script is affected. It seems like I am not trying to add more variables to an array. I do not success in order solve the problem.
Help me please:

// Build View Array
if ($view_result!=false) {
$i=0;
while ($view_row =@ mysql_fetch_array($view_result)){
$i++;
$view_rows[$i] = $view_row;

// build view_comments array
if ($viewcomments=="yes") {
$sql = "SELECT * FROM blog_comments WHERE nBlogId=".$view_row["nIdCode"]." ORDER BY nIdCode DESC";

$result = mysql_query($sql,$con);
if ($result!=false){
$j=0;
while ($comment_row =@ mysql_fetch_array($result)){
$j++;
$view_comment_rows[$i][$j] = $comment_row;
}
}
}
}
} else {
$problem = "2";
}

// increment view counter for either the single blog being shown
// or ALL blogs being shown
//The problem is here
if ($view_rows[1]["nIdCode"]!="" && strpos($_SERVER["PHP_SELF"],"admin.php")==false){
if ($viewmode=="single"){
$blogid = $view_rows[1]["nIdCode"];
$sql = "UPDATE blog SET nViews=nViews+1 WHERE nIdCode=".$blogid;
} else {
for ($i=1;$i<=count($view_rows);$i++){
$blog_array[$i] = $view_rows[$i]["nIdCode"];
}
$blogids = implode(",",$blog_array);
$sql = "UPDATE blog SET nViews=nViews+1 WHERE nIdCode IN (".$blogids.")";
}
$result = mysql_query($sql,$con);
if ($result==false){
print "<li>Problem with SQL<br>[".$sql."]</li>\n";
}
}
}

Last edited by sbarros (2011-01-08 18:21:52)

Undefined String Offset.

Similar Tutorials

View Content

Ok, I am sure you have all come across this error before.
I am trying to understand why this occurs in a straight forward (spelled out for the complete dumb ass) kind of way.

I made the most simple script I could come up with that would produce the error, but I am still uncertain as to what causes it, or what the fix is.

Here is the script.
Using all the letters and numbers available I print the total characters in the string, run a for statement to print out each character in order from the string index, and get the error "Undefined String Offset 36". Which is the total number of characters in the string starting at 0.
The test script can be accessed at the following url: http://icca.exiled-alliance.com/classtest.php

$test = "abcdefghijklmnopqrstuvwxyz1234567890";
$b = "<br />";
echo $test;
echo $b;
echo "There are " .strlen($test). " characters in the above string";
echo $b;
for($x=0;$x<=strlen($test);$x++){
echo $test[$x]. "-->number $x";
echo $b;
}

Can anyone clear up why that error pops up from the way I have this scripted.

String Offset Error

Similar Tutorials

View Content

Hello, I have this script that I have been running a long time that is included in my site with a php include. It reads data from a cached file in an array. I noticed last night something has happened and it won't load in my site anymore and causes my site not to load. I determined this through various troubleshooting. Through the various troubleshooting I was able to get an error "Fatal error: Cannot use string offset as an array in /home4/mesquiu0/public_html/nws_alerts_scroller.php on line 44". This is strange because nothing has changed on my server or with this script. Also if I run it by itself it runs fine. http://www.mesquitew...ts_scroller.php but, when I include it in my site it won't load and I get the error. I am not sure what is causing this. I have done some research and it appears to be cause by a key as though it were an array of arrays. I just don't see it though. Here is the portion of the code it is referring to.

// IF there are alerts
if(!empty($atomAlerts)) {                                                                     // IF there are alerts
  usort($atomAlerts, 'a_sort');                                                               // sort locations
  foreach($atomAlerts as $aak => $aav) {                                                      // FOR EACH alert, get the data from the cache file
    $caav = count($aav);                                                                      // count alerts
    for($i=0;$i<$caav;$i++) {                                                                 // FOR EACH alert
      // assemble alert data
			$title[$i][0] = '<b>'.strtoupper($aav[$i][0]).'</b>';
			@$adarray[$aav[$i][10].' '.$title[$i][0]] .=  ' -  <a href="'.$alertURL.'?a='
               .$aav[$i][14].'#WA'.$aav[$i][13].'" title=" &nbsp;Details for '.$aav[$i][12]
               .' '.$aav[$i][0].'">' .$aav[$i][12] ."</a>";
    }
  }
}

Here is a sample of the cached file the script reads from.

$atomAlerts = array (
  'TXZ104' => 
  array (
    0 => 
    array (
      0 => 'Dense Fog Advisory',
      1 => 'Expected',
      2 => 'Minor',
      3 => 'Likely',
      4 => 1418136720,
      5 => 1418148000,
      6 => 'Anderson; Bell; Bosque; Collin; Comanche; Cooke; Coryell; Dallas; Delta; Denton; Eastland; Ellis; Erath; Falls; Fannin; Freestone; Grayson; Hamilton; Henderson; Hill; Hood; Hopkins; Hunt; Jack; Johnson; Kaufman; Lamar; Lampasas; Leon; Limestone; McLennan; Milam; Mills; Montague; Navarro; Palo Pinto; Parker; Rains; Robertson; Rockwall; Somervell; Stephens; Tarrant; Van Zandt; Wise; Young',
      7 => 'DENSE FOG IS OCCURRING OVER THE REGION WHICH WILL CREATE VERY
HAZARDOUS DRIVING CONDITIONS. SLOW DOWN...USE YOUR LOW BEAM
HEADLIGHTS...AND LEAVE PLENTY OF DISTANCE BETWEEN YOU AND THE
VEHICLE AHEAD OF YOU.',
      8 => '...DENSE FOG ADVISORY NOW IN EFFECT UNTIL NOON CST TODAY...
* LOCATION...ALL OF NORTH CENTRAL TEXAS.
* VISIBILITY...WIDESPREAD VISIBILITY REDUCTIONS OF LESS THAN 1/4
OF A MILE. VISIBILITIES WILL BEGIN TO IMPROVE AFTER NOON.
* IMPACTS...DENSE FOG WILL MAKE DRIVING HAZARDOUS.',
      9 => '#F60',
      10 => ' <img src="./images/FGY.gif" width="12" height="12" alt="Dense Fog Advisory" title=" Dense Fog Advisory" />',
      11 => '56',
      12 => 'Collin Co',
      13 => '1',
      14 => 'TXZ104',
      15 => '',
    ),
  ),

Any idea what might be causing this. I don't see anything right off the bat. Just strange it loads fine alone and the problem only happens and happened out of the blue when I include it in my site. I have tried to isolate it to see what might be conflicting with it but have been unsuccessful. I also would add it only errors and doesn't load when included in my site when there is an alert. Right now there is no alerts at the moment. There was alerts at the time this happened. -Thanks
Edited by Texan78, 09 December 2014 - 02:19 PM.

String Offset As An Array Error

Similar Tutorials

View Content

I am writing a data scraping script but i am getting fatal error.Can someone please help me.

My code:-

Code: [Select]
<?php
$con = mysql_connect("localhost","root","");
mysql_select_db("cakeshop", $con);
$test = '<form
                name="select">
                    <p><font color="#000000" size="3"><select
                    name="city" size="1"
                    onchange="self.location.href=this.options[this.selectedIndex].value">


                        <option value="xxxwi.htm">Wisconsin</option>
                        <option value="xxxwy.htm">Wyoming</option>

                    </select><br clear="all">
                    </font><font color="#000000" size="2">Click
                    on the state below where you want to send
                    cake<br>
                    or use the pull down menu above </font>
                </form> ';
preg_match_all('~<option\s+value="(.*?)">(.*?)</option>~', $test, $out);

for($i=0;$i<=2;$i++)
{
$data = file_get_contents('http://xxx.com/'.$out[1][$i].'');
preg_match_all('~<option\s+value="(.*?)">(.*?)</option>~', $data, $city);
//$klimit = sizeof($city);
$klimit = count($city[1]);
for($k=2 ;$k < $klimit; $k++)
{
$data = file_get_contents('http://xxx.com/'.$city[1][$k].''); //Error on this line
$regex = '~<td\s+colspan="2"\s+width="350"><font\s+size="2">\s+<b>\s+(.*?)  <\/b><br>(.*?) <br>(.*?),\s+(.*?)\s+<br>(.*?), (.*?)\s+<BR><BR><font\s+size="2"><img\s+src="\.\.\/images\/phone1.gif"\s+align="left"\s+hspace="4"\s+alt\s+=(.*)>\s+-\s+Phone\s+#\s+(.*?)\s+<\/font>\s+<BR>\s+<font\s+size\s+="1">~';
preg_match_all($regex, $data, $final);
$jlimit = count($final[1]);
for($j=0 ;$j < $jlimit; $j++)
{
$name = $final[1][$j];
$name = mysql_real_escape_string($name);
$address =  $final[2][$j];
$address = mysql_real_escape_string($address);
$city = $final[3][$j];
$city = mysql_real_escape_string($city);
$state = $final[4][$j];
$state = mysql_real_escape_string($state);
$pincode = $final[6][$j];
$pincode = mysql_real_escape_string($pincode);
$telephone = $final[8][$j];
$telephone = mysql_real_escape_string($telephone);
mysql_query("INSERT INTO cakeshop (name, address, city, state, pincode, telephone)
VALUES ('$name', '$address', '$city', '$state', '$pincode', '$telephone')");
}
}
}
mysql_close($con);
echo "Data scraping completed";
?>
Error message :-

Code: [Select]
Fatal error: Cannot use string offset as an array in C:\Users\Booone\AppData\Roaming\NuSphere\PhpED\projects\scraping1.php

Error is on this line "$data = file_get_contents('http://xxx.com/'.$city[1][$k].'');"

Fatal Error: Cannot Use String Offset As An Array In C:\wamp\www\s

Similar Tutorials

View Content

Hi, when I run my script I get the following error message. These are array variables I am passing into the playerAttack function. I can't figure out what is wrong it looks fine to me. Any help greatly appreciated. Thanks. Derek

Code: [Select]
attack posted
Fatal error: Cannot use string offset as an array in C:\wamp\www\SUN_DRAGON_GAME\gamestart.php on line 202
Code: [Select]
$currentMonster='octalisk';
///////////////////////////////////////////////////////////battle////////////////////////////
//function monsterEncounter($echoMonster,$monsterImage)
if(!empty($_POST['attack']))
{
echo "attack posted";
playerAttack($currentMonster,$player['stats']['playerHitRollLow'],$player['stats']['playerHitRollHigh'],
$player['stats']['playerDmgLow'],$player['stats']['playerDmgHigh'],$monsters['Ocean']['octalisk']['defense'],$monster['Ocean']['octalisk']['hp'],$player['faction']['Teardrop_Ocean_Protectors']);

$doesItAttack=encounter($monsters['ocean']['octalisk']['seeInvis'],$monsters['ocean']['octalisk']['aggro'],$player['factions']['Teardrop_Ocean_Protectors']);

//insert octalisk stats into monsterattack function.

if($doesItAttack =='yes')
{
monsterAttack($currentMonster,$monsters['Ocean']['octalisk']['hitRollLow'],$monsters['Ocean']['octalisk']['hitRollHigh'] ,
$monsters['Ocean']['octalisk']['dmgLow'],$monsters['Ocean']['octalisk']['dmgHigh'],
$player['stats']['playerDefense'],$player['stats']['playerHp'],$monsters['Ocean']['octalisk']['hp']);

}
else
{
echo "do nothing";
}
}
here is the attack function

Code: [Select]
function playerAttack($currentMonster,$hitRollLow,$hitRollHigh,$dmgLow,$dmgHigh,$monsterDefense, $monsterHp,$playerFaction)
{
echo "in player attack";
$playerRoll= rand($playerHitRollLow, $playerHitRollHigh);
if($playerHitRoll>=$monsterDefense)
{
global $theMessage; //shit had to make it global

$playerDamage= rand($playerDmgLow,$playerDmgHigh);

$theMessage = "You have hit a ". $currentMonster." for "."<strong>". $playerDamage."</strong> points of damage!";
$monsterHp= $monsterHp- $playerDamage;
$theMessage.=" The ".$currentMonster."'s hp is now ".$monsterHp;
if($monsterHp<=0)
{
if($playerFaction<=0)
{
$theMessage="Your faction standing with ".$playerFaction. "could not possibly get any worse.";
}

}
$theMessage.=" You have killed the ".$currentMonster. "Your faction standing with ".$playerFaction." is now ".$playerFaction-1;

}

else
{
global $theMessage; //WTF i dont know what im doing.
$theMessage= " Whoa! You missed the ".$currentMonster;
}
}

For Loop Not Working Properly/cannot Use String Offset As An Array

Similar Tutorials

View Content

Warning: Strpos() [function.strpos]: Offset Not Contained In String

Similar Tutorials

View Content

Hi, I'll be honest don't have a clue what I am doing but a friend asked me to look into her site, she gets the following error at the top of this page http://www.morairaluxuryvillas.com/rentals/villalist.php

Warning: strpos() [function.strpos]: Offset not contained in string in /home/morairal/public_html/rentals/villalist.php on line 85

the code on the line 85 is: $secondfstemp = strpos($block1, ".", $firstfs);

I am more than willing to look into but don't know where to start - anyone have any ideas?

Thanks for your time:-)

Php Error - "uninitialized String Offset: 36"

Similar Tutorials

View Content

Hi, I am new to the forums. I am having an issue with a snippet of code that generates random strings. I have already searched the forums, but the fix that I found is already in my code.
I am still receiving the error though and was wondering if there was something else going on that I didn't see. Here is my code:

Code: [Select]
$Data = 'Ahmet'.md5(mt_rand(0, 123456789));

$length = 30;
$chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
$string = '';
$string2 = '';
for ($a = 0; $a < $length; $a++)
{
$pos = mt_rand(0, strlen($chars)-1);
$string .= $chars{$pos};

$pos2 = mt_rand(0, (strlen($Data))-1);
$string2 .= $chars{$pos2};
}
I appreciate any help on this, as it is cluttering my system log table.
Thanks.

Why "uninitialized String Offset: " ?

Similar Tutorials

View Content

In a function of a php script there is the following code line:

function convert_mails($source_path, $mail_file = '') {
global $output_path;
print "sp=$source_path";
// -- parameters must have a trailing backslash --
if ($source_path[strlen($source_path)] != '\\') $source_path .= '\\';
...

When running it yields the following error:

sp=D:\storage\AABB.ACT\Archi0.FLD;
Notice: Uninitialized string offset: 35 in D:\WAMP\www\test.php on line 67

where line 67 is the line with the "if" statement.

So why and where is there an uninitialized string offset?
How can I repair the code?
Peter

Login To Carry The User_id

Similar Tutorials

View Content

Hello,

I've been racking my brains (and spending sleepless nights) trying to get a login system to work by where the member will insert their email address as [username] and password (already stored in the DB) - then the page to divert to an administration panel with their User_id for them to only edit their information.

The Code I have so far.....

The login_form.php
Code: [Select]
<?php

//Start session

session_start();

//Unset the variables stored in session

unset($_SESSION['SESS_CLIENT_EMAIL']);
unset($_SESSION['SESS_MAIN_ID']);

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Client Admin Panel</title>
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
</head>

<body>
<div id="wrapper">
<div id="header">
<h1>CLIENT LOGIN</h1>
<h2>CLIENT ADMINISTRATION PANEL</h2>
version 2.10
</div>
<div id="menu">
</div>
<div id="content">
<div id="right">
<div class="post">

<h2>CLIENT ADMINISTRATION PANEL - CLIENT LOGIN</h2><br />

<h3><span class="err"><strong><font color="#800000">PLEASE LOGIN</font></strong></span></h3><form id="loginForm" name="loginForm" method="post" action="login-exec.php">
<table width="315" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td width="150"><b>Email Address:</b></td>
<td width="157"><input name="login" type="text" class="textfield" id="client_email" /></td>
</tr>
<tr>
<td><b>Secret Word:</b></td>
<td><input name="password" type="password" class="textfield" id="client_password" /></td>
</tr>
<tr bgcolor='#f1f1f1'>
<td> </td>
<td><input type="submit" name="Submit" value="Login" /></td>
</tr>
<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td><b>Forgot SecretWord?:</b></td>
<td><font face='tahoma, arial, helvetica' size='2' ><a href='forgot-password.php'>Click Here</a></font></td>
</tr>
<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td><b>New Client?:</b></td>
<td><font face='tahoma, arial, helvetica' size='2' ><a href='../dhsite/webpages/reg_1.php'> Register Here</a></font></td>
</tr>
</table>
<br />
</form></p>
</div>
</div>
</div>
<div id="footer">
<p class="copyright">Copyright © *****************</p>
</div>
</div>
</body>
</html>
And the handler: login_exec.php
Code: [Select]
<?php

//Start session
session_start();
$_SESSION['var'] = $val;

//Include database connection details
require_once('config.php');

//Array to store validation errors
$errmsg_arr = array();

//Validation error flag
$errflag = false;

//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
die("Unable to select database");
}

//Function to sanitize values received from the form. Prevents SQL injection
function clean($str) {
$str = @trim($str);
if(get_magic_quotes_gpc()) {
$str = stripslashes($str);
}
return mysql_real_escape_string($str);
}

//Sanitize the POST values
$client_email = clean($_POST['login']);
$client_password = clean($_POST['password']);

//Input Validations
if($client_email == '') {
$errmsg_arr[] = 'Email Address missing';
$errflag = true;
}
if($client_password == '') {
$errmsg_arr[] = 'Password missing';
$errflag = true;
}

//If there are input validations, redirect back to the login form
if($errflag) {
$_SESSION['ERRMSG_ARR'] = $errmsg_arr;
session_write_close();
header("location: login-form.php");
exit();
}

//Create query

$qry="SELECT client_email, client_password, main_id FROM users WHERE client_email='$client_email' AND client_password='$client_password'";
$result=mysql_query($qry);

//Check whether the query was successful or not
if($result) {
if(mysql_num_rows($result) == 1) {

//Login Successful
session_regenerate_id();
$member = mysql_fetch_assoc($result);
$_SESSION['SESS_CLIENT_EMAIL'] = $member['client_email'];
$_SESSION['SESS_MAIN_ID'] = $member['main_id'];
session_write_close();
header("Location: test_admin_panel.php?user_id=".$main_id."");
exit();
}else {

//Login failed
header("location: login-failed.php");
exit();
}
}else {
die("Query failed");
}
?>
Any help would be VERY much appreciated!!

Storing Logged In Users User_id On Page

Similar Tutorials

View Content

Hello all...fairly new to this php/mysql thing... working on my final project thats due in about 24 hours... and i hit a rut...
im making a pretty basic, online classifieds site. users can sign up, login, post new listings and view others listings by clicking on different categories. the problem i am having right now is this...When the user clicks on "My listings" i need it to pull only the listings that were created by that users user_id, which is the primary key in my user_info table...my professor suggested storing it in hidden field through the login submit button...very confused and frustrated... any help is much appreciated...

Is It Illegal...

Similar Tutorials

View Content

Yeah I know one of those questions Like you guys are lawyers on standby or something. I just wanted to discuss the idea of creating a website mock up for a business that exists but you researched and they don't have a website yet. I guess how, is the next question in terms of getting their prices of products... but mainly what I was going to do was following along Google Map's street view and screenshot their business logos which are visible to the public eye. Then create a mock up of a website to show them on a tablet. What do you guys think?

Get Album Id, Upon Query With Browser Userid To Match Table User_id

Similar Tutorials

View Content

There is something wrong with my statement it is not returning sql queries results based on matching the url based based userid to match with the table user_id and get the Ablum id and Album name:

Please hlep:

Code: [Select]
if(isset($_GET['userid']))
{
$db =& JFactory::getDBO();
$user =& JFactory::getUser();
$id = $user->id;

$album_id = $_GET['userid'];
$query = 'SELECT user_id, id, format_id, year, name FROM #__muscol_albums WHERE user_id = ' . $album_id;
//$query = 'SELECT user_id FROM #__muscol_albums WHERE id = ' . $album_id ;
$result = mysql_query($query) or die('Error, No Album Search failed');
list($name, $user_id, $id, $year) = mysql_fetch_array($result);

echo $id;

//exit;
}

Checking For Illegal Characters In An Input

Similar Tutorials

View Content

Hi Guys,

This should be a simple one.

I am looking for the best way to ensure that any illegal characters are removed from an input.

I have a user registration form and login page. What I want to do is prevent against sql injection and therefore should be limiting the characters that can be entered.

For example I want a username to include only letters and numbers so I ideally want to strip out any white space, illegal characters such as " ' ( ) etc...

My issue with this is with the password, I would ideally like the user to be able to put as complex a password as they would like, so how would i prevent against illegal characters in this instance??

Cheers

Protecting Input Fields From Illegal Characters.

Similar Tutorials

View Content

Hi all,

I'm working on this site which I'll soon ask the guys in the testing forum to have a peek at. It's essentially an online community that was a uni project that has spiraled and grown exponetially.

I've spent many many hours in front of books and tutorals etc to put it together and as far as scripting goes, it seems to be fine. The problem i'm having...The tut's that I read / watched were using eregi_replace to protect text fields and this is now unsuported.

I want my site to be as secure as it can be, within reason.

I've tried using preg_replace instead and have searched for the syntax but i keep getting strang results.
I'm working on the "bio" field at the moment and then when that works I can move on and a-ply the same idea to the other fields.

This si what I have and what I've changed.
if ($_POST['parse_var'] == "bio"){

    $bio_body = $_POST['bio_body'];
    //$bio_body = str_replace("'", "'", $bio_body); (WAS TESTING THIS BUT NO JOY)
    //$bio_body = str_replace("`", "'", $bio_body);
$bio_body = mysql_real_escape_string($bio_body);
$bio_body = nl2br(htmlspecialchars($bio_body));

$bio = $_POST['bio'];
   $bio = eregi_replace("'", "'", $bio); (This works but is not as secure)
   $bio = eregi_replace("`", "'", $bio);
$bio = mysql_real_escape_string($bio);
$bio = nl2br(htmlspecialchars($_POST['bio']));

$sqlUpdate = mysql_query("UPDATE members SET bio='$bio' WHERE id='$id'");
and so on....}

When I change it to str_replace if I type in don't the whole word is deleted. when I type in preg I get an error.
Can someone please give me the correct code / syntax for getting the result I want.

I just want to make sure that every single field that has a user input is protected against any malicious attacks.
Thanks.

How Do I Escape "illegal" Characters?

Similar Tutorials

View Content

Hey I wasn't able to add/edit some text to the mysql database because of some character
how can i bypass them
should i use the mysql_real_escape_string() ? if yes how do i make it work with the code i got?

thaks

<?php
include "../configdb.php";

$id = $_GET['id'];
if(isset($_POST['submit']))
{
    //global variables
$name = $_POST['name'];
$footer = $_POST['footer'];

//run the query which adds the data gathered from the form into the database
$result = mysql_query("UPDATE pages SET name='$name', footer='$footer' WHERE id='$id' ",$connect);
echo "<b>Your Page have been edited successfully";
// echo "<meta http-equiv=Refresh content=2;url=index.php>";
}
elseif($id)
{
$result = mysql_query("SELECT * FROM pages WHERE id='$id' ",$connect);
        while($row = mysql_fetch_assoc($result))
{
?>

<h3>::Edit Page</h3>
<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?php echo $row['id']?>">
<input type="hidden" name="id" value="<?php echo $row['id']?>">
<textarea name="name"><?php echo $row['name']?></textarea>
<input name="footer" size="40" maxlength="255" value="<?php echo $row['footer']?>">
<input type="submit" name="submit" value="Submit">


      <?php
}
}
?>

Offset()

Similar Tutorials

View Content

hey guys im in a bit trouble trying to use window offset() function. basically i have a fixed header and what im trying to accomplish is for when the user scroll past a certain point the header content will change...im not sure if im going about this the right way or even sure if it is possible with a fixed header. any help would be grateful thank you

   <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
   <style type="text/css">
    body{
    margin:0px;
    background:#FFFFFF;
    }
    .header-cont {
    width:100%;
    position:fixed;
    top:0px;
    }
    .header {
    height:50px;
    background:#F0F0F0;
    border:1px solid #CCC;
    width:960px;
    margin:0px auto;
    }
    .content {
    width:960px;
    background: #F0F0F0;
    border: 1px solid #CCC;
    height: 2000px;
    margin: 70px auto;
    }
    </style>
   
<script>
$(window).scroll(function(){   
      
    var position = $('#position').offset().top;
       
    if ($(window).scrollTop() > position)
    {         
    	alert('hey');
    	// Change header content
    }
});
</script>
    
    </head>
 <body>
     
    <div class="header-cont">
    <div>FIXED HEADER</div>
    </div>
     <br />
    <div id='position'></div>

  <br /><br /> <br /><br /> <br /><br /> <br /><br /> 
  <br /><br /> <br /><br /> <br /><br /> <br /><br />   
  <br /><br /> <br /><br /> <br /><br /> <br /><br />    
  <br /><br /> <br /><br /> <br /><br /> <br /><br />     
  <br /><br /> <br /><br /> <br /><br /> <br /><br /> 
  <br /><br /> <br /><br /> <br /><br /> <br /><br /> 
  <br /><br /> <br /><br /> <br /><br /> <br /><br /> <br /><br /> <br /><br /> <br /><br /> <br /><br />   
  <br /><br /> <br /><br /> <br /><br /> <br /><br /> <br /><br /> <br /><br /> <br /><br />
 CONTENT HERE!
  </body>
</html>