Jump to content

peterman5

New Members
  • Posts

    4
  • Joined

  • Last visited

Posts posted by peterman5

  1. Hello

    I have mysql tables where the text is arabic, I want to export them to Excell, If this is not possible , then to csv and then to excell,

     

    How I can do that, I have the phpmyadmin, It is not necessary that I do it through php, but if there is no other choice, i will do it through php

     

    I have written php code, but the result is that the arabic gives me ????

     

     

    Help is appreciated

     

    This is the code

    <?php

    $host = 'localhost';

    $user = 'user';

    $pass = 'password';

    $db = 'db';

    $table = 'table';

    $file = 'Subscribers';

    $link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());

    mysql_select_db($db) or die("Can not connect.");

    @mysql_query('SET NAMES utf8');

    @mysql_query("SET CHARACTER SET 'utf-8'");

    $result = mysql_query("SHOW COLUMNS FROM ".$table."");

    $i = 0;

    if (mysql_num_rows($result) > 0)

    {

    while ($row = mysql_fetch_assoc($result))

    {

    $csv_output .= $row['Field']."; ";

    $i++;

    }

    }

    $csv_output .= "\n";

    $values = mysql_query("SELECT * FROM ".$table."");

    while ($rowr = mysql_fetch_row($values))

    {

    for ($j=0;$j<$i;$j++)

    {

    $csv_output .= $rowr[$j]."; ";

    }

    $csv_output .= "\n";

    }

    header("Content-Type: text/x-csv; chartset=utf-8");

    header("Content-Disposition: attachment; filename=file.csv");

    header("Pragma: no-cache");

    header("Expires: 0");

    print $csv_output;

    exit;

    ?>

    csv.php

    excell.php

  2. Hello

     

    I have multiple images from a mysql database, I want to swap all these images onmouseover, IE, onmouseover, swap allthe images, each after some 3 4 seconds

     

    I amsure this will be done with javascript and probably jquery, So I need the Javascript (Or Jquery) function, and how to pass php parameters

     

    Naturally , there is a group of images, each will have more than one image to be swapped

     

    Many Thanks

  3. Hello,

     

    I need an image file manager, but not only an image manager, once I upload the images, i want to do this directly from a php form, and retrieve the values of the images uploaded/found on the gallery, and submit them along with other form fields to mysql database

     

    I do not want to use Tiny MCE, which seems to have something not working with the servers we use online

    Many Thanks

  4. Hello

    I am facing a rare issue while uploading videos, now the test is on .flv 7 mega and .wmv 5 mega

     

    Not Only the file is not getting uploaded, I cannot even see the tmp_name and ize is 0

     

    I have included:

     

    ini_set("post_max_size", "10M");

    ini_set("upload_max_filesize", "10M");

     

    and

    <input type="hidden" name="MAX_FILE_SIZE" value="100000" />

     

    This is all locally on the localhost, nothing allows for uploading the video

     

    Many Thanks

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.