Exporting Information From Entourage To A Website.
I have this new website for a client, it has a calender which shows events from a mysql database but they don't want to have to update the information to it manually.
What they are using is a program called Microsoft Entourage. What are the possible ways for me to be able to get that information every 1 hour and get it into a database?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Exporting Database To Excel (via Website, NOT PhpMyAdmin)?
I know via phpMyAdmin I can export my database in Microsoft Excel 2000 format, and can check a box to 'Create field names as first row', but it doesn't give me the php code used to achieve this. I need to have a page on a website so the administrators will be able to do this for themselves, does anyone know if this is possible?
Website And Tracking Information
i need some information on how you guys would go about making a website that could give you information based on a number you put it. This information will be tracking information on a particular package. The number will be a given number that corresponds with that package. Basically, all the files are dbase files that need to be converted into something readable. I then need to be able to use php or something to search through the readable information from the dbase file and then put it on the screen for the user looking for the tracking information. How would you go about this.
Change Website To Php,mysql Data-driven Website
At the moment this site is not completely php. How can I make the content of the pages be from a mysql database? and how do I make the nav buttons work correctly connecting to the mysql database and displaying the correct content, ?
CSV Exporting
I created the csv file, but it only shows the last record in my db. How can I make it show all of the records? Here's the code:
Exporting A Database
developed a php project using mysql as the database.i work on a win-nt machine....how do i export my database to the host server which runs linux???
Exporting To An XML File
I grabbed a web page and had it extract only the links between certain line numbers. Now I want to take that output and export it to an XML file in a format of my choosing. For example: <a href="mysite.com">This is my site</a> Would export to: <link>mysite.com</link> <description> This is my site </description> I will then take that XML file and output it as HTML, however I already have this bit accomplished.
PHP Exporting To Quickbooks
I am working on a web-based payroll application (PHP/MySQL of course) that needs to be able to dump each employee's information in to a Quickbooks formatted file for payroll processing. I have done this several times exporting to a tab/comma deliminated text file (usually MS Excel), but I was wondering if anyone could see any reason why it could not be done the same way (assuming that Quickbooks uses a a tab/comma file structure) for Quickbooks??? If it can be done would I use the same mechanics as I would for Excel (changing the file type meta tag)?
Database Exporting
Quite by accident, I found the mysqldump utility, that comes with MySQL, which dumps/backsup a database, table, or record. It looks very versatile! Does PHP have a way to export records of a MySQL database? Anything that does the same independent of the database used?
Database Exporting
As part of the CMS that I've written, I would like to give users the ability to backup their own databases. Is there any way that this can be done with PHP? What I'd like is for them to click a link and for it to create a txt file and open the "Save as" dialog box so that they can save it off to their hard drive.
Exporting Csv File
I'm having issues getting all the information from 3-4 databases into one csv file.. What easy thing am I missing this time? header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=export.csv"); header("Pragma: no-cache"); header("Expires: 0"); $select = "SELECT * FROM ordersCopy O, orders_products P, orders_total Q WHERE O.orders_id=P.orders_id OR O.orders_id=Q.orders_id AND orders_status=Ɖ'"; $export = mysql_query($select); $count = mysql_num_fields($export); for ($i = 0; $i < $count; $i++) { $header .= mysql_field_name($export, $i)." "; } while($row = mysql_fetch_row($export)) { $line = '' foreach($row as $value) { if ((!isset($value)) OR ($value == "")) { $value = " "; } else { $value = str_replace('"', '""', $value); $value = '"' . $value . '"' . " "; } $line .= $value; } $data .= trim($line)." "; } $data = str_replace(" ", "", $data); if ($data == "") { $data = " (0) Records Found! "; } print "$header $data";
Exporting Mysql
there is a function in phpmyadmin that exports all the data etc from a mysql database to an sql text document, or Excel File. I would like to know if there is an inherent way of doing this without phpmyadmin. - straight through php.
Exporting From MySQL To .csv Using PHP
I'm sort of new to PHP. I am using the following code to retrieve a column from a database and to put all of the results into a .csv file. This allows creates a .csv file, but only lists the first result from the database. It is not returning all of the rows. I know the issue is somewhere in my "foreach" but I'm not sure where. <?php $selectSql = "SELECT artist_name FROM lounge_products"; $selects = $db->getAll($selectSql); foreach($selects as $select) { $content = $select[artist_name].","; } Header("Content-Disposition: attachment; filename=export.csv"); print $content; ?>
Exporting To Excel
I followed the really cool how to at http://www.phpfreaks.com/tutorials/114/0.php but I had to change some things to get it to stop giving me errors. After I did that It seemed to work great but it put everything into one cell in the excel document. Code:
Exporting MySQL Table
Hi, How do you export a MySQL table to a tab-delimited text file so I can put it into excel?
Exporting To Microsoft Access
I have a PHP website with a mySQL database and a client wants to be able to see the database on his computer using Microsoft Access. I would like to be able to make a special backdoor section for him, where he enters his username and password and is given a link which will make take a snapshot of the mySQL database and convert it to a Microsoft Access database which he can download to his computer. Is this possible? Since he isn't very computer savvy I need a way as user friendly as possible to let him download the database and view on his local computer.
Exporting Mysql To Csv Or Excel Via PHP
Hi, I need to know how to write a php code how to export the mysql database into CSV or Excel or ISO 20001 format. or if you know any tutorial site for it.
Exporting Data To MS Excel
How to export data to xls file using PHP? Is it possible to edit a look of document (like cell size, borders etc.) ?
Exporting From Db To Text File
I have the following sql statement that works from phpmyadmin and from the MySQL command line, but not php. The resultant $sql variable is the following: $sql=select logrecno, county, sumlev into outfile "/tmp/census.txt" fields terminated by ',' lines terminated by "" from sf1_msageo where sf1_msageo.county=97 and sf1_msageo.sumlev=140 $result=mysql_query($sql); The query executes, returns no messages, and does not create a file. Any idea as to what I'm doing wrong?
File Exporting To Excel
This code exports data from my DB into an Excel file by using " " as the delimiter. It runs through the script over and over until it's done creating an Excel file with columns of data, but is there a way that I can add a value to the beginning of the script - thereby naming the columns? Code:
New Exporting / Getting News From Different Server
Which is the best way to fetch news from my server and display it on other sites. I have an admincp i would like to display announcements in from my site. Maybe just some how remotly including a file from my server or something.
Exporting MySQL Database To File Using PHP
I want to export my database to a file that is hosted on the same server. I got this script from somewhere, but it doesnt work. Most likely because I cannot access mysql command thru the shell_exec() command, however, I am able to use the wget command thru the shell... Here's the code I was trying to use:
Exporting Search Results To A CSV File
I am about to start programming up a database, where the client requies the data exported to a CSV file for use in mail merge documents etc. What I would like to know is, if they run a query on the database, and only export five of the 10 fields in the table to the list, how would I go about reatining the field names on the first line of the CSV file?
Exporting Mysql Data To CSV In Php Code!!
how can i export the results of a query to a csv file with the columns name in the filed name of the csv???suppose USERID is the 1st column the USERID should be named in A in CSV while its data is under of it??is it possible?
BBCode Parsers And Exporting Text From A DB
I'm currently working on a simple (at least I had hoped) script to pull posts from a single "news" forum from phpbb and importing it on the front page of my site. It works great except for the BBCode issues. It doesn't keep line breaks (biggest concern) as well as text colors, urls, etc (which was expected). Talking with a friend, he tells me that I'm going to have to insert some BBCode parser to make things work right. I have 3 questions regarding this: 1) is that my only answer? 2) should I try to use the phpbb BBCode parser that the forum uses? 3) should I install a custom BBCode parser instead? I did not want to use a portal because they were just over bloated for what I needed and that was simply the posts from the forum itself w/o all the extras like who's online, last post made on the forums, etc. Would it just be easier to try to strip down something like EZportal to just the info I need instead of trying to use this custom script?
Problems While Exporting Data Using Pipe Symbols
I am facing problems while trying to export data into pipe format. In fact I am fetching records from mysql database and then trying to create a text file ( using pipe as delimeter) , intending to open in Excel. The data is been inserted from textarea fields, where the user can write text and may press enter key to format his text accordingly. Now when the data entered into the database it keeps some unidentified value so as to keep the formatting. Hence while displaying the text file I find that lines are seperated according to the format user gave. Thus creating the problem while opening up in the excel file. example:
Exporting Data From Mysql Using Php In Excel Form..?
I have a table in mysql wich contain a sim_number field which is 19 digit unsigned number. i have designed a script using php headear command for exporting data as excel. It is working but with the follwoing problem. Since sim_number is 19 digit number when it get exported as .xls file. now when that .xls file is opened, excel automatically detect this sim_number as number and , since excel can store only 15 digit in number format it converts its last 4 digits to zeros. Is there any way to get this sim_number exported as text so that excel store complete 19 digit number in text format. I cannot attach some charctor to this sim_number because of restricion on file format.
Exporting DB Results (or Flat File) To An Excel File
I have two scripts, neither of which have been written, that will need to collect user information. They will either write to a flat file or to a MySQL DB, and I need a way for an administrator to grab an Excel file based on this data. First, no more than 100 people are expected to sign up, so flat file is certainly viable. Do you recommend I use DB or flat file? Second, based on your recommendation, how should I go about exporting the user data to an Excel file? There will be about ten form fields per registration to give you an idea.
PHP Website
Is the php website down. I am unable to access the documentation. www.php.net
RSS To Website
I have a client who has given me a link to some other websites RSS Feed , he want to display the data in his website from RSS FEED. Hoe to make this. Is it like reading the xml and displaying or is there some other way to do this.
Get Website URL
I've seen scripts which get the exact url to the path where I'm using this script. It gets the full website url with sub folders, etc.: http://www.test.com/... How can I do this in php?
Where To Get 'website Spider' Bot For PHP?
Hi, I have a somewhat weird request, but I have a legit reason. My new CMS is having performance problems, and we are trying to resolve the issue by implementing a bot or spider that grabs the HTML of the site every 30s. I was wondering if you guys could kindly tell me where to get such bots. The program will be installed on another server with cronjob to run every 15s. The 'website performance' check services out there are limited to 2 minute interval. I need something that hits the target site in question more frequently.
PHP Website Security
We have developed an ads network script for running ads network site. Can someone please guide us on security features that we must implement to prevent hecking and exploits...? We have looked into major security problems commonly known like image uploads checks but I would like to know more on other security checks that are generally over looked.
Set Two Cookies For The Same Website, But Not For The Same Url.
It is possible to set two cookies for the same website, but not for the same url? What i means is: you have 1 login form. Out of that loginform, two cookies should be set. One cookie should be set for yoursite.com. The other cookie should be set for subdomain.yoursite.com (like forum.yoursite.com). The information in this cookies will be different.
Website Picture From PHP
does anyone of you know a save method on PHP to relyably, maybe using other programs create scrennshots (thumbnails) of websites? I am the administrator of the open source project (at SourceForge) "TSEP - The Search Engine Project" (http://tsep.sf.net) and we might want to show pictures of the website our search engine has found. The generation process of the thumbnails should be pretty automatic (as much as possible) My tries to find an "optimal" solution did not bring any good results yet, so I am hopeing for better information here.
Backup Of Website
I am seeking after a backup script, to take backup of my webspace on my server, my server is www.servage.net i need to take backup 2 times per day. Via cronjob on www.cronjob.de but i have seeking i 2 days without reslut. Where can i find some webspace / serverspace backup scripts?
PHP Website Management
I have just bought a small website written with php & html. The vendors advised me that once I uploaded it to my website I could customise all the templates to give it whatever look I wanted. As a novice, I had no idea how difficult this would be - due to the fact that a php website is very disjointed. Can anyone tell me of any software I can download that will enable me to manage my website so that I can see the structure in it easily and make changes simply. (I thought I was buying 60 sets of templates but what I bought was a site with 60 pages).
How Can I Download A Website
I am not sure if this qustion is just for php expert: How can I download a website including all html, javascript, gifs, etc.
XML RSS Reader With BBC Website..
I have made an RSS reader and am testing on the BBC website, and I use this code to grab the contents of the XML file, however when I look at the contents grabbed by my function, and the HTML source of the bbc website XML, they are different... how is that even possible? Anyone have an XML parser that they could test this on please? Heres a sample link and my code: http://newsrss.bbc.co.uk/rss/sporto...ootball/rss.xml $ch = curl_init($feed); $fp = fopen($rss_name, "w"); curl_setopt($ch, CURLOPT_FILE, $fp); curl_setopt($ch, CURLOPT_HEADER, 0); curl_exec($ch); curl_close($ch); fclose($fp);
Script To Log Into Website
I'm looking for a script that will attempt to log into a website (ex. Gmail) and report back if it suceeded or not. I don't know if this can be done with PHP or another language.
Ad Rotation On A Website
I am having trouble looking for a script that will rotate images from a standard text file. I have a folder set up with two images that rotate every time the page is refreshed. They also have a hyperlink so that when an image/ad is clicked on it goes to the advertiserments web address. The only problem is that the path to the images and corresponding hyperlink are in a javascript file. Is it possible to reference them from a standard text file so that a non-techie can login to webedit pro and edit the image name and url everytime the ad is being changed ? The script can be java scrip or preferably PHP, once it can reference a .txt file...Im happy
Creating Pdf From Website
Woudl it be possible to create a PDF from an internet explorer view, using php? I would like to create a hardcopy (pdf) from a report, currently generated and echoed by php and have adobe acrobat reader fired up on the push of a button....
Multilanguage Website
I'm trying to make a multilanguage website. When the user enters the site, I want to detect the language and automatically make a redirection. How can I do this? And how should I organize my data base so the user can switch languages easily?
Getting Info From A Website.
I have been doing PHP for over a year now but when I came round to writing a script I discovered that there was a reasonably sizeable gap in my knowledge that I didn't even know where to start finding out about. Anyway this is a reasonably nooby question: If I have a script on http://url-a.com/script.php and I want to get some dynamic information of my friend's site at http://url-b.com/info.php , How can I get it? I need to use get variables in getting it and it must also be server side.
CW - My Latest Php Website
Its also the first shopping cart i've wrote . Personally i find it a bit strange that given all the php scripters on this newsgroup nobody ever posts a url to their work . I suspect thats sometimes [1] because a lot of people never really finish a website and they are more interested in php code snippets - not saying thats a bad thing of course - it just seems a bit pointless if you never really do anything with the gained knowledge . [1] and non disclosure in some cases . Anyway , As you will see from the website below i also have a interest in web design and these days try to blend the 2 together . Comments (good or bad) invited .
Website Too Slow
I'm re-programming my Website (www.coaster.ch) in PHP and I find it too slow (although I have ADSL). That's more or less how it functions: Here my tables: 'COASTERS' (code of coaster, code of country, etc...) 'COUNTRIES' (code of country, names of countries in different languages, code of continent) 'CONTINENTS' (code of continent, names of continents in different languages) In my index.php (start site) I use a "while": I look for the first continent. I look for the first country I count all the coasters from 1st country echo country - number of coasters I look for the second country I count all the coasters from 2nd country .... .... I look for last continent.... The search and presentation in tables (I use 5 tables, 1 for each continent) is rapid. The problem is when I go the the sub-site of a country and want to come back to the index site: it takes too much time. Could it be that it is slow because it has to make the whole search again? Can I solve that by making the first search (at the begin of the session with something like requireOnce "search data) and charge all the information in an array and them when returning from a sub site only showing the array? I also thought that perhaps the reason could be that I use tables for continents and countries but otherwise I should have to include all these texts in .inc files...
|
TRACKER
