PHP - Character Encoding Problem. Got Strange Characters In My Database

Hi, I believe this is my first post on here. First off let me say thank you for silently helping out in the past while I keep on learning PHP.

I have decided to build an image gallery, and I am having problems with the page numbering links and the breadcrumbs.

Reson I decided to build my own is that I wanted a challange to learn more.
I could not find anything that would intregrate with the site as I wanted it to (pulled as a function so offers some customising with options).

The problem that I am having is that the <a href= tag is starting to give multipul "/"s when I only need one, so that the url at the top is coming up as

http://localhost/mmv4/gallery/pics///Ax/Ax_Jo/

when I am wanting http://localhost/mmv4/gallery/pics/Ax/Ax_Jo/IMG_4244.JPG.

I have used str_replace to catch //s and more, but this then adds odd slashes on the end so the page numbeing is getting odd results. some dirs have the / on the end and some do not, so the links are sometimes "visited" and others not.

I beleve that the problem is generated in
Code: [Select]
<?php
if(isset($_GET['album'])) {
      //load the available dirs into an array so that the sneeky users cannot get further back.
      $files = scandir($gal);
      $dirs = array();
      foreach($files as $file){
         if($file != '.' && $file != '..' && $file != 'thumbs') {
            if(is_dir($gal."/".$file)) {
               $dirs[] = $file;
               //echo $file ."<br />\n";
            }
         }
      }
      
      //if(in_array($_GET['album'],$dirs)) {
         $album = "/".$_GET['album']."/";
         $album = str_replace("..", "", $album);
      //}
      //else {
      //   $output .= "<p>There is no album called \"$_GET[album]\", please select an album from below.</p>";
      //}
   }

or the breadcrumbs bit
Code: [Select]
<?php
if($crumbs == 1) {
      //bread crums
       $path = $gal.$album;
       $path = explode("/", $path);
   
   
       $crumbs = array();
       foreach($path as $key => $value) {
          if($value != ""){
             $crumbs[] = $value;
          }
       }
       // create Breadcrumbs div
   
       $output .= "<div id=\"breadcrumbs\">";
       $number = count($crumbs);
       $real = "";
       foreach($crumbs as $num => $link) {
          if ($link == $gal) {
             $link = "Gallery Home";
          }
          if ($num == $number -1) {
             $output .= $link;
          }
          else{
             if ($num >= 1){
                $real ="";
                for($x=1; $x<=$num; $x++) {
                   $real .= "/".$crumbs[$x];
                }
                $output .= "<a href=\"?album=".str_replace("/", "",$real)."\">".$link."</a>"." <- ";
             }
             else{
                $output .= "<a href=\"?album=".str_replace("/", "",$real)."\">".$link."</a>"." <- ";
             }
          }
          $num +1;
         
       }
   
       //close breadcrumbs div
       $output .= "</div>";
   }

Can any one please help me shed some light on this one, I am confused.
I can send / attach the full source if needed.

MOD EDIT: tags fixed for syntax highlighting . . .

I have a form with some dropdownlist that get populated dynamically(depends on what the user chooses) with jquery and an xml file. In the form I have a button that takes the info and populates another form with the values of the ddl. I have coded script which populates the second form with jquery and the name of each input get dynamically added like so:

Code: [Select]
<input type="text" value="'+model+'" name="Model_'+model+'" id="'+model+'" readonly size="'+model.length+'" />
<input type="text" value="'+model+'" name="Model'+model+'" id="'+model+'" readonly size="'+model.length+'" />>
<input type="text" value="'+color+'" name="Color'+color+'" id="'+color+'" readonly size="'+color.length+'" />
<input type="text" value="'+part+'" name="Part'+part+'" id="'+part+'" readonly size="'+part.length+'" />
<input type="text" value="$'+price+'" name="Price'+price+'" id="'+price+'" readonly size="'+price.length+'" />
<input type="text" value="'+qty+'" name="Quantity'+qty+'" id="'+qty+'" readonly size="'+qty.length+'" />
<input type="text" value="'+total+'" name="Total'+total+'" id="'+total+'" readonly size="'+total.length+'" />

What I want to do is grab the name of the element and remove the underscore and everything else form rileft to right so I am left with just the word before the underscore. I tried using substr($key,0,-28) but that wont work since everything after the underscore will have a different length. I was wondering if there is a way i can keep everything before the underscore and remove the underscore and everything after that.
Thanks in advance for any input I get.

Not sure where to post this question. I have a MySQL database and add records with a PHP form to the tables.

I have 2 fields (char) in one table. When the fields contain the character '  it wont write the record to the table! For example...if I enter. " John's house" it wont accept the record since ' appears in John's name!

How do I work around this?

Thanks

I have a PHP Form where users have to enter and upload a file but when they click upload everything is working except that it is only sending first character of text field to Database!

Can any one help??

Thanks

File upload.php form
Code: [Select]
<form action="add_file.php" method="post" enctype="multipart/form-data">
           <p><br>
      JobID:
        <input name="JobID" type="text" value="<?php echo $row_Recordset1['JobID']; ?>" readonly="readonly" />
    </p>
    <p>Company ID:
      <input name="CompanyID" type="text" value="<?php echo $row_Recordset1['CompanyID']; ?>" readonly="readonly" />
  </p>
    <p>UserID:
      <input name="UsersID" type="text" />
    </p>
    <p>Select File to upload:
      <input type="file" name="uploaded_file" />
  </p>
    <p>Make Sure All Details Are Correct before Submitting!</p>
    <p>
      <input type="submit" value="Submit Application" />
    </p>
        <form>   

add_file.php

// Check if a file has been uploaded
if(isset($_FILES['uploaded_file'])) {
    // Make sure the file was sent without errors
    if($_FILES['uploaded_file']['error'] == 0) {
        // Connect to the database
        $dbLink = new mysqli('localhost', 'user', 'password', 'phpsite');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
 
        // Gather all required data
        $JobID = $dbLink->real_escape_string($_POST['JobID']['JobID']);
      $CompanyID = $dbLink->real_escape_string($_POST['CompanyID']['CompanyID']);
      $UsersID = $dbLink->real_escape_string($_POST['UsersID']['UsersID']);
      $name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);
        $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);
        $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
       $size = intval($_FILES['uploaded_file']['size']);
 
        // Create the SQL query
        $query = "
            INSERT INTO `application` (
                `JobID`, `CompanyID`, `UsersID`, `name`, `mime`, `size`, `data`, `N_DateAndTime`
            )
            VALUES (
                '{$JobID}', '{$CompanyID}', '{$UsersID}', '{$name}', '{$mime}', {$size}, '{$data}', NOW()
            )";
 
 
        // Execute the query
        $result = $dbLink->query($query);
 
        // Check if it was successfull
        if($result) {
            echo 'Success! Your job application was successfully sent!';
        }
        else {
            echo 'Error! Failed to insert the file, please try again'
               . "<pre>{$dbLink->error}</pre>";
        }
    }
    else {
        echo 'An error accured while the file was being uploaded, please try again. '
           . 'Error code: '. intval($_FILES['uploaded_file']['error']);
    }
 
    // Close the mysql connection
    $dbLink->close();
}
else {
    echo 'Error! A file was not sent! Please try again!';
}
 
// Echo a link back to the main page
echo '<p>Click <a href="year1index.php">here</a> to go back</p>';
?>

MOD EDIT: [code] . . . [/code] BBCode tags added.

Hi, I have few files which i need to display in correct format and also save in db to use. My problem is here is my code:

$file =  "C:\\file.txt";
$data = file_get_contents($file);
$data = '<pre>';
$data .= mb_convert_encoding($file, 'UTF-8', 'ISO-8859-1');
$data .= '</pre>';
echo $data;


but when i echo $data i get weird characters . here is result
http://paste2.org/p/1361878

Thanks for any help.

Hello everyone,   I have a card database and everything works perfectly besides one thing.. I can't store 

'

 in my database via my form, i however do can store them into the database via PHPMyAdmin. I dont know what i've been doing wrong and it really bothers me. If any of you guys could help me out. Here's all the code you would need to find the issue.   This is the form file

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Edit Page</title>
</head>
<body>
<h1 align="center"> Add Cards</h1>
<form action="insert.php" method="POST">
      <input type="text" name="name" placeholder="Name" />
      <input type="text" name="color" placeholder="Color" />
      <input type="text" name="type" placeholder="Type" />
      <input type="text" name="subtype" placeholder="Sub Type" />
      <input type="text" name="power" placeholder="Power" />
      <input type="text" name="toughness" placeholder="Toughness" />
      <br>
      <input type="text" name="manacost" placeholder="Converted Mana Cost" />
      <input type="text" name="rarity" placeholder="Rarity" />
      <input type="text" name="expansion" placeholder="Expansion" />
      <input type="text" name="foil" placeholder="Foil" />
      <input type="text" name="stock" placeholder="Stock" />
      <input type="submit" value="Save" />
	  
</form>
</body>
</html> 

This inserts it into my database.

<?php 

($GLOBALS["___mysqli_ston"] = mysqli_connect("",  "",  "", , ))or die("cannot connect");  
((bool)mysqli_query($GLOBALS["___mysqli_ston"], "USE e_industries"))or die("cannot select DB"); 

$name = $_POST['name']; 
$color = $_POST['color']; 
$type = $_POST['type']; 
$subtype = $_POST['subtype']; 
$power = $_POST['power']; 
$toughness = $_POST['toughness']; 
$manacost = $_POST['manacost']; 
$rarity = $_POST['rarity']; 
$expansion = $_POST['expansion']; 
$foil = $_POST['foil']; 
$stock = $_POST['stock']; 

$sql="INSERT INTO Osiris (Name, Color, Type, Subtype, Power, Toughness, Manacost, Rarity, Expansion, Foil, Stock) 
VALUES ('$name', '$color', '$type', '$subtype', '$power', '$toughness', '$manacost', '$rarity', '$expansion', '$foil', '$stock')"; 
$result=mysqli_query($GLOBALS["___mysqli_ston"], $sql); 

if($result){ 
echo "Successful"; 
echo "<BR>"; 
echo "<a href='add.html'>Back to main page</a>"; 
} 

else { 
echo "ERROR"; 
} 
?>

If anyone could help me out that would be great!
Edited by OsirisElKeleni, 05 October 2014 - 12:29 PM.

Hello everybody,

Hope somebody can help.

As the subject says, I'm having encoding problems in my includes files, the "accents" and some special characters don't work.

However, they do work in my main HTML.

I really don't know what the problem is and how to fix it.

Thanks in advance.

Hi,

Using arabic characters,

I have a project, in the admin panel, where i am trying to change the value in the text box(ajax) on onblur js function.
Firefox simply working great but i am getting square brackets in the text box in the browser ie.

I simply guessing the value from the text box is not in the form of utf-8 encoding, i am calling the external javascript file, this is the code am using..

Code: [Select]
// JavaScript Document



var xmlhttp;
//function namechange(name_fieldvalue)


function namechange(name_fieldvalue,name_fieldname,id_val,id_fieldname,table_name)
{
/*
alert(name_fieldvalue);

alert(name_fieldname);
alert(id_val);
alert(id_fieldname);
alert(table_name);
*/

if (name_fieldvalue.length==0)
  {
  document.getElementById("txtHint").innerHTML="";
  return;
  }
xmlhttp=GetXmlHttpObject();
if (xmlhttp==null)
  {
  alert ("Your browser does not support XMLHTTP!");
  return;
  }
var url="ajax_namechange.php";
url=url+"?name_fieldvalue="+name_fieldvalue;
url=url+"&name_fieldname="+name_fieldname;
url=url+"&id_val="+id_val;
url=url+"&id_fieldname="+id_fieldname;
url=url+"&table_name="+table_name;
xmlhttp.onreadystatechange=stateChanged;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}



function stateChanged()
{
if (xmlhttp.readyState==4)
  {
  document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
  }
}



function GetXmlHttpObject()
{
if (window.XMLHttpRequest)
  {
  // code for IE7+, Firefox, Chrome, Opera, Safari
  return new XMLHttpRequest();
  }
if (window.ActiveXObject)
  {
  // code for IE6, IE5
  return new ActiveXObject("Microsoft.XMLHTTP");
  }
return null;
}





Anyone has the idea on this, please help me.

Thanks,