PHP - Db Issues (upgraded From 4.x To 5.2)

Hey all,

I can not get utf-8 working properly.

I'm having issues with special characters, such as bullets, e with an accent over it, etc.

The data is being stored in my mssql database properly, and I can see everything there fine. It's when I grab it from the database and display it on my php page. The page it set up to utf-8, if I go to Tools>Page Info, it says encoding is utf-8. I have it in my headers, I just can not figure out why it will not display on the page.

Any thoughts?

Hello,

I have the following code


Code: [Select]
class Uploads extends Controller
{
 public function __construct()
 {
  parent::__construct();

  if (empty($_FILES))
  {
   log_message('error', 'Uploads - files empty');
   exit('No files uploaded');
  }

  ini_set('memory_limit', '128M');

  $this->load->helper('file');
  $this->load->helper('helpers');
  $this->load->model('uploads_model');

 }

 public function font_handler()
 {
  $this->uploads_model->font_handler();
 }

}

class Uploads_model extends Model
{
    public function font_handler()
    {
  $config = array(
   'max_size'     => '8388',
   'allowed_types' => 'ttf',
   'upload_path'   => 'assets/fonts/'
  );

  $this->load->library('upload', $config);

  if ($this->upload->do_upload('Filedata'))
  {
   $file = $this->upload->data();
   $jsFile = $file['raw_name'].'.js';
   $query = $this->db->where('location', 'menuFont')->get('fonts')->row();

   if ($query->customFile != '' && file_exists('assets/fonts/'.$query->customFile))
         {
    unlink('assets/fonts/'.$query->customFile);
   }

   $path    = getcwd() . '/assets/fonts/cufon/convert.php';
   $command = 'php ' . $path . ' -u "U+??" ' . $file['full_path'] . ' 1> ' . getcwd() . '/assets/fonts/' . $jsFile;

   system($command);
  }
 }

}


Ok so, the ttf file is uploaded correctly and I can run $command from the command promt in putty and it works perfect, but when I try to run the same command from system() the js file just contains (from the controller) "No files uploaded" I have no idea why this is happening? Anyone have any ideas?  Also one thing i'm not sure about is if it should be 1> or > when creating the js file?!?


Thanks guys!

Hey,

I'm editting some code on an OS Commerce install, For some reason I dont get the various buttons displaying.
Underneath the shopping basket, it is supposed to show a view cart button and a checkout button, but they dont show up.

I'm also trying to edit it to use a layout of the stylesheet, Basically if you look at my website, you will see the categories list, these are generated by an <ul><li> code, which puts the background underneath the item name, I would like to do the same thing and limit the charactors in the name to say 50 (so they stay on one line)

Can you point me in the right direction to set an <li> on each item in the cart, and change it to UCWORDS, and restrict the charactors please?

Any ideas on why the images dont show up on the page?

http://tinyurl.com/2f6g2lg

This is my code.
<?php
/*
  $Id: shopping_cart.php,v 1.18 2003/02/10 22:31:06 hpdl Exp $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
*/
?>
<!-- shopping_cart //-->
<?php
 // $info_box_contents = array();
 // $info_box_contents[] = array('text' => BOX_HEADING_SHOPPING_CART);

 // new infoBoxHeading($info_box_contents, false, true, tep_href_link(FILENAME_SHOPPING_CART));

    $cart_contents_string = '';
  if ($cart->count_contents() > 0) {
    $cart_contents_string = '<table border="0" width="100%" cellspacing="0" cellpadding="0">';
    $products = $cart->get_products();
    for ($i=0, $n=sizeof($products); $i<$n; $i++) {
      $cart_contents_string .= '<tr><td align="right" valign="top" class="infoBoxContents">';

      if ((tep_session_is_registered('new_products_id_in_cart')) && ($new_products_id_in_cart == $products[$i]['id'])) {
        $cart_contents_string .= '<span class="newItemInCart">';
      } else {
        $cart_contents_string .= '<span class="infoBoxContents">';
      }

      $cart_contents_string .= $products[$i]['quantity'] . '&nbsp;x&nbsp;</span></td><td valign="top" class="infoBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '">';

      if ((tep_session_is_registered('new_products_id_in_cart')) && ($new_products_id_in_cart == $products[$i]['id'])) {
        $cart_contents_string .= '<span class="newItemInCart">';
      } else {
        $cart_contents_string .= '<span class="infoBoxContents">';
      }

      $cart_contents_string .= $products[$i]['name'] . '</span></a></td></tr>';

      if ((tep_session_is_registered('new_products_id_in_cart')) && ($new_products_id_in_cart == $products[$i]['id'])) {
        tep_session_unregister('new_products_id_in_cart');
      }
    }
    $cart_contents_string .= '</table>';
  } else {
    $cart_contents_string .= BOX_SHOPPING_CART_EMPTY;
  }

  $info_box_contents = array();
  $info_box_contents[] = array('text' => $cart_contents_string);

  if ($cart->count_contents() > 0) {
    $info_box_contents[] = array('text' => tep_draw_separator());
    $info_box_contents[] = array('align' => 'right',
                                 'text' => $currencies->format($cart->show_total())
 );
  //cart buttons start
$info_box_contents[] = array('align' => 'center',
          'text' => '<a href="' . tep_href_link(FILENAME_SHOPPING_CART) . '">' . tep_image_button ('button_cart_view.gif', IMAGE_BUTTON_CART_VIEW) . '</a>' . '<a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING) . '">' . tep_image_button ('button_cart_checkout.gif', IMAGE_BUTTON_CART_CHECKOUT) . '</a>' ); 
//cart buttons end

  }

  new infoBox($info_box_contents);
?>
<!-- shopping_cart_eof //-->

Hello, Well let me explain my problem to you guys.

I am using a printf function with an array, a custom function which i got off php.net

Anyways, Everytime I use it, It seems to leave random numbers at the end of the string for no reason at all.

Here is the result in source:
Code: [Select]
<td><a href="?page=download&name=DarkRP">DarkRP</a></td>
      <td>08:10:17 AM 07/08/2010</td>
      <td>Updated DarkRP from revision: 670 to revision: 67150</td>
      Array
(
    [Name] => DarkRP
    [TimeStamp] => 1281186617
    [Revision1] => 670
    [Revision2] => 671
)
    </tr>It is mean't to show Code: [Select]
Updated DarkRP from revision: 670 to revision 671but instead it has the random number 50 at the end for no reason...

Anyways heres the echoing code:

<?php
foreach($Logs as $Log){
$Time = TimeToDate($Log['TimeStamp']);
if($Log['Revision1']&$Log['Revision2']){
     $Message = 'Updated %1$s from revision: %3$s to revision: %4$d';
}else{
     $Message = 'Freshly downloaded: %1$s revision: %3$d';
}
?>
    <tr>
      <td><?php echo '<a href="?page=download&name='. $Log['Name'] .'">'. $Log['Name'] .'</a>'; ?></td>
      <td><?php echo $Time['Time'] .' '. $Time['Date']; ?></td>
      <td><?php echo printf_array($Message, $Log); ?></td>
      <?php print_r($Log); ?>
    </tr>
<?php
    }
?>
  </table>
  <br />

Functions:

function MySQLGetLogs(){
    global $Connection;
    if($Connection){
        $Query = sprintf('SELECT name, timestamp, revision1, revision2 FROM update_logs ORDER BY timestamp DESC;');
        if($Result = mysql_query($Query)){
            $Array = array();
            while($Row = mysql_fetch_array($Result)){
            $Array2 = array(array(
                                  'Name' => $Row['name'],
                                  'TimeStamp' => $Row['timestamp'],
                                  'Revision1' => $Row['revision1'],
                                  'Revision2' => $Row['revision2']
                                 )
                           );
                $Array = array_merge($Array, $Array2);
            }
            mysql_free_result($Result);
            return $Array;
        }
    }
}

function printf_array($Format, $Array) { 
    return call_user_func_array('printf', array_merge((array)$Format, $Array)); 
}

Also, I got the same issue with printf alone instead of the custom array function above.

Hey guys,
I wrote a function called isServer() so I can quickly move files from my local machine to my server without modifying too much.  The function is as follows:

function isServer() {
  if ($_SERVER['SERVER_NAME'] == 'myservername') {
    return(true);
  } else {
    return(false);
  }
} // isServer()

I have placed this function in a system.php file I created that is used to simply to keep things in order.  That files contents a

<?php
session_start();

function isServer() {
  if ($_SERVER['SERVER_NAME'] == 'myservername') {
    return(true);
  } else {
    return(false);
  }
} // isServer()

include "configuration.php";
include "functions.php";
include "functions_sql.php";
include "functions_soap.php";
include "functions_mail.php";

if (isProductionServer()) {
  $dbhost = 'db';
  $dbuser = 'db_user';
  $dbpass = 'pass123';
} else {
  $dbhost = 'localhost';
  $dbuser = 'user';
  $dbpass = 'pass';
}

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'my_database';
mysql_select_db($dbname) or die ('Selected database does not exist');
?>


The problem I am having is for some reason none of the include files are recognizing the function.  For example, the functions_mail.php file references the function to determine which emails to send (because the different environments have different modules and such installed).  I know this is something easy, but I can't seem to figure it out.  Thanks for any help!

Hey guys im having a real problem trying to make this string happend
the problem is passing parameters on the javascript function "onmouseover"


$map_array .= "<a href='map.php?planet=$address' 

onmouseover='ajax_popup
($picture,$detail_name,$stargate_address,$detail_owner,$time_conquered,$time_offset,$detail_siege,
$alliance)'>

<img src='images/star.jpg' style='position:absolute; left:".$b_x."px; top:".$b_y."px; border-style:solid;
border-color: yellow;'></a>";


if I try this it works
onmouseover='ajax_popup(1,2,3,4,5,6,7,8)'>

So the problem is when the variables equal words. Cause of the quote issue.

Is there like a way i should be using JSON to do what im trying to do? I have to keep this as a php string too. Or end as a php string

As far as it goes for me I have the switch() working, but not to what im trying to do. This is for a "media" page where I have 3 different categories "Music", "Videos" and "Photos". I'm trying to get it so when you goto the "Media" page it will show just the 3 categories, that section works but it is also showing the sub categories for all them categories. So for what im trying to do is when viewing the "media" page, it will display the 3 categories, then when selecting the category it will display the "sub categories". and then when you select the "sub category" it will display the contents of that "sub category"

should i be trying to do this a different way? or do i have something wrong here? lol

here is my switch() code
Code: [Select]
<?php
 $cat = (isset($_GET["m_cat"])) ? (intval($_GET["m_cat"])) : 0;
 switch($_GET["b"]=="true")
{
default :
if("/ffy/media.php"==$_SERVER['PHP_SELF'])
{
echo "Select a Category";
}

case "false":
if($_GET["m_cat"]==$cat)
{

echo "<font size='3'>";
$dcat = mysql_query("SELECT * FROM media_sub_cat WHERE m_cat=$cat")
or die("mySQL Query Failed: " .mysql_error());

while($catrow = mysql_fetch_array($dcat)) {
list($id, $m_sub_cat, $m_cat) = $catrow;

echo ": <font class='myFont'><a href='media.php?b=true&cat=".$m_cat."&subcat=".$m_sub_cat."'>".$m_sub_cat."</a></font> ";
}
echo ":</font>";
echo "Work Damb You";
}
break;

case "true":
if($_GET["cat"]==$cat && $_GET["subcat"]==$m_sub_cat)
{

echo "Weird...";

}
break;
}
?>

Hi,
I'm trying to convert a charting app to  OOP.
So here I've simplified it down to just the bare bones issue of drawing a line to a png image and displaying it.

Code: [Select]

<?php
 class chart {
  var $im;
  var $backgroundColor;
  var $textColor;
  function chart() {
    $this->im= @ImageCreate (100, 200) or die ("Cannot Initialize new GD image stream");
    $this->backgroundColor = ImageColorAllocate ($this->im, 224, 234, 234);
    $this->textColor = ImageColorAllocate($this->im, 233, 14, 91);
  }
 
  function display() {
    imageline ($this->im,0,0,100,200,$this->backgroundColor);
    imageline ($this->im,100,0,0,200,$this->textColor);

    ImagePng ($this->im);
  }
}
?>


Here is the code which instantiates the class.

Code: [Select]
<?php
  include "simple_draw.php";

$mychart = new chart();
$mychart->chart();
$mychart->display();

?>



Basically depending on how I rework it, one of two things happens: a)it generates a bunch of little boxes which say fffd, or b) I get a message saying the resource is invalid or nonexistent (this error isn't coming up right now so I can't be precise.)

If this is run outside the OOP environment it works fine. No sure. I'm really trying to work with classes but this kind of problem is frustrating and admittedly makes it tempting to just go back to regular functions.

Any ideas??

Thanks,
Jeff

Hey I'm having issues with using strtotime(), date(), and time().

I have a couple problems.
The first is: I used strtotime to get the unix of a specific date and time (worked great, even outputted the correct time using date() to return it). However when I went to post information on it (I set it up so that you can't post after the event started), it told me it already started like an hour before it was supposed to. I used Code: [Select]
if (time() > $event['when']) { echo "too late."; } else { do it } to determine.

That had me very confused.

Then I decided instead of manually inputting the event times I would pull them from an xml file, which I had no trouble reading.

I used: Code: [Select]
strtotime("Next $day, $time PM") with $day = Sun, $time = 1:00- This outputted a unix timestamp but then date() returned it as being 7 pm on sunday instead.

Any ideas what would be causing these strange things?

Ok guys first off I am a amateur porn star and having coding issues. I am on a web-server and personally have not issues when I test my contact page. However if anyone else test the site it never comes through? The code is broken into two php pages and I have just posted the second page for review. If anyone can shed light on this I would be greatly appreciated!! I do know there are some missing stuff in the verified section but that will not affect it going through the mail.....lol

   <h3 align="center"><?php
if(isset($_POST['email'])) {
     
    // EDIT THE 2 LINES BELOW AS REQUIRED
   $email_to = "info@elaysmith.com";
    $email_subject = "Pick 3 Special";
     
     
    function died($error) {
        // your error code can go here
        echo "We are very sorry, but there were error(s) found with the form you submitted. ";
        echo "These errors appear below.<br /><br />";
        echo $error."<br /><br />";
        echo "Please go back and fix these errors.<br /><br />";
        die();
    }
     
    // validation expected data exists
    if(!isset($_POST['email']) ||
        !isset($_POST['vid1']) ||
      !isset($_POST['vid2']) ||
        !isset($_POST['vid3'])) {
        died('We are sorry, but there appears to be a problem with the form you submitted.');     
    }
     
    $email_from = $_POST['email']; // required
    $vid1 = $_POST['vid1']; // required
    $vid2 = $_POST['vid2']; // required
    $vid3 = $_POST['vid3']; // required
     
    $error_message = "";
    $email_exp = "^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$";
  if(!eregi($email_exp,$email_from)) {
    $error_message .= 'The Email Address you entered does not appear to be valid.<br />';
  }
  if(strlen($error_message) > 0) {
    died($error_message);
  }
    $email_message = "Form details below.\n\n";
     
    function clean_string($string) {
      $bad = array("content-type","bcc:","to:","cc:","href");
      return str_replace($bad,"",$string);
    }
     
    $email_message .= "First Name: ".clean_string($first_name)."\n";
    $email_message .= "Email: ".clean_string($email_from)."\n";
    $email_message .= "Video 1: $vid1 \n";
   $email_message .= "Video 2: $vid2 \n";
   $email_message .= "Video 3: $vid3 \n";
     
     
// create email headers
$headers = 'From: '.$email_from."\r\n".
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();
@mail($email_to, $email_subject, $email_message, $headers);
?>
   
  <!-- include your own success html here -->
   
    Thank you for using my pick 3 Special
   
  <?php

Hi all,

I am desperately in need of some help here. I have been troubleshooting these codes for days, and I have posted this similar question quite a couple of times, and there is no answer from anyone... I am really in a bad shape now. Could someone please enlighten me to my problem?

I have created 2 while loops...apparently the 2nd while loop overwrites the 1st while loop record.

Meaning to say...1st while loop generates values of
'Math'
'Eng'
'Chi'
'Sci'
AND store it in $subject_data, createLevelCheckboxes($subject_data, $level_data, 5);

Apparently, the 2nd while loop takes only the last record 'Sci' from $subject_data and continues the looping. Which gives me results like

Level 1
Sci

Level2
Sci

Level3
Sci

I would like to attain something like....
Level 1
Math

Level2
Eng

Level3
Chi

Level4
Sci


Is there any reset which I need to do?



while($data = mysqli_fetch_array($sql)) 
    {
        if($current_level_id != $data['level_id']) 
        {
            $checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);
            $current_level_id = $data['level_id'];
            $subject_data = array();
        }
        //Add the current record to the $level_data array
        $subject_data[] = $data;
    }

while($data1 = mysqli_fetch_array($sql1)) //Iterate throug the DB results
    {

$checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);

$level_data = array();

$level_data[] = $data1;

}
    $checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);

I have an XML document that id decrypted and shown onto a table. At the bottom of the page, I'm trying to have it count up one

Code: [Select]
foreach($Data as $Types) // loop through book
foreach($Types as $Colors) // loop through book
{

print_r(count($Colors->Color));

}
There are 4 colors, blue, green, red, yellow.
Blue is listed 7 times, green is 3, red is 8, and yellow is 4 times.

What I expect it to print is:

7 3 8 4

Instead, it's printing this:

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

If I was to just do the print function without count, it lists like this:

blue red blue red green yellow blue red yellow red red green yellow yellow blue blue green blue yellow blue red red blue red


My end-goal of this code is to get it to print this:
Blue: 7
Green: 3
Red: 8
Yellow: 4

I'm going to post two scripts my login.php and my register.php

problem is i'm always getting usernamepassword don't match i think something to do with md5 but can't figure out where... or why?

<?php



session_start();



$login = $_POST['login'];

$password = $_POST['password'];


if ($login&&$password)



{
$connect = mysql_connect("localhost","heaven","jefF0614") or die ("could not connect to server");

mysql_select_db("heaven_users") or die ("could not find database");



$query = mysql_query("SELECT * FROM members WHERE username='$login'");



$numrows = mysql_num_rows($query);



if($numrows!=0) 



{



while ($row = mysql_fetch_assoc($query))

{

$dbusername = $row['username'];

$dbpassword = $row['password'];

}



// check to see if they match

if($login==$dbusername&&$password==$dbpassword)

{

 echo "Your In <a href='member.php'>click here to go to the member page</a>";

 //start session

 $_SESSION['username']=$login;

}

else 

echo "Incorrect Password/Username Combination";



}

else

die("That username dose not exist");





}

else

die ("Please enter a username and password");



?>

and register.php
<?php

//check for submit

$submit =$_POST['submit'];



//gather POST variable

$fullname =strip_tags($_POST['fullname']);

$email =strip_tags($_POST['email']);

$username =strip_tags($_POST['username']);



$password =strip_tags($_POST['password']);

$password2 =strip_tags($_POST['password2']);



if ($submit) 

{

//check that fields were filled in

if ($fullname&&$email&&$username&&$password&&$password2)

{


//check to see if our two password fields match

if ($password==$password2) 


{
$password = md5($password);
// register the user

 //open database
$connect = mysql_connect("localhost", "heaven", "jefF0614");
mysql_select_db("heaven_users");

//begine insert
$queryreg = mysql_query("INSERT INTO members VALUES ('','$fullname','$email','$username','$password')");

if ($queryreg) {

echo "Thanks, For Registering! Click <a href=\"index.php\">HERE</a>To Login!";

}


}

//otherwise if passwords don't match

else {

echo "<font color='red'>The passwords you entered do not match</font>";

//end of checking password
}
}
else {

echo "<font color='red'>Please enter all fields!</font>";

}
}
//end check for submit 



?>

I'm trying to run this:
Code: [Select]
<?php
ini_set('max_execution_time','3600');
ini_set('memory_limit','512M');
ini_set('upload_max_filesize','100M');
ini_set('post_max_size','100M');

phpinfo();

?>
Max execution time and memory_limit works but upload_max_filesize and post_max_size don't work. Are you allowed to set those at run time?

Thanks for taking the time to read the thread.


Basically the situation is with the following code:


Line 1: print(self::$internal_commands[$command_value]);

Line 2: print(self::$internal_commands[":!modules"]);


This will output the following:

Code: [Select]

Line 1: PHP Notice:  Undefined index: :!modules in /var/www/html/MagicIRC/Framework/commands.class.php on line 36

Line 2: Commands_Framework::command_loadedmods


Notice how the first notice tells you that ':!modules' isn't in the array yet the second print statement below it prints fine and the var $command_value is being supplied the same string as what the manually input print statement is?