chrishea 182 Nearly a Posting Virtuoso

There are different ways to tackle this:
1. Find an Open Source system that is Reasonably Good
Install it and live with whatever it provides. If you have the skills and time, you can modify / extend it. I found one called JobberBase that you may want to look at.
2. Do some custom work on top of an existing CMS
You need to have a pretty good knowledge of the CMS to do this (and pretty good PHP skills)
3. Build from Scratch
You would need expert skills and lots of experience along with lots of patience and time and/or lots of friends with expert skills to do it that way.

I suggest you look at JobberBase and any other open source systems that you can find and then pick one and install it.

chrishea 182 Nearly a Posting Virtuoso

The link address isn't valid.

chrishea 182 Nearly a Posting Virtuoso

I haven't used it but you may want to have a look at this one. Not PHP but can be used in a PHP environment. If this doesn't fit, do a search: there are other choices.
http://encodable.com/filechucker/

chrishea 182 Nearly a Posting Virtuoso

I did this myself and you can do the same. Version 1 was from CSV and for that I did a manual save to CSV from Excel first. Versions 2 and 3 do it directly from the Excel spreadsheet. This, in the end is a whole lot simpler than converting to CSV first. Going from the spreadsheet allows you to have multiple tabs in the spreadsheet and to upload from any one of them. It also gives you access to additional info about the fields. I use this to maintain parm files in Excel and then upload them into the database and it really simplifies the process. It can also identify mismatches between the spreadsheet and the database (e.g. extra or missing columns) and it tries to fix them when it finds them (sometimes a mixed blessing). I have also taken it to the point where I can predefine some of the parameters so I can provide it to clients to upload spreadsheets into the database (and get me out of the middle).

This took quite a bit of time to put together and to get it to its current state. It isn't open source and I haven't gone to the effort to package it for commercial distribution (I might still do that at some point). It relies on the open source php-excel-reader which is pretty easy to use. If you want to write this yourself then I suggest using the php-excel-reader rather than messing around with …

chrishea 182 Nearly a Posting Virtuoso

You haven't shown your form code. Each check box should have it's own name. If you are only referencing $orders, then it would make sense that you are only retrieving one value.

chrishea 182 Nearly a Posting Virtuoso
chrishea 182 Nearly a Posting Virtuoso

The proper format would be:

foreach ( $_POST as $name => $value){something}
chrishea 182 Nearly a Posting Virtuoso

Sorry, I blew that one. You could only do the str_replace if you used a while loop since it doesn't rescan. The preg_replace is definitely simpler.

chrishea 182 Nearly a Posting Virtuoso

You can use:

$result = str_replace ("--","",$string);
chrishea 182 Nearly a Posting Virtuoso

I would echo the Select statement and try it in PHPMyAdmin and see if you get any results. If you do, then something is probably going wrong in the connect or select. If you don't, then you need to check the select and see what isn't matching up with the database values.

chrishea 182 Nearly a Posting Virtuoso

You are expected to make your best attempt at coding the solution and then posting some code if you have a problem. It isn't code-on-demand where you can just post a requirement. This isn't a very difficult requirement so if you have some programming skills, it shouldn't be a problem. If you aren't a programmer, then you should be posting in some other forum looking for someone to code for you.

chrishea 182 Nearly a Posting Virtuoso

I looked at SoftwareKey's website and I must admit that I found what they are offering to be a little bit unclear and pretty expensive. If I was going to sell some of my software, I would want to encrypt the code and have licensing options. I have used Armadillo (now Software Passport) in the past for Windows programs and it provides both the encryption and the licensing. For online programs (in PHP) IonCube offers solutions that provide the encoding and licensing at prices that are more reasonable than SoftwareKey's.

chrishea 182 Nearly a Posting Virtuoso

If you are at the stage of planning your thesis, haven't you already done some sort of web-based development? How can you get through a Software Engineering course without having done this? I say this because your first choice for developing a web-based solution should be whatever web development language you already know. If you really haven't done this before, then PHP with a MySQL database is a good choice because it's free, not too difficult to learn, there are lots of examples available and lots of help forums if you run into questions or problems.

chrishea 182 Nearly a Posting Virtuoso

If you are running this locally on a Windows system, then there are probably many ways to do this. I use a Basic-like scripting language called Autoit for this type of work. It has good functions for reading and writing to Excel.

chrishea 182 Nearly a Posting Virtuoso

I don't know if you will find this all packaged together. CMS's generally have dynamic menus and individual templates may have multi-level drop-down's built on top of that. If you do a search, you will find many JQuery drop-down menu solutions. If you do a search, you can also find articles about building dynamic menus. This is one example.

chrishea 182 Nearly a Posting Virtuoso
chrishea 182 Nearly a Posting Virtuoso

You'll have a better chance of getting help by searching / posting at the Google Checkout Forum.

chrishea 182 Nearly a Posting Virtuoso

Assuming that you are correctly displaying a white pixel, you might be pushing the limits of the monitor or more likely the human eye. You may need something larger than a single pixel in order to have the color clearly distinguished. I'm not a physics expert but remember than a monitor creates (the illusion of) a whole variety of colors through combinations of red, green and blue dots. The human eye interprets the different combinations as other colors instead of red, green and blue. If you make the dots much bigger, then you start to see them as the three prime colors again. With a white pixel (actually red, green and blue) on a black background, the eye is probably doing some interpretation. If you were to use a magnifying glass to look at the pixel, it might then appear to be more white than gray.

chrishea 182 Nearly a Posting Virtuoso

I think that you are best to go to the OpenStreetMap community to ask this kind of question. The page that I provided the link to has a number of help options.

chrishea 182 Nearly a Posting Virtuoso

I don't think anyone could provide anything other than speculation based on the limited information that you have provided. Whether additional workload such as a Cron job will affect performance will depend on how close to the limit of the server you are and how efficient the Cron jobs are. The first part, the server limit will depend on a lot of factors. That includes the type of hardware you are using, if it is dedicated to this application, the efficiency of the application, the number of transactions being processed at one time and so forth. If you have 1000 users, some % of those will be active at one time. In any given second, you will only receive transactions from a subset of those users so knowing the average and peak arrival rate is important information.

To do this properly requires some modelling and benchmarking. If you are far from having a problem, some quick analysis might demonstrate that you are ok. If you are close to the line, then more serious analysis will be needed.

chrishea 182 Nearly a Posting Virtuoso

Why don't you try the sample code provided by Google?

chrishea 182 Nearly a Posting Virtuoso

If you main objective is to get something working quickly, then I'd start with a search to see what open source solutions are available.
http://tinyurl.com/42aebds

Even if it is homework, looking at existing systems will still give you a head start.

chrishea 182 Nearly a Posting Virtuoso

I think that you need to work on your debugging skills! $askingPrice is not the same as $asking_price. $askingPrice = 0 so the result is (1-0)* 100 = 100.

chrishea 182 Nearly a Posting Virtuoso

If OpenStreetMap has the level of info that you need, then that is probably your best solution. There is info here on how to deploy it.

chrishea 182 Nearly a Posting Virtuoso

The data in the form will be passed to your purchase-process program. If you have any additional fields that you need to pass to that program then define them as hidden variables in the form (<input type=hidden...) and set the value and name.

chrishea 182 Nearly a Posting Virtuoso

I think we'll need to see more of the code.

chrishea 182 Nearly a Posting Virtuoso

It seems as if this is your second post for the same problem. Is this any different from this one?

chrishea 182 Nearly a Posting Virtuoso

If you want a separate read of another table, then define the select statement and use a mysql query with another variable as in:

$result2=mysql_query($sql);

In the subsequent code for that query, you will refer to $results instead of $result.

chrishea 182 Nearly a Posting Virtuoso

Since you are trying to include it into some PHP code, you don't need the <?PHP or ?> just the require statement itself. You only need to use <?PHP ... ?> when you are inserting some PHP code into (raw) HTML statements.

chrishea 182 Nearly a Posting Virtuoso

I just tried a query in phpmyadmin with a '&' in the query and it accepted it just fine. I don't have any data with an & in the data so I didn't get any results but it did accept it.

chrishea 182 Nearly a Posting Virtuoso

I'm not going to write the code for you but let me suggest that it is simple enough to generate a series of check boxes with appropriate labels in a while loop based on your input / database / table or wherever you are keeping the details of the options that are available. You will want to make the names of the check boxes follow a pattern such as option_1, option_2, option_3 and so forth. That makes it relatively easy to find out what was entered in the module that will be the "action" for your form.

Your turn. You need to take a crack at the code and then if you have a problem, post some code and define the problem.

chrishea 182 Nearly a Posting Virtuoso
chrishea 182 Nearly a Posting Virtuoso

If you have a login process, then you need to have a timed process that checks if an account is still active/online and if they aren't then you automatically log them out. You could do this every 15 minutes and any account that is logged-in but inactive would be logged out. Obviously, this also means that you need the ability to track activity. Unless you are doing financial transactions or some other very sensitive process, this isn't a big issue. If you have provided the ability to logout and the user chooses not to do it, then he/she can still access your site from that machine & browser without logging in again. In most cases, this is a "so what" situation.

chrishea 182 Nearly a Posting Virtuoso

Since you have limited experience, you might want to find someone who does have business and website experience who can review your idea and provide you with some feedback. If it is going to be a large project, then you will want to create a realistic plan with respect to the time and cost required (with help from someone with relevant experience). You'll also want to do some research to determine if your idea is really unique or if someone is already doing t.

In terms of protecting your idea, you can use a non-disclosure and "non-compete" agreement with anyone that you bring in to help you. You will still want to be careful who you share the info with since agreements are only as strong as the legal action that you are prepared to initiate to enforce them.

chrishea 182 Nearly a Posting Virtuoso

Maybe you should explain why you need to do this. Normally, the session will terminate automatically when the browser is closed.

chrishea 182 Nearly a Posting Virtuoso

I use HTML2PDF which provides a simple interface and it takes care of the details. I believe that the older version used fpdf. The newer one here uses tcpdf and works pretty well.

chrishea 182 Nearly a Posting Virtuoso

Have a look at this.

chrishea 182 Nearly a Posting Virtuoso

You are looking at this the wrong way around. If you don't understand what PHP is used for, then what is your logic in wanting to incorporate it into your website? Unless your intent is just to learn another language, it is a matter of looking at requirements and then trying to match them up with what PHP or some other language can do. Even if you just want to learn another language, it is a significant commitment of time and effort to do that. You want to be sure that you make the right choice.

chrishea 182 Nearly a Posting Virtuoso

You might want to re-post the code using code-tags. It is difficult to make any sense of code posted the way you have done it.

chrishea 182 Nearly a Posting Virtuoso

I think that you have three choices.
1. If there is some common factor that links these records together in the database, then you can use that as a selection criteria.

2. If you can collect your criteria before issuing the select, then it can be in the form:

... WHERE contid='firstpic' or contid='secondpic' ...

3. If your criteria is based on input from some source or a table then use a While loop rather than code all the selects individually.

chrishea 182 Nearly a Posting Virtuoso

Why are you resurrecting a thread which is now 2 months old?

chrishea 182 Nearly a Posting Virtuoso

I think that you need to provide a bit more detail. When the user uploads the file, why aren't you converting it immediately (and just out of interest what are you converting from and to). The simplest version is to let them wait unless the wait time is very long. If the user submits this file and basically doesn't care when it is done, then you could use Cron or start a new task to process the conversion in the background. Either of these solutions will have a higher level of complexity than the straightforward approach. There is probably some example code around for parts of this but you will need an appropriate level of expertise to put it together.

chrishea 182 Nearly a Posting Virtuoso

First thing that you might want to do is to log all the pertinent info when you delete anything. The second thing that you might want to do (at least for a while) is to do a soft-delete instead. Just mark the record as deleted or save a copy under a special "deleted" key or move it to another "deleted record" table.

With both of these in place you will be able to investigate what is going on and you won't permanently lose any data.

chrishea 182 Nearly a Posting Virtuoso

There are some tags that it doesn't like (e.g. <center>, <tt>,<title>,<meta>,<outline>) and the rest must be closed where possible. As an example, if you create a table and use <tr> or <td> without closing </tr> or </td> tags, it won't work. It may look fine as HTML but you can't take shortcuts when using this utility. If you give it good input, it works great.

chrishea 182 Nearly a Posting Virtuoso

... which you can find here.

and exlicitely:
Do provide evidence of having done some work yourself if posting questions from schoolwork assignments

chrishea 182 Nearly a Posting Virtuoso

You also have an issue that your page doesn't scale to the screen size and the minimum width is pretty wide. On my screen (1366 wide) I have to scroll horizontally to get to the right side of the page while you have unused gray space on the left and your menu extends beyond the width of your "tabs" on the right to make the screen even wider than necessary.

chrishea 182 Nearly a Posting Virtuoso

It sounds as if you are trying to manually configure everything but that is the hard way to do it. There are quite a number of packaged solutions that install the LAMP stack for you and synchronize everything together. You can get more info here.

You don't need IIS in order to develop and test PHP code. It would be simpler to take IIS out of the picture, at least when you are trying to run Apache. If you need to have IIS running at the same time (you should explain why) and that conflicts with Apache then maybe someone else can comment on that.

chrishea 182 Nearly a Posting Virtuoso

It looks like this Zend facility has the ability to convert .doc to .pdf. That way, you could display it as a PDF:

http://www.phplivedocx.org/2009/02/06/convert-doc-to-pdf-in-php/

diafol commented: Whooaar! Nice - been looking for an implementation. Shame about the ZF though - can't get my head around it. +9
chrishea 182 Nearly a Posting Virtuoso
chrishea 182 Nearly a Posting Virtuoso

In order to track users, you'll need some sort of logon process. The previous post provides a low-end approach to doing this. This may satisfy your needs, otherwise you'll want to look at using a database to keep the user information, including their login status. You need a process to force a logoff for anyone who is inactive for a set period of time. Otherwise, everyone will eventually show as logged on / active.