twsowerby

Hi Guys, I have a query regarding best practice for performance on a web application I'm developing. I am retrieving data via an API that I then need to display on a website. The data retrieved all relates to a product ID. The issue I am having is that each product has a UniqueID, but also a GroupID. The GroupID is used to display the same products but of different colour/size combinations. ie. UniqueID GroupID Size Colour 1 1 n/a n/a 2 2 Small Red 3 2 Medium Blue 4 2 Large Green I need to display the products in a list, but where there are multiple products in a group, I need to provide a dropdown selector for size and a dropdown selector for colour. I'm struggling a bit with how to structure it with just the array spat out by the API, so I was considering saving the data to a MySQL database and then querying that to get what I need. Is this a good way to go or is the double query hit going to be horribly inefficient? Cheers!

It may be a little bit of a heavy handed approach, but Drupal has a module called Webform that allows users to create forms on the fly. It then stores the form results for you and has the facility to add additional processing such as email confirmation on form completion.

Hi guys, I'm trying to develop a 'silent' install script for Drupal. Ideally what I would like is to be able to define the database host/name/password as variables and then also pass in the admin username and password so that the initial drupal installation form is no longer needed. Has anyone tried this before or have any ideas on the best way to do it? Cheers!

Hi All, I've searched around for the answer to this and can't find anything useful. I have a virtual private server that runs apache. I manage it via webhost manager. F every new website I create for a client, I set up a hosting package for them which gives them some file space, emails and a Cpanel login. I want to set it up so that I can run all of the website from a single drupal codebase and also share the database. I know you can set this up using Drupal's multisite functionality, but that requires all the sites to use a single CPanel account. I need to be able to share the single codebase between multiple Cpanel accounts. If that doesnt make sense then please ask questions, happy to try and elaborate! Cheers!

Ah yes I see the difference now. Thanks for your help!

Excellent thanks, thats pretty much what I figured, just wondered of there was a different way that might be better. Cheers

I ahve a call referral system that allows a user to log in and view referral records one at a time. The user looks at the record, makes a call, adds a note and clicks submit. The record is then updated. I am fast approaching a situation where I will have more than one user. Given the way the system retrieves records it is possible that two people using the system at the same time may be shown the same record and attempt to edit the same record at the same time. To get around this I was planning on implementing a random selection function. The function would randomly select a record and display it. Upon selection, a 'currently being edited' marker would be placed against that record. The next time a user calls the random selection function, it will do a check to see if the 'currently being edited' marker exists for that record. If it does then call the random select function again and so on until it gets one with no marker. Is there a better way of doing this? Cheers!

Hi, In order to develop in php you will need to set up some sort of development environment. Your best bet for this is possibly to take a look at something like XAMPP which will allow you to set up a local installation of apache and mysql. Once installed correctly you will be able to browse to http://localhost and see a page that should indicate you have set up your local development environment correctly. After you've wrapped your head around this you could then look at setting up a separate server that will serve files to the computer you are developing on, but for now you may be better just getting it all running on one computer.