PHP - What's The Best Approach For Reading And Writing Ms Word Doc

Hi, I'm trying to read a MS word doc, I found these code on a blog which uses COM , but when I run this PHP code I get an exception :

"
com_exception Object ( [message:protected] => Source: Microsoft Word
Description: The requested member of the collection does not exist. [string:Exception:private] => [code:protected] => -2147352567 [file:protected] => C:\wamp\www\PhpProject1\index.php [line:protected] => 31 [trace:Exception:private] => Array ( => Array ( [file] => C:\wamp\www\PhpProject1\index.php [line] => 31 [function] => unknown ) ) [previous:Exception:private] => )

"
here is the code

$filename="cv.doc";
$TXTfilename = $filename . ".txt";

$word = new COM("word.application") or die("Unable to instantiate Word object");
$word->Documents->Open($filename);

// the '2' parameter specifies saving in txt format
$word->Documents[1]->SaveAs($TXTfilename ,2);
$word->Documents[1]->Close(false);
$word->Quit();
$word->Release();
$word = NULL;
unset($word);

$content = file_get_contents($TXTfilename);
unlink($TXTfilename);





I read from here  " http://ir2.php.net/manual/en/com.installation.php " that I don't need to install COM but I need to install some COM objects like for MS word doc, but I don't know how to fix it, any idea? thanks in advance

Hi   I come from a desktop (vb.net) background and have used oridinary text files for my databases. I use file locking to prevent other processes from writing to the same file simultaneously.   Now I am moving over the PHP/MySQL - what precautions should I take to stop a simultaneous processes from writing to a table at the same time.?   Do I need to lock the table before writing to it?   Does MySQL deal with this automatically and just block my process until the table becomes free?   (I am talking about a single table here, not multiple dependant tables - I know that is another issue)   Thanks     Nigel

does anyone know how to decode this XML variable value into string values? I also need to know the oposite way: creating variable values into xml. I've tried several code examples but they did filter the requested data.

Code: [Select]
$xml='<?xml version="1.0" encoding="utf-8"?>
<elements>
<text identifier="ed9cdd4c-ae8b-4ecb-bca7-e12a5153bc02">
  <value/>
</text>
<textarea identifier="a77f06fc-1561-453c-a429-8dd05cdc29f5">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>]]></value>
</textarea>
<textarea identifier="1a85a7a6-2aba-4480-925b-6b97d311ee6c">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy  eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed  diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum.  Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor  sit amet.</p>]]></value>
</textarea>
<image identifier="ffcc1c50-8dbd-4115-b463-b43bdcd44a57">
  <file><![CDATA[images/stories/red/cars/autobedrijf.png]]></file>
  <title/>
  <link/>
  <target/>
  <rel/>
  <lightbox_image/>
  <width><![CDATA[250]]></width>
  <height><![CDATA[187]]></height>
</image>
<text identifier="4339a108-f907-4661-9aab-d6f3f00e736e">
  <value><![CDATA[Kramer 5]]></value>
</text>
<text identifier="ea0666d7-51e3-4e52-8617-25e3ad61f8b8">
  <value><![CDATA[6000 RS]]></value>
</text>
<text identifier="90a18889-884b-4d53-a302-4e6e4595efa0">
  <value><![CDATA[Eindhoven]]></value>
</text>
<text identifier="410d72e0-29b3-4a92-b7d7-f01e828b1586">
  <value><![CDATA[APK Pick up and return]]></value>
</text>
<text identifier="45b86f23-e656-4a81-bb8f-84e5ea76f71f">
  <value><![CDATA[15% korting op grote beurt]]></value>
</text>
<text identifier="3dbbe1c6-15d6-4375-9f2f-f0e7287e29f3">
  <value><![CDATA[Gratis opslag zomerbanden]]></value>
</text>
<text identifier="2e878db0-605d-4d58-9806-8e75bced67a4">
  <value><![CDATA[Gratis abonnement of grote beurt]]></value>
</text>
<text identifier="94e3e08f-e008-487b-9cbd-25d108a9705e">
  <value/>
</text>
<text identifier="73e74b73-f509-4de7-91cf-e919d14bdb0b">
  <value/>
</text>
<text identifier="b870164b-fe78-45b0-b840-8ebceb9b9cb6">
  <value><![CDATA[040 123 45 67]]></value>
</text>
<text identifier="8a91aab2-7862-4a04-bd28-07f1ff4acce5">
  <value/>
</text>
<email identifier="3f15b5e4-0dea-4114-a870-1106b85248de">
  <value/>
  <text/>
  <subject/>
  <body/>
</email>
<link identifier="0b3d983e-b2fa-4728-afa0-a0b640fa34dc">
  <value/>
  <text/>
  <target/>
  <custom_title/>
  <rel/>
</link>
<relateditems identifier="7056f1d2-5253-40b6-8efd-d289b10a8c69"/>
<rating identifier="cf6dd846-5774-47aa-8ca7-c1623c06e130">
  <votes><![CDATA[1]]></votes>
  <value><![CDATA[1.0000]]></value>
</rating>
<googlemaps identifier="160bd40a-3e0e-48de-b6cd-56cdcc9db892">
  <location><![CDATA[50.895711,5.955427]]></location>
</googlemaps>
</elements>';

I am wanting to make a product list page with PHP.

At the moment I using this code:
Code: [Select]
$query = "select * from products where category = 'Belts'";
$result = mysql_query($query);
while($row=mysql_fetch_assoc($result)) {
echo $row['name'];
}
The result is something like this:
http://i51.tinypic.com/2w56ljq.png

What I want is for them to be aligned like this:
http://i53.tinypic.com/w811tz.png

Eventually, I am also going to include an image with each product.
How would I go about alignment? With CSS or PHP?

Hi everyone,   So I'm relatively new to OO PHP and moreover, OO PHP with MVC design pattern.   This may be a largeish post so please bear with me on this one!   So here is a scenario that I'd like to understand. There are likely multiple ways to go about this, but it'd be nice to see what is said. I'll include what I think should be the solution here and hopefully i'll get some feedback about it.   Scenario: A page needs to display a list of "parts" for a car. A database table already exists with these parts. The list of parts on the page need to be ordered by name on first load, but then can be re-ordered by users using a drop down list. They can also be filtered, and searched.   A page also exists to display a single car part.    What I think should be, and what i'm struggling with:   Model: I will have a "part" object which represents an individual car part. The part object will use a database abstraction layer. On "new Part()" will generate an empty object. ->Load( id ) will load an individual part.   Controller:   I do not know how I would implement this. I know it would contain methods to Filter(), Search() and Order() and that would directly access the Model.   View:   I am lost here too, I need to display a list of car parts, and on another page, a single car part. I understand I should use the same Model for both. However I do not see how I would list the parts.      Some Questions:   Should I have another "model" that is a list of the "Part" model called PaetListModel, or should "Part" be able to generate that list? I clearly should have 2 views, one for singular part, one for list of parts. Should the view access the model to generate the list before using the data for output? Should the controller be used in the view instead of the model to generate the initial list (or singular) on page load? Should the filter functions in the controller reload the "PartsList" from wherever our list is stored?    I think the most important question for me though is:    How would YOU implement the above green scenario?    I would like to learn from peoples examples so I get an idea of what road to follow

I'm looking for some direction as I approach a new challenge.

I have a table named friends_and_family and it contains name, email, and age fields.

I'm planning a party and want to invite 10 of the people that are between 20 and 35 years old.

The format I am considering would query the table and provide a list of those members that fit the age requirement.

I would like to generate that result (which I should be capable of handling) so that each person listed has a checkbox next to their name.

I imagine I will be creating a resultant form, so that I can then evaluate the result and select the checkboxes for those specific people that I want to invite.

Upon submission, an email will be sent to the people with selected checkboxes.

How should I approach this best?

A for each loop? Implode an array? 

I'm not very good with AJAX, so I'm thinking along these lines.

 

 

Hello everyone,

I am new to php and I need a confirmation if this is the correct approach for a code I wrote. Basically, I have a contacts.php page where I have a bootstrap table and a modal with some fields to add a new contact. I managed to write all the code, it works perfect but I want to know if this approach is ok.  The application will be much more complex and I don;t want to start on the wrong foot here. I have 2 files: contacts.php and add_new_contact.php.

First file, contacts.php:

<!DOCTYPE html>
<html lang="en" dir="ltr">
  <head>
    <!-- ............ -->
   </head>
  <body>
    <!-- ............ here is the page layout-->
    <!-- Then I have my modal from bootstrap -->
    
	<div class="modal fade" id="addContact" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
       <form action = "add_new_contact.php" method="post">
         <!-- .....content with all the inputs -->         
       	<button type="submit" class="btn btn-primary">Save to database</button>
    	</form>
    </div>
    
   </body>
</html>
    

Now, in form action I am telling html to go to add_new_contact.php where I wrote the code for inserting all the values to the database. When doing this, it opens the page and it stays blank because there is no html there. So, in that php file I added a redirect code to the initial contacts.php. Here is the code:

Second file: add_new_contact.php:

<?php
	//all the code needed to insert the contact in the database

	header("Location: http//..../contacts.php");
  	exit();
?>

So, this works fine. But is this the best way to do it?

Thank you.

So, I'm starting a new project and thought I would try a new approach at loading files and classes to process output.  I think my logic is correct, but for some reason I'm getting a blank page.  Basically instead of having seperate pages to output different functions and such, I store everything in one page.  It's the same deal as the switch case approach, but it uses a foreach loop to cycle through the actions, classes, and functions which are stored in an array.

Here's my index.php file:
Code: [Select]
<?php

require('config.php');
include('languages/english.php');
include('classes/Template.php');

$template = new Template;

$viewPages = array( 
'category' => array('classfile' => 'Category.php', 'classname' => 'category', 'functions' => array('create', 'delete', 'modify', 'merge')),
'questions' => array('classfile' => 'Question.php', 'classname' => 'Question', 'functions' => array('create', 'delete', 'modify', 'votegood', 'votebad'))
);


$currentPage = $_REQUEST['action'];

foreach($viewPages as $action => $settings){

if($currentPage == $action){
require(INCLUDE_ROOT.'/classes/'.$settings['classfile']);

$class = new $settings['classname'];
$function = $_REQUEST['do'];
$class->$function();

$template->loadTemplate($settings['classname']->viewFile, $vars = array());
if($template->message == FALSE){
die($template->message);
}

}

}

?>
Here's the Template class file:
Code: [Select]
<?php

class Template {

var $file;
var $vars;
var $message;

function loadTemplate($file, $vars){

if(empty($file) || empty($vars)){
$this->message = LANG_ERR_7;
} else if($file = file_get_contents(INCLUDE_ROOT.'/'.$file)){
$this->message = LANG_ERR_7;
} else {
foreach($vars as $key => $val)
$file = str_replace('{'.$key.'}', $val, $file);
}

$this->message = FALSE;
return $file;

}

}

?>
I tried visiting the category action(index.php?action=category;do=create).  This is the classfile for that
Code: [Select]
<?php

class category {

var $id;
var $title;
var $description;
var $uri;
var $message = array();
var $vars = array();
var $viewFile = '';

function create(){

if($_POST['submit']){

//Review the user input and make ure everything is ok
$messages = array();
if($this->title == FALSE){
$messages['title'] = LANG_ERR_1;
} else if(strlen($this->title) > 30 || strlen($this->title < 5)){
$messages['title'] = LANG_ERR_2;
} else if($this->description == FALSE){
$messages['description'] = LANG_ERR_3;
} else if(strlen($this->description) > 400 || strlen($this->description) < 10){
$messages['description'] = LANG_ERR_4;
} else {
$messages = FALSE;
}

if($messages != FALSE){
$this->messages = $messages;
$this->viewFile = INCLUDE_ROOT.'/template/index_body.tpl';
} else {
$this->title = htmlentities($this->title);
$this->title = stripslashes($this->title);
$this->title = htmlspecialchars($this->title);

$this->description = htmlentities($this->description);
$this->description = htmlspecialchars($this->description);
$this->description = nl2br($this->description);

$query = "
INSERT INTO categories
(c_title, c_desc)
VALUES('".$this->title."', '".$this->desscription."')";

if(mysql_query($query)){
$this->message['succes'] = LANG_ERR_5;
} else {
$this->message['fail'] = LANG_ERR_6;
}

$this->viewFile = INCLUDE_ROOT.'/template/message_body.tpl';

}

} else {

$this->viewFile = INCLUDE_ROOT.'/template/create_category.tpl';

}

}

}

?>
Now if you look at the Category class, the template file it sets is the "category_create.tpl" file, which I haven't created yet.  I'm expecting there to be an error associated with the template class and the file_get_contents function that calls the file, but like I said, I'm just getting a blank page.

I've never tried this approach before, so I have no idea what's causing this.  Any help would be greatly appreciated.

Hi Guys,   Greetings! Co - PHP freaks! I was hired by a company that requires me to create a purchase department program that will generate Quotations, P.O. , Receipt All of the database of this program will be stored to a server computer in a single office and all of the computer has a software that will access the data and should be able to generate a printable file like PDF or something. What is the best approach for this? any suggestions? I appreciate it in advance.     Cheers,

MrGhaia

I currently use HTML strings within my PHP code to display output. And while it might not be best practice, I find it non-restrictive and I can easily add loops, manipulate variables, etc. within my display.

However in the interest of having a cleaner code I'm thinking of separating the HTML, without having to use a Template engine like Smarty.

I don't care much about replacement patterns to be honest, I don't mind some PHP code withing the HTML, however my biggest issue is loops and having to modify a variable within each loop. Say I have the following example code (Similar to what I'm using right now):

Code: [Select]

function student_output() {

    //Retrieve students from array
   $students_arr = students_info();

    $selected_student = $_GET['selected_student'];

    $output = '<div id="students_container">';
    $output .= '<div class="items_list">';

    $i = 1;

    //Loop through students
    foreach($students_arr as $key=>$value) {

if ($selected_student == $key) {
    $output .= '<div id="student_name_'.$i.'" class="selected">'.$value['student_name'].'</div>';
            $output .= '<div id="student_img_'.$i.'" class="selected"><img src="'.$value['student_image'].'" /></div>';
}
        else {
            $output .= '<div id="student_name_'.$i.'">'.$value['student_name'].'</div>';
        }

        $i++;

    }

    return $output;
   
}   


What's the best way to represent this in HTML cleanly without having too much PHP code within?

All good with sending single dimensional form data to the server using application/x-www-form-urlencoded, and having PHP convert it into an array.  Also, good with sending simple arrays using [].  But then I find myself needing to send a deeper object to the server .  For example, I have a form with three text inputs simpleFormName 1, 2, and 3 plus some deeper object.

Array
(
    [simpleFormName1] => bla
    [simpleFormName2] => bla
    [simpleFormName3] => bla
    [deeperObject] => Array
        (
            [0] => Array
                (
                    [prop1] => bla
                    [prop2] => true
                    [data] => Array
                        (
                            [0] => Array
                                (
                                    [p1] => 321
                                    [p2] => 123
                                )

                            [1] => Array
                                (
                                    [p1] => 121
                                    [p2] => 423
                                )

                            [2] => Array
                                (
                                    [p1] => 221
                                    [p2] => 133
                                )

                        )

                )

            [1] => Array
                (
                    [prop1] => blabla
                    [prop2] => false
                    [data] => Array
                        (
                            [0] => Array
                                (
                                    [p1] => 222
                                    [p2] => 443
                                )

                            [1] => Array
                                (
                                    [p1] => 321
                                    [p2] => 213
                                )

                            [2] => Array
                                (
                                    [p1] => 111
                                    [p2] => 421
                                )

                        )

                )

        )

)

 

I see at least four options:

Come up with naming structure which "flattens" the data.  I have used this approach in the past, but it quickly becomes difficult to manage and I don't want to do so. Not use PHP's POST and and instead use Content-Type: application/json and file_get_contents(php://input) and json_decode the entire request server side. Use PHP's POST and urlencoding but make deeperObject a string using JSON.stringify and json_decode this one field server side. Urlencode the entire object.

simpleFormName1=bla&simpleFormName2=bla&simpleFormName3=bla&deeperObject%5B0%5D%5Bprop1%5D=bla&deeperObject%5B0%5D%5Bprop2%5D=true&deeperObject%5B0%5D%5Bdata%5D%5B0%5D%5Bp1%5D=321&deeperObject%5B0%5D%5Bdata%5D%5B0%5D%5Bp2%5D=123&deeperObject%5B0%5D%5Bdata%5D%5B1%5D%5Bp1%5D=121&deeperObject%5B0%5D%5Bdata%5D%5B1%5D%5Bp2%5D=423&deeperObject%5B0%5D%5Bdata%5D%5B2%5D%5Bp1%5D=221&deeperObject%5B0%5D%5Bdata%5D%5B2%5D%5Bp2%5D=133&deeperObject%5B1%5D%5Bprop1%5D=blabla&deeperObject%5B1%5D%5Bprop2%5D=false&deeperObject%5B1%5D%5Bdata%5D%5B0%5D%5Bp1%5D=222&deeperObject%5B1%5D%5Bdata%5D%5B0%5D%5Bp2%5D=443&deeperObject%5B1%5D%5Bdata%5D%5B1%5D%5Bp1%5D=321&deeperObject%5B1%5D%5Bdata%5D%5B1%5D%5Bp2%5D=213&deeperObject%5B1%5D%5Bdata%5D%5B2%5D%5Bp1%5D=111&deeperObject%5B1%5D%5Bdata%5D%5B2%5D%5Bp2%5D=421

Any recommendations how to best implement?  If you recommend using urlencoding for simple forms, but some other approach for more complex data, what criteria do you use to transition from one approach to another?

Thanks

I have good knowledge of HTML, Css, Php and mysql, i would want to know, the best approach to creating an online dating site. any help 

hello dear community,

i am currently wroking on a approach to parse some sites that contain datas on Foundations in Switzerland
with some details like goals, contact-E-Mail and the like,,,

See http://www.foundationfinder.ch/  which has a dataset of 790 foundations. All the data are free to use - with no limitations copyrights on it.

I have tried it with PHP Simple HTML DOM Parser - but , i have seen that it is difficult to get all necessary data -that is needed to get it up and running.

Who is wanting to jump in and help in creating this scraper/parser.   I love to hear from you.

Please help me - to get up to speed with this approach?


regards
Dilbertone

I am trying to wrap my head around the best approach to accomplish this.   I am trying to come up with a random schedule for a full 24 hour day with random time periods ranges including breaks. The only constants will be the minimum time and maximum time of the events and the minimum and maximum time of the breaks between each event.   for example There are three teams Team A Team B Team C   Each event will last either a minimum of 7 minutes to a maximum of 38 minutes The breaks will last a minimum of 30 seconds to a maximum of 5 minutes.   so the events need to be generated randomly with a break period following each event and the timelines are different for each team with the current event time left going to  a timer on the page   I think I have the part to generate the random blocks figured out by using 

<!DOCTYPE html>
<html>
<body>
<?php
function eventRange($min, $max, $blocks) {
    $events = range($min, $max);
    shuffle($events);    
    return array_slice($events, 0, $blocks);
    
}

function breakRange($min, $max, $blocks) {
    $breaks = range($min, $max, 0.1);
    shuffle($breaks);    
    return array_slice($breaks, 0, $blocks);
    
}
echo"<pre>";
print_r( eventRange(7,38,32) );
echo"</pre>";

echo"<pre>";
print_r( breakRange(.5,5,32) );
echo"</pre>";

?>
</body>
</html>

bur is there a way to make it fill a full 24 hour period and then a way to determine which block to display based on the current time when either team is viewing the page.   Sounds totally confusing to me as I try to explain it so I hope what Im asking makes sense. Thanks for any guidance..          

good evening dear Community, 

Well first of all: felize Navidad - I wanna wish you a Merry Christmas!!

Today i'm trying to debug a little DOMDocument object in PHP. Ideally it'd be nice if I could get DOMDocument to output in a array-like format, to store the data in a database!

My example: head over to the url -
see the example: the target http://dms-schule.bildung.hessen.de/suchen/suche_schul_db.html?show_school=8880   

I investigated the Sourcecode:

I want to filter out the data that that is in the following class <div class="floatbox">

See the sourcecode:


<span class="grey"> <span style="font-size:x-small;">&gt;</span></span>
<a class="navLink" href="http://dms-schule.bildung.hessen.de/suchen/index.html" title="Suchformulare zum hessischen schulischen Bildungssystem">suche</a>
              </div>
            </div>
          <!-- begin of text -->
           <h3>Siegfried-Pickert Schule</h3>
 <div class="floatbox">



See my approach: Here is the solution return the labels and values in a formatted array ready for input to mysql!

<?php

$dom = new DOMDocument();
@$dom->loadHTMLFile('http://dms-schule.bildung.hessen.de/suchen/suche_schul_db.html?show_school=8880');
$divElement = $dom->getElementById('floatbox');

$innerHTML= '';
$children = $divElement->childNodes;
foreach ($children as $child) {
$innerHTML = $child->ownerDocument->saveXML( $child );

$doc = new DOMDocument();
$doc->loadHTML($innerHTML);
//$divElementNew = $dom->getElementsByTagName('td');
$divElementNew = $dom->getElementsByTagname('td');

    /*** the array to return ***/
    $out = array();
    foreach ($divElementNew as $item)
    {
        /*** add node value to the out array ***/
        $out[] = $item->nodeValue;
    }

echo '<pre>';
print_r($out);
echo '</pre>';

} 



well Duhh: this outputs lot of garbage. The code spits out a lot of html anyway.
What can i do to get a more cleaned up code!?

What is wrong with the idea of using this attribute:

 $dom->getElementById('floatbox');

any idea!?

any and all help will greatly appreciated.

season-greetings
db1