PHP - Import Text-chunks From Calc Into 365 Writer Documents

Hi, I am trying to organise some data from a form which is transferred to me via jQuery. Right now I can transfer the data to my php function as either serialised data. Here I need to figure out to structure my data in arrays that allows me to work with them before I save to the database.. But how do I do this? I have been fiddling with explode, and trying to flatten it  and do an array_push using a "while" for every 6'th item..

What I am looking for is this:

Array[$i] (
Weight=>,
repetition=>,
field_id=>,
set_id=>
exercise_id=>,
planned_workout_id=
)

Array[$i++] (
Weight=>,
repetition=>,
field_id=>,
set_id=>
exercise_id=>,
planned_workout_id=
)

The structure I can have the data in

Serialised form:

Weight=&repetition=&field_id=h&set_id=1&exercise_id=1&planned_workout_id=1&Weight=&repetition=&field_id=h&set_id=2&exercise_id=1&planned_workout_id=1&Weight=&repetition=&field_id=h&set_id=3&exercise_id=1&planned_workout_id=1&Weight=&repetition=&field_id=h&set_id=4&exercise_id=1&planned_workout_id=1&Weight=&repetition=&field_id=h&set_id=1&exercise_id=13&planned_workout_id=1&Weight=&repetition=&field_id=h&set_id=2&exercise_id=13&planned_workout_id=1&Weight=&repetition=&field_id=h&set_id=3&exercise_id=13

or in array form.. which is 200+ subarrays

Array
(
    [0] => Array
        (
            [name] => Weight
			[value] => 
        )

    [1] => Array
        (
            [name] => repetition
            [value] => 
        )

    [2] => Array
        (
            [name] => field_id
            [value] => h
        )

    [3] => Array
        (
            [name] => set_id
            [value] => 1
        )

    [4] => Array
        (
            [name] => exercise_id
            [value] => 1
        )

    [5] => Array
        (
            [name] => planned_workout_id
            [value] => 1
        )

    [6] => Array
        (
            [name] => Weight
            [value] => 
        )

    [7] => Array
        (
            [name] => repetition
            [value] => 
        )

 

My string is like this:

line 1
line 2
....
line 3453
line 3454
etc...

I want to split the string into chunks of 500 lines, do something with those chunks and then reassamble the main $string again. The last chunk doesn't need to be 500 lines it can be less.

How can I do it?

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=345769.0

I need to work out the months remaining of someone's membership when the date provied is in the format dd/mm/YYYY - rounded down to one month.

So, today being Nov 6th if the membership expired on 10th Feb then this would return 3.

1st Feb would be 2 etc..

Problem -

http://runehints.com/calculators/mining?rsname=gaogier&action=calculator

So far all is correct, once you click calculate the problems start.

If I do a little math,

level 67 is the target, with 548028 xp, minus the current xp of 533469 that = 14559

14559 / 50 xp per coal = x amount of coal which is 291.18 coal.

Now, my calculator is saying, 33173 is the answer. Which it clearly is not the case.

The URL I get, http://runehints.com/calculators/mining?rsname=gaogier&action=calculate&cxp=533469&lvl=2192114

if you change the last part (2192114) to 548028 it nearly works out to be right, as it shows 291 coal.

http://runehints.com/calculators/mining?rsname=gaogier&action=calculate&cxp=533469&lvl=548028

I plan to get this script rewritten over the next couple of months, is it worth fixing it? I mean can you spot the error?

<?php
preg_match('~calculators\/([a-zA-Z]+)~', $_SERVER['REQUEST_URI'], $which);
    $which = $which[1];
?>
                      <div id="contenttitle"><?php echo ucfirst($which); ?> Calculator</div>
                        <div class="news">
<?php
preg_match('~(agility|attack|combat|cooking|crafting|defence|farming|firemaking|fishing|fletching|herblore|hitpoints|magic|mining|prayer|ranged|runecrafting|slayer|strength|summoning|thieving|woodcutting)~', $_SERVER['REQUEST_URI'], $url);
    $uri = $url[1];
if (empty($uri)) {
    echo '<table class="guide">
            <tr class="trtitle">
                <th class="main">Skill Name</th>
            <tr>
            <tr>
                <td><a href="/calculators/agility">Agility</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/attack">Attack</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/cooking">Cooking</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/crafting">Crafting</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/defence">Defence</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/farming">Farming</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/fishing">Fishing</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/fletching">Fletching</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/herblore">Herblore</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/hitpoints">Hitpoints</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/magic">Magic</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/mining">Mining</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/prayer">Prayer</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/ranged">Ranged</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/runecrafting">Runecrafting</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/slayer">Slayer</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/strength">Strength</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/summoning">Summoning</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/thieving">Thieving</a></td>
            <tr>
            <tr>
                <td><a href="/calculators/woodcutting">Woodcutting</a></td>
            <tr>
    </table>';
} else {
# All Calculator - calculate.php
# Orignally created on 28 December 2004 remade using RS Hiscores on 9 June 2005
# Created by Joseph Jeffery of DSIBaN Designs
//This page functions as every calculator
//set page headers
$lvl = 0;
    preg_match('~rsname=(.*)&action~', $_SERVER['REQUEST_URI'], $rsnam);
    $rsn = $rsnam[1];

/**
 * Return current xp for specific skill
 */
function return_exp($name, $skill) {
   $url = "http://hiscore.runescape.com/index_lite.ws?player=" . strtolower(str_replace(' ', '_', $name));
   if (($page = @file_get_contents($url)) === false) { echo "User $name was not found in the highscores for $skill"; return false; }
   if(strpos($page, "<html>")) { trigger_error('Unable to parse RuneScape highscore page', E_USER_WARNING); echo "<h1>DUMP</h1>"; }
   $catagories = split('
', $page);

   //Find proper index for skill
   switch($skill) {
        case "attack":
         $ind = 1;
 break;
case "defence":
 $ind = 2;
 break;
case "strength":
 $ind = 3;
 break;
case "constitution":
 $ind = 4;
 break;
case "ranged":
 $ind = 5;
 break;
case "prayer":
 $ind = 6;
 break;
case "magic":
 $ind = 7;
 break;
case "cooking":
 $ind = 8;
 break;
case "woodcutting":
 $ind = 9;
 break;
case "fletching":
 $ind = 10;
 break;
case "fishing":
 $ind = 11;
 break;
case "firemaking":
 $ind = 12;
 break;
case "crafting":
 $ind = 13;
 break;
case "smithing":
 $ind = 14;
 break;
case "mining":
 $ind = 15;
 break;
case "herblore":
 $ind = 16;
 break;
case "agility":
 $ind = 16;
 break;
case "thieving":
 $ind = 17;
 break;
case "slayer":
 $ind = 18;
 break;
case "farming":
 $ind = 20;
 break;
case "runecrafting":
 $ind = 21;
 break;
case "hunter":
 $ind = 22;
 break;
case "construction":
 $ind = 23;
 break;
case "summoning":
 $ind = 24;
 break;
case "dungeoneering":
 $ind = 25;
 break;
   }

   
   $skill_info = split(",", $catagories[$ind]);
   
   $skill_exp = $skill_info[2];

   return $skill_exp;

   
}

function enter_name(){
$skill = $_GET['skill'];
$mem = $_GET['members'];
    $_GET['action'] = 'calculator';
    preg_match('~rsname=(.*)&action~', $_SERVER['REQUEST_URI'], $rsnam);
    $rsn = $rsnam[1];
    preg_match('~&action=(.*)~', $_SERVER['REQUEST_URI'], $action);
    $_GET['action'] = $action[1];
    
echo '<form action="" method="get">
<p>Runescape name:&nbsp; <input type="text" name="rsname" class="text" value="' . $rsn  . '" />
    <input type="hidden" name="action" value="calculator" /></p>
<input type="submit" class="text" value="Grab XP" onMouseOver="this.style.cursor=\'hand\';"/>
</form><br />
';

}


function calculator(){
    preg_match('~rsname=(.*)&action~', $_SERVER['REQUEST_URI'], $rsnam);
    $rsn = $rsnam[1];
    preg_match('~calculators\/(.*)\?rsname~', $_SERVER['REQUEST_URI'], $skill);
    $skill = $skill[1];
    preg_match('~&action=(.*)~', $_SERVER['REQUEST_URI'], $action);
    $_GET['action'] = $action[1];
if($rsn != "") { $xp = return_exp($rsn, $skill); }

$mem = $_GET['members'];
    if ($xp > 13034430){
        echo 'You\'re already level 99!';
    }
    ?>
   <form action="" method="get">
<table border="0" class="calcinput">
<input type="hidden" name="rsname" value="<?php echo $rsn; ?>">
        <input type="hidden" name="action" value="calculate" />
<tr><td>Current Xp:</td><td> <input type="text" name="cxp" class="text" value="<?php if ($xp != "0") { echo $xp; } ?>" /></td></tr> 
<tr><td>Current Level:</td><td><input type="text" class="text" value="<?php echo getLevel($xp); ?>" /></td></tr> 
<tr><td>Desired Level:</td><td> <SELECT name="lvl" class="text"><?php genDropDown($xp); ?> </select> <?php
if ($mem == "yes"){
echo '<tr><td>Show members items?:</td><td> <input name="showmembers" type="checkbox" disabled="true" value="yes" checked></td></tr> ';
}else{
echo '<tr><td>Hide members items?:</td><td> <input name="showmembers" type="checkbox" value="no"></td></tr> ';
}
?>
<tr><td><input type="submit" class="text" value="Calculate" onMouseOver="this.style.cursor='hand';"/></td><td>
<input type="reset" class="text" value="Reset" onMouseOver="this.style.cursor='hand';"/></td></tr> 
</table>
<?php 
}

/*Calculate level based on experience
function getLevel($xp) {
   $a = 0;
   for($i = 0; $i < 100; $i++) {
      if($a / 4 > $xp) { return $i; }
      $a += floor($i + 300 * pow(2, ($i / 7)));
   }
} */

function getLevel($exp){
   $levels = array(1 => 0, 83, 174, 276, 388, 512, 650, 801, 969, 1154, 1358, 1584, 1833, 2107, 2411, 2746, 3115, 3523, 3973, 4470, 5018, 5624, 6291, 7028, 7842, 8740, 9730, 10824, 12031, 13363, 14833, 16456, 18247, 20224, 22406, 24815, 27473, 30408, 33648, 37224, 41171, 45529, 50339, 55649, 61512, 67983, 75127, 83014, 91721, 101333, 111945, 123660, 136594, 150872, 166636, 184040, 203254, 224466, 247866, 273742, 302288, 333804, 368599, 407015, 449428, 496254, 547953, 605032, 668051, 737627, 814445, 899256, 992895, 1096278, 1210421, 1336443, 1475581, 1629200, 1798808, 1968068, 2192818, 2421087, 2673114, 2951373, 3258594, 3597729, 3972294, 4385776, 4842295, 5346332, 5902831, 6517253, 7195629, 7994614, 8771558, 9684577, 10692629, 11805606, 13034431);
   $l = count($levels);
   while ($levels[$l] > $exp) $l--;
   return $l;
} 

//Generate dropdowns based on xp
function genDropDown($xp) {
   //Gather experience
   $a = 0;
   
   for($i = 0; $i < 100; $i++) {
         if($a / 4 > $xp) { 
            if($lvl == 0) { $lvl = $i; }
            echo "<option value=\"$a\">Level $i - " . floor($a / 4) . " xp</option>"; 
         }
      $a += floor($i + 300 * pow(2, ($i / 7)));  
   }
}
function calculate(){
    preg_match('~&lvl=(.*)~', $_SERVER['REQUEST_URI'], $lvl);
    $lvl = $lvl[1];
    preg_match('~&cxp=(.*)&lvl~', $_SERVER['REQUEST_URI'], $cxp);
    $cxp = $cxp[1];
    preg_match('~rsname=(.*)&action~', $_SERVER['REQUEST_URI'], $rsnam);
    $rsn = $rsnam[1];
    preg_match('~calculators\/(.*)\?rsname~', $_SERVER['REQUEST_URI'], $skills);
    $skills = $skills[1];
    preg_match('~&action=(.*)~', $_SERVER['REQUEST_URI'], $action);
    $_GET['action'] = $action[1];

$lev = $_POST['lev'];
$xpn = $lvl - $cxp;  
if ($xpn == ""){
$xpn = $_GET['xpn'];
}
    if ($lev == ""){ 
$lev = $_GET['lev'];
    }
$show = $_GET['showmembers'];
if ($show == "0"){
$show = $_POST['showmembers'];
}
    
switch($skills) {

case 'firemaking':
$skill = "fire";
$item = "Log";
break;
case 'runecrafting':
$skill = "rune";
$item = "Rune";
break;
case 'ranging':
$skill = "range";
$item = "Monster";
break;
case 'herblore':
$skill = "herb";
$item = "Herb/Potion";
break;
case 'fishing':
$skill = "fish";
$item = "Fish";
break;
case 'cooking':
$skill = "cook";
$item = "Food";
break;
   case 'woodcutting':
$skill = "wood";
$item = "Log";
break;
case 'agility':
$skill = "agility";
$item = "Course";
break;
case 'slayer':
$skill = "slayer";
$item = "monster";
break;
case 'farming':
$skill = "farming";
$item = "Seed/Action";
break;
case 'fletching':
$skill = "fletching";
$item = "Item";
break;
case 'magic':
$skill = "magic";
$item = "Spell";
break;
case 'mining':
$skill = "mining";
$item = "Ore";
break;
case 'smithing':
$skill = "smithing";
$item = "Bar";
break;
case 'thieving':
$skill = "thieving";
$item = "Chest/Stall/Pickpocket";
break;
case 'fighting':
$skill = "fighting";
$item = "Monster";
break;
case 'crafting':
$skill = "crafting";
$item = "Item";
break;
case 'prayer':
$skill = "prayer";
$item = "Bones";
break;
default:
   $skill = $skill[1];
   $item = "Item";
}
$mem = $_GET['members'];
echo'
<table border="0.5" cellspacing="1" cellpadding="2" align="center" bgcolor="#857553">
<tr><td class="tableheader"><a style="color: #EED8B4" href="'.$_SERVER['PHP_SELF'].'?action=calculate&skill='.$skill.'&orderby=level&xpn='.$xpn.'&lev='.$lev.'&members='.$mem.'&showmembers='.$show.'">Level needed</a></td><td class="tableheader"><a style="color: #EED8B4" href="'.$_SERVER['PHP_SELF'].'?action=calculate&skill='.$skill.'&orderby=item&xpn='.$xpn.'&lev='.$lev.'&members='.$mem.'&showmembers='.$show.'">'.$item.'</a></td><td class="tableheader"><a style="color: #EED8B4" href="'.$_SERVER['PHP_SELF'].'?action=calculate&skill='.$skill.'&orderby=xp&xpn='.$xpn.'&lev='.$lev.'&members='.$mem.'&showmembers='.$show.'">Experience given</a></td><td class="tableheader"><a style="color: #EED8B4" href="'.$_SERVER['PHP_SELF'].'?action=calculate&skill='.$skill.'&orderby=xp&xpn='.$xpn.'&lev='.$lev.'&members='.$mem.'&showmembers='.$show.'">Number of times</a></td><td class="tableheader"><a style="color: #EED8B4" href="'.$_SERVER['PHP_SELF'].'?action=calculate&skill='.$skill.'&orderby=members&xpn='.$xpn.'&lev='.$lev.'&members='.$mem.'&showmembers='.$show.'">Members?</a></td>';
require_once ('includes/connect.php');//connect to db
$by = $_GET['orderby'];
if ($mem == "no"){
if ($show == "no"){
$mess = '<a href="'.$_SERVER['PHP_SELF'].'?action=calculate&skill='.$skill.'&orderby=level&xpn='.$xpn.'&lev='.$lev.'&members='.$mem.'&showmembers=no">Click here to show members items</a>';
$n_query = 'SELECT * FROM `'.$skill.'calc` WHERE `members`="0" ORDER BY `'.$by.'` ASC';
}else{
$mess = '<a href="'.$_SERVER['PHP_SELF'].'?action=calculate&skill='.$skill.'&orderby=level&xpn='.$xpn.'&lev='.$lev.'&members='.$mem.'&showmembers=yes">Click here to hide members items</a>';
$n_query = 'SELECT * FROM `'.$skill.'calc` ORDER BY `'.$by.'` ASC';
}
}else{
$n_query = 'SELECT * FROM `'.$skill.'calc` ORDER BY `'.$by.'` ASC';
}
  $n_result = mysql_query ($n_query);
while ($n_row = mysql_fetch_assoc($n_result)) {
$level = $n_row['level'];  
$course = $n_row['item'];
$xpg = $n_row['xp'];

$tot1 = $xpn / $xpg;
$tot = sprintf('%.0f', $tot1);
$members1 = $n_row['members'];
if ($members1 == "1"){
$members = "Yes";
$bg2 = "#808080";
}else{
$members = "No";
$bg2 = "#FF8C00";
}
if ($lev < $level){
$bg = "#049f2c";
}else{
$bg = "#006600";
}
echo '<tr><td class="calc" bgcolor="'.$bg.'"onMouseOver="this.style.backgroundColor=\'#71828A\'" onMouseOut=this.style.backgroundColor="'.$bg.'">'.$level.'</td><td>'.$course.'</td><td>'.$xpg.'</td><td>'.$tot.'</td><td class="calc" bgcolor="'.$bg2.'" onMouseOver="this.style.backgroundColor=\'#71828A\'" onMouseOut=this.style.backgroundColor="'.$bg2.'">'.$members.'</td>';
}
echo'
</table><br />
';
        echo $lev;

}
    preg_match('~rsname=(.*)&action~', $_SERVER['REQUEST_URI'], $rsnam);
    $rsn = $rsnam[1];
    preg_match('~calculators\/(.*)\?rsname~', $_SERVER['REQUEST_URI'], $skill);
    $skill = $skill[1];
    preg_match('~&action=([a-zA-Z0-9]+)~', $_SERVER['REQUEST_URI'], $action);
    $_GET['action'] = $action[1];
    
switch($_GET['action']) {
    case 'calculate':
     enter_name();
        calculate();
        break;
    case 'calculator':
        enter_name();
        calculator();
        break;
   case 'enter_name':
        enter_name();
        calculator();
        break;
    default:
        
       enter_name();
}
}
?>
</div>

is there a way I can make something like a ticket in pdf format that can have $name or the likes echo in it?  if you could help get me started, that would be great!

Hi,  There is this project 'District Collector Office-Information integration' that computerizes the citizen facility center. In the system citizens can apply for birth certificates,marriage certificate  , obtain ration cards among other functionalists online.so far my system can generate birth and marriage certificates but i totally have no idea on how to validate  the same.at what conditions is one illegible to obtain a marriage cert?,supposing one has more than one wife?,what limits one from applying for more than one document? when is one illegible to obtain a birth cert.? conditions limiting application of more than one birth cert ?
Thanx.
Regards cornelius

Hey Everyone,

I need to have the ability to create PDF/X1A documents.  My initial thoughts are it would be easy as i have created PDFs in the past with no hassle.  I have been trawling the google and various blogs but with no joy.

Does anyone have any experience creating PDF/X1A documents in PHP ? Is it possible ?

Regards,
-Ben

I am trying to write to a document that is open doc format.

Are there any libraries that help out with this specifically mailing labels?

Hi,

I've been looking around the net and various forums and found that the code below does appear to work and do what I need at a basic level, but I was wondering if there was a quick and easy way to improve this code OR another alternative that would give me similar/better results.

I effectively have certain word documents that I want to use as templates for part of a project. So if i were to write a letter I could pull from the DB usual name/address, but also other intelligent information that might be dependant on different DB fields so it could generate different options, ie if they had children it would produce a different sentence??

Obviously my ideal solution would be that the php coding wouldnt need to be touched, but would allow for 'coded options' within the document to be added/removed without causing any issues, maybe some kind of generic coding so at least some content can be re-used for multiple documents ?

However, I did have two initial thoughts on how to do some of this - maybe? (be gentle im still a learner!)

1, create an array of somekind and use generic terms for a set range, say 'bookmark1','bookmark2', etc so a user could just tag the original word document knowing they only had to add a new number to the end if they needed to add something new ?
2,read the document contents out -DO STUFF TO IT- load it back into a doc/save. with this method I will have to admit ive not done before so would welcome any extra detailed input or advisory suggestions, ie. ensuring it goes back into the correct format, say there was an image/logo or complicated series or bulleted paragraghs or tables ??

I have initially choosen MS word as many people out there are familiar with this product and is widely used. However, if it means I am able to create something easily and better within some other format or package that will give me what I want but also be compatible with word then im more than happy to go with any suggestions (ie templates initially created within openoffice and merely saved into .DOC format?)

<?php
//1. Instanciate Word
$word = new COM("word.application") or die("Unable to instantiate Word");
//2. specify the MS Word template document (with Bookmark TODAYDATE inside)
$template_file = "C:/t.doc";
//3. open the template document
$word->Documents->Open($template_file);
//4. get the current date MM/DD/YYYY
$current_date = date("m/d/Y");
//5. get the bookmark and create a new MS Word Range (to enable text substitution)
$bookmarkname = "mytester";
$objBookmark = $word->ActiveDocument->Bookmarks($bookmarkname);
$range = $objBookmark->Range;
//6. now substitute the bookmark with actual value
$range->Text = $current_date;
//7. save the template as a new document (c:/reminder_new.doc)
$new_file = "c:/reminder_new.doc";
$word->Documents[1]->SaveAs($new_file);
//8. free the object
$word->Quit();
//$word->Release();
$word = null;
?>

I'm storing website files online and each user can upload their own files and admin can upload files for that user specifically. How would I go about making sure nobody else can download their PDF file? Would it be a case of assigning a folder for each user's documents and not allowing access to any other user to that folder? Thanks in advance.

Hi,

Well I have been working on Php for quite sometime but creating Word Docs is something I am totally new to. I googled about this and found different methods of creating word documents via php. The most promising one that I found involves writing HTML code and inside header, save it as a *.doc file (I know thats not exactly a Word File but what else can be done). Like this,

Code: [Select]
header("Content-type: application/vnd.ms-word");
header("Content-Disposition: attachment; Filename=Report.doc");

The whole word document came out perfectly fine, but there was one little problem (later on turned out to be the BIGGEST one) was placing images in the document. All the images were saved on a secure server so like we do in HTML, I used the following line of code,

<img src="https://somewebaddress/users.png" />

The word document appeared to be fine for me, but when that document was sent to the client, client was unable to view the images. Now, I guess you all know what my question would be, and that is, is there a way we could somehow make this work. I even tried downloading all the images to disk and giving their path, still in the end, the document only needs to be sent to the client and images do not appear.

Please help me in this regards, Thanks in advance to all

P.S. Please see the following sample (mini) code of the real thing, real document is a bit toooooooo big and kind of confidential 

Code: [Select]
<?php
header("Content-type: application/vnd.ms-word");
header("Content-Disposition: attachment; Filename=Report.doc");
?>

<html>
<head>
<title>TCS Monthly Report $month $year</title>
</head>
<body>

<b><h3>&nbsp;&nbsp;&nbsp;&nbsp;Monthly Operational User Statistics</h3></b>
<br>

    The red line is users logged in over the month. The green area is users recently logged in (last few days).<br>

    <br><img src="https://somewebaddress/users.png" />

</body>
</html>

Hello one and all,

Just a quick request here, I've written a script that sends an email with an attached file by the user. (docx, txt, pdf, doc, rtf) are the formats I have accepted. At the moment I'm sending them with the following...

Code: [Select]
$fileatt_type = "application/pdf"; // File Type
It works fine with all formats in older email clients, i.e, like yahoo before they updated the layout, but in the newer versions it's specific and if I try to send it this way it is always delivered as a .PDF and doesn't open if it is any of the other formats.

It may sound silly but I've searched a fair bit for the other extensions or formats to include instead of the above code (maybe something like application/doc or something) but there doesn't seem to be a list.

Can anyone point me in the right direction?

Much obliged, PHP the learned.

Hello,
First post here!

I am using a script to store small files into a database. I know it is not highly recommended but this is the only solution I can find in this case.

All seems fine when inserting but when retrieving all documents are corrupt.

I am working with PHP 5 on Windows server.

Part script after upload: (the document is uploaded to the server first and this is working fine)
Code: [Select]


if (!empty($_FILES)) {

$folder = "kenya/docs_temp/";//including last /
$tempFile = $_FILES['Filedata']['tmp_name'];
$targetPath = dirname(__FILE__);
$targetPath = substr($targetPath,0,strrpos($targetPath, "uploadify")). $folder;


$targetFile =  str_replace('\\','/',$targetPath) . $_FILES['Filedata']['name'];


$fileName = $_FILES['Filedata']['name'];
    $tmpName  = $_FILES['Filedata']['tmp_name'];
    $fileSize = $_FILES['Filedata']['size'];
    $fileType = $_FILES['Filedata']['type'];





$conn=odbc_connect('xxx','xxx','xxxx');


   $content = file_get_contents($tmpName,true);
    $content = addslashes($content);


if(!get_magic_quotes_gpc()){
        $fileName = mysql_real_escape_string($fileName);
     }
                   
    $file_info = pathinfo($_FILES['Filedata']['name']);



$addDoc = "INSERT INTO tblfiles (file_name,file_type,file_size,file_content,file_extension) VALUES ('".addslashes($fileName)."','".$fileType."','".$fileSize."','".$content."','".$file_info['extension']."')";
odbc_exec($conn,$addDoc);


}


The the script to retrieve and output to the browser:

Code: [Select]

$conn=odbc_connect('xxxx','xxx','xxxx');



//get the document
$getF = "SELECT * FROM tblfiles WHERE userId = '".$_GET['userId']."' AND  fileId = '".$_GET['fileId']."'";
$rsF = odbc_exec($conn,$getF);


$size = floor(odbc_result($rsF,'file_size'));
$type = odbc_result($rsF,'file_type');
$name = odbc_result($rsF,'file_name');
$content = odbc_result($rsF,'file_content');


ob_end_clean();
header("Content-length: ".$size."");
header("Content-type: ".$type."");
header('Content-Disposition: attachment; filename="'.$name.'"');
echo $content;





And finally here is the structure for the table:

Code: [Select]
CREATE TABLE `tblfiles` (
  `fileId` int(11) NOT NULL auto_increment,
  `userId` int(11) NOT NULL,
  `file_name` varchar(100) NOT NULL,
  `file_type` varchar(100) default NULL,
  `file_size` int(11) default NULL,
  `file_content` mediumblob,
  `file_extension` varchar(50) NOT NULL,
  PRIMARY KEY  (`fileId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
many thanks for any assistance.