Posts by chrishea

From the documentation, you can access the table contents as follows:
Access by row and column
$data->val($row,$col)
You can also use column names rather than numbers:
$data->val(10,'AZ')
Access data on a different sheet:
$data->val($row,$col,$sheet_index)

I haven't spent much time (yet) exploring the different possibilities but you should be able to:
* loop through the cells, modify the data if necessary and save it to mysql.
* Copy the content to another table; modify the content as necessary in that table; display that table and then call my desktop_write utility to save it.

I haven't done the full end-to-end version of this but it shouldn't be difficult.

Easier to start with some systems that are already built and see what they do (then decide if you still need to build your own). A list of ones that are available is here.

The Excel Reader is pretty capable. It can read your xls files directly rather than use csv's.

http://code.google.com/p/php-excel-reader/

Yahoo has an API that will should allow you to extract address info.
http://developer.yahoo.com/mail/

I'm sure that if you do a search you'll find the others (at least Google).

I think that you can use my little desktop_write routine to produce your excel file.

http://innovationsdesign.net/wb_2.7/pages/tech-resources/downloads.php

You can put a @ in front of the mysql_num_rows to suppress the error.

I was able to re-boot into normal mode after a few tries booting with the Delete key pressed down. I have left it running ever since and I have no problems of any sort now that it is up and running (under Vista). For now I'm just letting it run 7/24 with all of the power saving options off. I have spent many many hours trying to figure this out and so far, no luck.

When I have the time and energy, I think that my next move will be to try booting with no hard drive and just a Windows install disk and then to try formatting the first partition on the new disk and try installing Win XP again and see if it works. I didn't have any problems initially after I installed XP. It was only after it went into sleep mode that the boot stopped working. I can probably get back to that same point again and then make sure that all the power saving options are off.

I followed this up in the Hardware forum because it looked as if this might be caused by hardware and there are many other posts in the hardware forum with similar no boot problems. At this point I don't know what it is but at least I'm running again.

The link to the HP "Warranty Service Enhancement" is:
http://h10025.www1.hp.com/ewfrf/wc/document?lc=en&dlc=en&cc=us&docname=c01087277

My problem and yours may be the same. I tried all the normal stuff and generally they didn't help. Two things that did work:

• F11 - after enough tries, this will get you into the HP Recovery Manager (assuming that it is set up on your machine). This gives you some recovery capabilities (including a command line.
  
• Del - On my machine, this was able to bypass the problem and allowed it to boot. It doesn't take every time. You have to shut down (hold down the power button for at least 5 sec until the machine turns off) then hold down the Del key while you start it again. If it doesn't take you have to do it all again. The theory is that there is something wrong with the motherboard / video chip and if that is the case, it isn't clear as to why this would bypass it and why the system would run OK when it does boot.

Right now I have my system running quite normally and I am just letting it run. I don't know if I want to run it 24/7 indefinitely but for now it's better than having to fight with the boot process. Give this a try and let me know if it works for you.

If this is a project then aren`t you supposed to be writing it? If you tried to write something and had a problem making it run then people would probably be willing to help. Even if someone was willing to help you find one, they would need more details (requirements) than you have provided.

The motherboard was replaced once before the warranty expired. At that time I think it was because the wireless interface died. I will give them a call and see what they say. I think there is a 24 month limit (from original purchase) but I'll give it a try.

Duplicate - posted by accident.

I have been documenting my laptop problem in the Vista forum (ref) but it seems that maybe the problem belongs here. The system is almost dead even though there is a way I can break out of it.

In a nutshell, there is something wrong at the POST stage that causes the machine to cycle on and off. I seems to do one quick read of the drive and then just sits there with the lights on and the screen black. After 20-30 sec it powers itself down and then immediately powers up again. It won't boot off a CD when it is going through its power on - power off cycle. Even though it starts to read the CD, the system powers down before it gets too far.

After enough tries, I can interrupt the loop with the Del key at which point it goes to the HP screen and then boots into windows. Once I'm able to get it started this way, it runs fine (I'm on it now).

Without going into the whole saga, I was able to create an XP system on a new hard disk (on this same laptop) and initiallty it was ok but it eventually had the same startup problem as the Vista system.

I already recreated the boot record just in case it was responsible for the problem. At an earlier point I also swapped out the memory sticks and used another pair (which didn't change …

Well the weirdness hasn't stopped yet, but in a good way this time. I hope someone finds this useful or at least entertaining.

I let the machine reboot quite a number of times (under XP) but it wasn't going anywhere except in a loop. I was reading about the possibility of corruption in the Master Boot Record so I figured that I would try the command to repair it. Since I couldn't get to a command line under XP, I swapped the Vista drive back in and tried re-booting. I had been using a number of Function keys (mainly F11) to get into the HP Recovery Manager but for some reason this time I tried the Del key. That was almost like magic. The initial HP screen came up and then it went into the Windows boot. It gave me the choice to go into Safe Mode or not so I chose to do that. So that's where I am right now with it running quite normally under Vista Safe Mode. I'm copying things I needed (like mail) and I guess that I will eventually have to do a normal boot and hope that it will boot again normally. I will take another restore point first and I may run the MBR update first (but I need to look into that further). I have turned off the automatic power-saving options.

So at this point, it would seem that I can conclude that:

• There is no basic hardware …

This is getting weird and (even more) frustrating.

After downgrading to XP on a new drive everything was working fine. Then I left the machine a bit too long and it put itself to sleep. Once again it doesn't want to come alive again. Same thing as before with continual restarting but no boot. It's as if it is detecting some sort of problem and wants to shut itself down as a precaution. Since it worked fine for a couple of days after I put the new drive in and loaded XP, I can't believe that there is a hardware problem. Only one thing that seemed to be a minor problem is that the BIOS was only reporting 1 gig of memory when there should be 2 gigs. I re-seated the memory boards and now it reports it as two in the bios. Once again I can get to the bios occasionally by pressing F8 after a restart. With an XP disk in the drive, it seems to start reading but then gets shutdown when the machine shuts itself down.

Reading many posts about similar problems tells me that this sort of thing has happened to many people with HP / Compaq laptops. The only ones that seemed to get reported as resolved were the cases where the machine was sent back to HP for repairs. There were various reports of being able to get the machine to boot again by:

• Letting the machine continuously power off …

Your question is very specific to the eWay interface and you are probably better off contacting eWay support. They don't seem to have a user forum but they should have documentation that specifies what info you can get back after a transaction completes.

There were more restore points created previously but for some reason, it only let me choose the most recent.

The system only gave me the option of one restore point and it was taken during the brief period when I had it working again. I tried it out of desperation but it didn't help.

With respect to the hard drive, that's one more point where HP is not helpful in giving clear information. The original description of the laptop quoted an upper limit of 240 gb (using two 120gb drives). Nothing that I could find from HP said if this was a real limit (e.g. something in the Bios) or just a limit of what they provisioned. After enough online research and talking to the computer store I became convinced that there was no technical limitation. I bought a 250gb drive for $72 (7200 rpm with 16mb cache) and it is great. Since drives don't last for ever, this is probably a good time to put my old drive into a backup role anyway. I get a bit more noise and vibration from the new drive but the heat is about the same or maybe even a little bit better (at least so far).

The biggest impact will be re-installing programs and the fact that I was using Windows Mail and that may all be trashed. Despite the pain, it's almost like getting a new laptop so it's actually pretty positive from that point of view. Compared to about a month ago when I also had both hinges broken (which I repaired myself with new hinges from …

Well I ended up back in the same situation where the machine would fail and reboot in a loop. Using F11 I was able to get into the HP Recovery Manager again (after a dozen or more unsuccessful attempts) but the best that I could do was to get into a command window where I could use xcopy to make copies of some of my files. I got pretty sick of that so I figured it was time for a more drastic solution. I bought a new hard drive (double the size and faster) and an external housing for the old drive that allows me to plug it in as a USB drive. I then went through a couple of days of experimenting and researching to figure out how to downgrade to XP and get all of the devices recognized. I just had enough of Vista (after about 2 1/2 yrs).

I spent most of the day today trying to find an XP video driver that would recognize the native size of the LCD screen and support that. The HP site provides a bunch of drivers for other devices but no video driver for my machine. I went through innumerable web sites that ranged from "it can't be done without a new video card" to ones with utilities to force the resolution that didn't work. Neither the HP or the NVidia web site were much of any help. Finally, many many hours later I found a site with a …

Here's a further update.
I shut the system down normally last night and when I started it up this morning, it seemed to be in the same loop shutting itelf down and then restarting. Using F11 (HP Recovery Manager) took me to an HP Recovery screen that offers various options. I chose to do a chkdsk for the the main (Windows) partition. That ran for a long time and didn't find any errors. After that, the system booted up normally. There is probably still a problem and it will probably do the same thing at startup the next time so I'm not there yet.

Well, after a day of research and anxiety, I finally got it working again. The manual suggested holding down F10, F11 or F12 as the system is started. Thought that I'd tried that earlier but decided to try it again. F10 did nothing but F11 almost immediately brought up a screen that allowed me to drop the hibernation file and to proceed with a normal boot. After that, it was a normal startup.

I've done some research on this and I haven't found any really good suggestions. Here's the summary:

• HP dv9000 laptop with Vista (updated regularly).

• No recent changes - was working fine

• Put it into hibernate mode

• Tried to restart it the next morning and it woudn't start. All the lights would come on, there was on brief flicker of the HDD light and then not too long after the machine would shut down and then almost immediately try to start again. It just keeps going through the same sequence until I shut it down. The screen stayed black.

• Tried all the easy stuff: tried disconnecting the power and took out the battery and let it sit for a while. This worked in the past when I had a similar problem but no luck this time. Tried alt-ctrl-del, F8, del, esc and every other Fn key but it won't break out of the situation it's in and go back to the boot sequence. I tried putting in the (Neosmart?) recovery boot disk and it seemed to read it but nothing different happened. I swapped the memory sticks but that didn't change anything.

I suspect that the hibernate file is probably corrupted. I'm thinking of getting a new disk drive and starting over (and then see if I can read the current drive as a second drive). It seems a little bit extreme but I don't see a better way out of this. I could …

Your question isn't clear so that's probably why you didn't get any answers. You can use PHPMyAdmin to edit the records and insert whatever value that you need or you could get fancier and write a program but unless there will be a lot of change, it's probably not worth the time to do that. If your need is more complex than this then you need to state your question more clearly and completely.

I don't think that this is possible. If you find a way I hope that you'll post it.

I tried some reverse engineering by using the html output from word for a document with a header and footer. The best I could get was the header and footer listed as part of the body of the document before and after the actual text. HTML doesn't have an equivalent feature so I think that this is really an internal Word feature that you probably can't access by giving it formatted input.

A little Googling usually comes up with an answer for the easy questions!

The easiest thing to do is to install a package that gives you the whole LAMP system in one go. I'm not a Mac user (so I can't give a testimonial for any particular package) but the link below is for the MAMP package that does this.
http://www.mamp.info/en/index.html

This site povides various versions that you can download. You can probably take the Access version and see how they did it.
http://bibledatabase.com/free_bible_software.htm

A little but of googling would lead you to PIG, the PHP Interest Group that has a specific interest in ICQ. I suggest that you use that site to get an answer.

Just a comment. I once spent a lot of time trying to get mailing to work correctly, especially when adding attachments and so forth. I found the Libmail class and downloaded it and I haven't looked back. The interface is simple and it works every time. I know that there are lots of people who enjoy re-inventing the wheel and far be it from me to get in the way of that. If you just want to send mail with the minimum time and effort, Libmail works.
I think I made one change to it to and that was to allow the To field to accept addresses separated by commas. If anyone wants my version, I can post it on my site.

Since you haven't had any responses, I'll take a crack at it to get the ideas going. I'm not providing any code, just some thoughts.

I'll assume that you have a specific page where the links will appear and that there could be any number of such links. I think that the starting point would be to collect the information and put it into a database. At some point, a program in the backend or a human on a keyboard needs to call/run the program that captures the data and put it into the database.

Your HTML page that displays the links will need to become a PHP page (even though much of the content will be the same HTML that you have now). It will have a PHP section that will open the database and a loop that will read the records and create links to overview pages (and echo them to the screen).

The overview pages will need to be created. I would suggest that you create a shell that you can save as a file (it could be .txt or .php). At the same time that you are adding the overview info to the database you can create the new overview page(s). Simplistically, you can read the shell for the page using file_get_contents, search for some specific string like "//####insert_your_content_here_####"
and replace it / insert your overview text from the input. You can then save the new string with file_put_contents to create a …

It's actually quite easy to save the output as Excel (or Word or ...) but first you have to produce a table on the screen in the format that you want to see in Excel. You can go to my site and download the Desktop Write utility that will save it for you (link below):

Download Desktop Write

There are a number of programmers editors out there that support a variety of languages. I have used Context and it has "highlighters" for many programming languages.

You don't say what your objective is. If it is a learning exercise where you are prepared to reinvent / modify the wheel, then you are looking for open source tools. Context is open source. If you search for "editor programmer open source" you will get a bunch of additional choices.

I have recently been looking into this. There are a couple of free options to generate keys and so forth but the actual activation is probably additional development if you want to automate it.
Kenetix
This is a pretty simple approach
http://www.kenetix.net/Utilities-License_Generator.html

Activelock
There was oriiginally built for VB but there is a PHP version. I did a bit of initial testing. It looks as if it is made for PHP4. It will take a bit of work to make it PHP5 compatible (but it may be worth it).
http://www.activelocksoftware.com/

or if you are prepared to pay for it, you can look at:
PHP License Pro
This includes activation and monitoring.
http://www.phplicensepro.com/

You are going to have to protect the code as well so you will probably want to use Ioncube by purchasing a copy or uisng their online pay as you go option. You can use an obfusticator but they can be broken so you probably don't want to do that for anything that you've invested a lot of time into.

Feral Reason: Is there some logical reason why you would answer a post from 2005 now?

Excel can read HTML and open it as a spreadsheet. My Desktop Write utility takes advantage of this to create Excel, Word and other types of output. Get it here:
http://innovationsdesign.net/wb_2.7/pages/tech-resources/downloads.php

This has come up a number of time recently. If you do a search you will find the other posts and the suggestions made.

I have started to experiment with the latest version of a PHP Excel Reader which you can find here:
http://code.google.com/p/php-excel-reader/

It seems to be very capable and easy to use. Click on the link and you will see the sample Excel sheet and the PHP output (which looks the same). It can handle work books with multiple sheets and it can also handle references from one sheet to another.

I have successfully used a number of these approaches:
* Using PHPMyAdmin to import a csv file is pretty quick and simple. You will want to drop the header from the CSV file and you need to specify that the field separator is a comma (in PHPMyAdmin).

* You can use PHP to upload a CSV file and then write it to a database. This is probably most useful if you need to edit/modify any of the fields or create indexes as part of the upload process.

* You can also read an XLS file directly. I did some work on an earlier version (link to latest below). It has the advantage of being able to read each of the sheets from a workbook. One limitation of the older version however; was that it couldn't handle references from one sheet to the other. I haven't tried the latest version so I don't know if that is still the case.
http://code.google.com/p/php-excel-reader/downloads/list

It's worth doing a search of previous postings because most common questions have been asked and answered before. I got this link from a previous post:
http://corz.org/serv/tricks/htaccess2.php

If it doesn't answer your question, there are a number of previous posts that you can look at.

Chris

If you don't want it to get too complicated why don't you use a service rather than build it from scratch? More specifically, something like Google Docs or a free forum where you could have an item for each game. These have sign-in capabilities. Not sophiticated but could work. There could be something free out on the web that would allow you to register people. Otherwise, you are probably into installing a CMS or building something.

There are a number of ways to do this. You haven't posted any code or provided specifics. If you use a Meta Refresh to do the re-direct, you should be able to include other code in the same module.

A utility called HTML2PDF can do a reasonable job of this. See my review and tips on using this package: Link

Starting with the obvious, why are you using:

$id = "<?php \$lastid = \"$lastid\"; ?>";

instead of:

$id = $lastid;

Here is one that works:

http://www.micahcarrick.com/04-19-2005/php-paypal-ipn-integration-class.html

You could include it. Your included file could be a PHP file containing the html with a $content = " statement before it.

You could also use fread to read it into $content.

All you need to do is a bit of searching. I don't think that you need anyone else to do that for you.

Try this thread:
http://www.daniweb.com/forums/thread49627.html

I tried logging in and then I logged out. Assuming that the logout button does something, there is something missing because I can then still go directly to Members.php. I didn't try accessing Members.php before I tried to log in, but maybe that will work as well. There is something wrong in your login checking in Member.php. If it is the code at the start of this post, then $_SESSION["login"] isn't 0 and it isn't 3. It seems like pretty straightforward debugging to figure out what the value is and change something in one module or the other to make it work.

Start with W3schools
http://www.w3schools.com/
Then spend some serious time downloading some Open Source systems and examining how they are structured and how they work. Find some well structured examples then make some improvements for practice. You will certainly need to spend some serious time coding but you will also need to read and find some best of breed examples. Look up PHP Best Practices on a search engine and that will provide some reference info.

I did quite a bit of experimenting with html2PDF in the past. I have used it successfully for converting a schedule in a table to a PDF version. I put your code into my test environment and gave it a try. Here are a few observations:

1. You reference a text2 style but it isn't defined. In general however, I found that using inline styles is more likely to work.

2. html2pdf isn't very sophisticated when it comes to tables. If you keep it simple you can make it work but don't get too fancy. I don't think it can handle a table within a table. Once I removed that from your code, I was able to produce the output down to the customer name line. If you redesign it to use a single table, it will probably work.

3. I changed the code to produce the PDF a bit:

$dummy2 = AdjustHTML($dummy);
	$pdf->WriteHTML($dummy2);
	$pdf->Output("daniweb1.pdf");

Use whatever file name and location you want in the output statement.

You can see my notes on using HTML2PDF at:
innovationsdesign.net

It took me quite a lot of experimenting to determine how far I could push HTML2PDF. Hope this saves you some time.

Someone posted a similar question recently. The answers aren't quite a "how-to" but they are a start:

http://www.daniweb.com/forums/thread120918.html

fopen_wrappers has to be enabled in order to use file_get_contents with a URL. This may not be the case on some servers, in which case you may need a local php.ini file to enable it.

A few observations:
1. When you post code, you should use [code] tags to have it format properly.
2. You don't need the <html> <head> and <body> statements. PHP takes care of that.
3. $subject on line 16 isn't defined (at least in what you have shown us).
4. The default is that mail doesn't actually get sent from the local (test) environment. It can be done but you will have to make some changes (if you need this, I'm sure that you can find references from an internet search).