Can I Convert MySQL Db Records Into Microsoft Word Documents?
i found the solution to export
file from mysql db into *.csv. but is there anyway to convert the
contents into *.doc and save in my webserver and providing a link for
the end users to download the word file?
FYI, the database records are obtained by end users submitting the
forms themselve and i saved it in my db...
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Reading Microsoft Office Documents?
I need to be able to upload a Microsoft office document and then show the contents to the visitor, in addition i need to be able to write documents on the fly. Is there a way of doing this, or will i have to spend days researching and programming my own classes to handle it?
View Replies !
View Related
How To Create Microsoft Office Documents
I would like to use php to view, edit, and create Microsoft office Documents such as .doc, .xls, and .ppt using only php. In addition I would like to open these documents within a web browser and not the program itself. I googled and this is the best site that offer the most information, http://web.informbank.com/articles/t...-documents.htm All of the code does run error proof, but some work for example creating a word document and it doesn't have the functionality I am looking for. If you have any suggestions or can direct me to a tutorial on this subject, it will be of great help and appreciation.
View Replies !
View Related
MS Word Documents
I've been asked to write a script to upload Microsoft Word documents and then convert them into 'printer friendly' pages. The uploading part I've got no problem with, but I can't find anything about reading MS word docs into PHP. Does anyone know anything about this? I hope it's not as difficult as excel documents - which I'm still trying to get working on and off without any real success.
View Replies !
View Related
Word (or Other Documents) To PDF On The Fly?
Is there an option to convert any (or mosts file types) a user might upload to PDF format upon upload? I'd like users to be able to upload Word, Excel, Text and other documents, then have our upload script convert the document to PDF on the fly. Then viewing users would simply need the acrobat reader to view files, not all these other office products. Is this possible with just PHP and pdflib for example? If not, what are the options?
View Replies !
View Related
Upload Word Documents
Im want to be able to upload word documents and im using the script below. However its not working and the error message shown below is displayed. Whats wrong? This is the HTML for the form: Code:
View Replies !
View Related
Uploading Word Documents
I'm working on a system that is going to require users to be able to upload word documents. Are there any other considerations i should be taking into account here rather than just problems with viruses within the file?
View Replies !
View Related
PHP And Microsoft Word
I have users who can sent a Word document as an attachment to an email from a Microsoft-rich environment. I would like to be able to "capture" that attachment as a blob and deposit it into a mysql database. I am not sure how to do the capture.
View Replies !
View Related
Microsoft Word
I have an interface which allows people to manage and add customers. Each customer also has a category, for example 'Builders' I need a way of being able to do a mail merge to all clients with a selected category which is initialised from the web interface. For example, at the moment I can connect to MySQL and get all customers and if I go slightly further I could create a filter to do just what I need from within word. However, I need to be able to have the user choose which category from within their browser then click a button and it automatically does this filter. I was thinking maybe somehow I could export all users in a category to a CSV file and then have a mail merge doc setup which automatically pulled data from this each time the document was loaded - this would be OK I suppose if a word file could be opened which automatically had the desired filter.
View Replies !
View Related
Modifyinf Word Documents Using COM Extension
I'm working on a projet in which I need to personalize Word documents by adding data from a mySQL base, the aim beeing to print the resulting document on the fly. On this site I've read Khairul Amri Yunus's article on the subject : looks simple, but ... What is the COM extension he's talking about ? Is it a php extension ? Where can I find it ? Well, I'm not that used to php install stuff and am feeling a bit lost !
View Replies !
View Related
Converting .doc Microsoft Word
I have searched this form for this but was not able to find a clear answer for this. Is it possible to convert Microsoft Word ( .doc ) files to any other manupulatable format like txt, XML, HTML etc. I came across a script from phpclassess.org for doing this but it requires dom which requires windows which is not feasible for developement envionment.
View Replies !
View Related
Mail Merge Microsoft Word PHP
I have a database with patients name and address and i would like to send them letters. I would like to, from the click of a button, use php to retrieve the names and addresses, open microsoft word template, use mail merge and print out the letters.
View Replies !
View Related
Inserting Records Into A Microsoft Access Database...
I'm still new at using PHP although thanks to these forums I'm learning quite a lot. Currently, I am trying to insert a new record into my access database. I can display records from it but not add new ones. I know that I am to use the 'INSERT' SQL function but how would an Access Database be different from mySQL? So far I've seen only mysql examples and havent been able to find anything on access...
View Replies !
View Related
Convert Word .Doc To PDF
Right now I am doing a website which could read a .doc file and convert that to pdf file. I just started, so...I did some google search but cant find any good solutions. The PHP inherent pdf library or other things as FPDF can only create or modify pdf files but not for convertion (expecially not for a windows word file conversion)... Is there any idea on how to do that? Besides, I am pretty new in the PHP field, but I have some programming expericen before(mostly C or Cplus). Is there any good tutorials or stuff you guys recommend?
View Replies !
View Related
Dynamically Convert WORD To PDF
I am working on a site where my friend would like her customers to be able to upload a word document, and this would be converted on the fly / server side into a PDF file. I have to say, I am baffled by this as both applicatiuons are desktop applications and I can't see how this could be done. Not much luck searching google or forums up to now. Is there any php application anyone is aware of, or anyway you can think of achieving this?
View Replies !
View Related
Convert MS Word / Rtf / ... To Plain Text
i'm looking for standalone libraries that convert documents to plain text so i can let people edit the text in a textarea after uploading. One thing to notice is that i can not use COM because i can't configure the webserver. Does anyone has interesting classes that are able to do this. I found a PHP class for ms word documents at http://obninsk.name/obninsk_doc/ but that doesn't work at all for my word documents.
View Replies !
View Related
Convert Word File To HTML
I have an idea that allow people upload MS Word file including Image and so on and then I will store it and view as HTML format; I just use function convert into HTML in MS Word but it's not good and sometime the HTML code display bad in web browser like FireFox And I wanna instroduce it here and need ather ideas.
View Replies !
View Related
Convert Records From Database To Array
I read 10 lines of data from the database and I'd like to put it in an array. My problems are: (1) if the way of putting values inside an array is like this : $arr = array(1 => "string1", 2 => "string2", 3 => "string3"); or $arr = array("string1", "string2", "string3"); then how can I insert the values inside an array coming from : while(list($stringdata)= mysql_fetch_row($result)) { --------------------- }
View Replies !
View Related
SQL Error: [Microsoft][ODBC Microsoft Access Driver] Too Few Parameters
I'm trying to execute the following SQL statement and get the following error. SELECT DomainNames.DomainName FROM DomainNames WHERE DomainNames.DomainName Like "*ab*" ORDER BY DomainNames.DomainName SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect I'm running PHP4, Apache 1.3.12 (Win32) and connecting to an Access database on a Win2K box.
View Replies !
View Related
Odbc_exec(): SQL Error: [Microsoft][ODBC Microsoft Access Driver]
i am trying to write to the database through odbc. i get the following error: Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in c:inetpubwwwroot514VIP_SurveyProcess.php on line 41 my directory has read/write permissions why am i getting this? here is the code as an example: ... $x = 10; $querySet = "UPDATE Survey SET $rdoOption = $x"; odbc_exec($objConn, $querySet); ...
View Replies !
View Related
Use A Microsoft SQL Database Using PHP Compared To MySQL?
I have only ever used MySQL with PHP but have been asked by a cleint if I would be able to develop a website and import data from an existing database that is updated by bespoke software that they have purchased and runs on their desktop machines (but the database is on a remote server). I guess what I am asking is how easy is it to use a Microsoft SQL database using PHP compared to MySQL?
View Replies !
View Related
Mysql Start Of Word
anyone know how to search for something starting with a number in mysql? and is there a way to find something starting with a symbol? I have this, which doesn't work: users.displayName LIKE '0-9%' but these work individually: users.displayName LIKE '0%'users.displayName LIKE '1%'users.displayName LIKE '2%'and so on, but that doesn't work for me, I need to have it so it will find everything starting with a number on the first search, same thing with symbols.
View Replies !
View Related
Updating Word/excel Thru Mysql
I'm working on a project which has all data in a mysql database. i have set up forms for various inputs etc and all is well. Now comes a problem - atleast for me. There are some files in excel and word and these are updated by some users when an event takes place as under: a. user visits a customer site to check work in progress. b. he prepares a pre -install report which is an excel file. Code:
View Replies !
View Related
Convert To MySQL
Got this code in MSSQL: Code: update games set visitorscore = :visitorscore homescore = :homescore where gamenum = :gamenum and ((teamnum in ( select homeid from games where gamenum = :gamenum ) ) or (teamnum in ( select visitorid from games where gamenum = :gamenum ) ))
View Replies !
View Related
PHP/MySQL Records Per Row
Is there any way to have the records pulled from a mysql database display like this in a table: record1 | record2 record3 | record4 etc: I've been thinking about this for about three months and have yet to come to a good solution.
View Replies !
View Related
Parse Out Word's Autocode Without Having To Modify The Word-created File?
I am in the process of designing a website for a client who insists on using Microsoft Word to edit their pages. I'm using PHP for the layout, and including the Word-created htm files within the design. The problem is, some of Word's autocode shifts the included htm file's text a few lines lower than it should be, making the layout look odd. Is there a simple way to parse out Word's autocode without having to modify the Word-created file?
View Replies !
View Related
Word Doc Stored As BLOB In MySQL - Retrieval ?
I've stored a word doc as a LONGBLOB in MySQL. To retrieve the contents of the file, I have a script which creates a temporary file, writes the contents to the file, then auto-redirects the browser to the .doc file; the browser then prompts the user to download the file. The original .doc, which was uploaded to MySQL and the .doc downloaded from the temp file are the exact same size. However, MS Word won't open the downloaded .doc file, saying that "The document name or path is not valid" Anyone else run into this problem getting Word docs from MySQL?
View Replies !
View Related
Need To Convert Mysql To Excel?
I need to display data from MySQL to Excel format. I looked at several excel classes, but they are missing three things that I need. 1. To be able to output a cell larger than 255 characters. 2. Be able to keep line breaks in cells. 3. be able to format the cell widths I am currently using a tab delimited set up with excel http headers, but I can not format the cell widths.
View Replies !
View Related
Convert MySQL Results To XML
I just got Dreamweaver CS3, and I love the built in SPRY framework. It allows you to create web applications that use a table listing, and details listing very quickly. Unfortunately the only data the SPRY framework can accept is XML. Is there a built in function to convert from a $row result from MySQL to XML? Code:
View Replies !
View Related
From ODBC Convert To MYSQL
I can't find a DB area. I created a site in PHP using ODBC and now wish to convert to MYSQL. I extracted my MS DB as a .sql file and imported it into MYSQL. Does MYSQL use the likes of primary keys and relationships? If so, will the relationships i set in microsoft access be carried to MYSQL?
View Replies !
View Related
Convert Csv To Mysql Online
I need users to be able to upload a csv file with 1 column, just names. I need to be able to write all this data to the database. Does anyone know where to start, or if there is a script already developed to do this?
View Replies !
View Related
Convert Mysql Date
I am Using the following function to convert mysql date format into my req. function date_convert($date){ $date_year=substr($date,0,4); $date_month=substr($date,5,2); $date_day=substr($date,8,2); $date=date("F jS, Y", mktime(0,0,0,$date_month,$date_day,$date_year)); return $date; } echo date_convert($row['date']); //// $row['date'] is in the form :September 11, 2007.
View Replies !
View Related
|
TRACKER
