Everything posted by kelso1983
-
Beginner Web Hosting Advice Needed
Hey, thanks for the advice. Sorry I meant to say that £4.99 + VAT is only for 1 domain name (It's £7.13 a month overall for 2 domains and the rest), but I think I get the gist. You get what you pay for! Out of interest though, where did you find the information about the minimum spec of their servers for shared hosting? I didn't realise they had what was perceived as slow servers.
-
Beginner Web Hosting Advice Needed
Hi all, Looking for some advice on UK web hosting. I was about to sign-up for an account with eHosting.com for some hosting but it's quite expensive for what it is. I'm looking for (approx): 2500MB Storage 25GB Bandwidth 1-2 MySQL Databases 2-3 Domains Easy to use cPanel (eHosting's is lovely to use) For this with eHosting it's about £54 + VAT per year! Even though I know they're a good host I wanted to try something different and cheaper. I've done a bit of homework but it seems alot of the hosting places only allow 1 domain on the space so I wanted to know if anyone has had any experience with something similar? Bear in mind, that although I know my web design, my hosting experience is pretty limited (I used Streamline for a while and they were awful) so I'll try and keep daft questions to a minimum!
-
HTML Email 'Quotation-style'
Hi all, I'm looking to set-up a way of a company sending out individual styled HTML emails similar to an insurance quotation. Sending HTML email through your won server seems to bring its own problems but does anyone have any recommendations for software or a service similar to say MailChimp or CampaignMonitor that sends out individual emails to customers without charging a flat-rate delivery for each mail out?
-
How to Speed up Webpage Load Times
My webpages are built using CSS and I have got the art of squeezing bytes out of images down to a T but yet my webpages still have a horrible habit of loading slowly or (just as bad) loading image by image giving a horrible stuttering effect when the page loads. Does anyone have any tips as to how to help improve this? For example two of my worst offenders are http://www.bowes-mitchell.co.uk/index.php (Please ignore the hideous splash page and the 'div-itus' - It was a while back that this was coded) and http://www.ukbiometrics.co.uk/
-
MySQL LIKE or REGEXP query
Hi all, I have a database that I cannot touch that has the following layout (shortened for this): Candidates Table e.g. forename - Dave industry_sectors - 1,15,19,158,178 What I want to do is pull records from the table where there is a match for e.g. 1 (in industry_sectors). LIKE and REGEXP are only able to pull records containing 1 (i.e. It will pull records with 15, 115, 61, etc) . I would like to pull out only records that have the 1. Is there another method?
-
MySQL JOIN SUM Query help needed
For those who might be interested in this problem the answer is: SELECT outcomeID, SUM(stake) FROM ( SELECT outcomeID,stake FROM back UNION ALL SELECT outcomeID,stake FROM lay ) u GROUP BY outcomeID;
-
MySQL JOIN SUM Query help needed
Hi all, I'm having difficult with the following MySQL query. These are my two tables with some example data. Back backID | outcomeID | stake 1 1 10 2 1 20 3 2 10 Lay layID | outcome ID | stake 1 1 10 2 2 20 3 3 10 I want to join the two tables together to get the following type of result: Totals outcomeID | stake 1 40 2 30 3 10 I know if something to do with SUM and perhaps JOIN but am struggling to come up with the right results. Can anyone help?
-
PHP 'Add to Cart' refresh issue
I've got a shopping cart that uses $_POST but every time a refresh happens or the back button is used, a prompt to confirm the action keeps happening and/or multiple adds are made to the cart. Does anyone know how to prevent this or a different way of doing it that is accessible?
-
Sessions and Arrays - Small query
Not a reader either . I did say it was an array within array in my 2nd post. Yeah that helped thanks. It seems to be a foreach within foreach. It was just the syntax I couldn't get my head around. The working code is below for anyone who struggles with the same problem.
-
Sessions and Arrays - Small query
But doing it how you've coded it means I can only store one array in 'recently-viewed'. I need to store multiple arrays inside that array.
-
Sessions and Arrays - Small query
**Double Post**
-
Sessions and Arrays - Small query
My $sport, $currentevent and $currentmarket variables echo as should do before the statement. It may be a problem with how I am storing it in the session i.e. $_SESSION['recently-viewed'][] = array('sport'=> $sport,'event'=>$currentevent,'market'=>$currentmarket); I'm trying to store an array of sport, event, market inside of another array called recently-viewed in the session.
-
Sessions and Arrays - Small query
Hi all, I've got a session array added to on each page using the following: I can get it to display (with no styling) using print_r($_SESSION['recently-viewed']) but what I need is to display and store each value in the array separately when retrieving. I've tried the following two attempts to no avail. Any ideas?
-
Deep Navigation and Accessibility advice
Hi all, I'm working on a project that is extremely deep in terms of navigation and can't use any scripting to 'hide' items. It has a with a similar sized hierarchy to Ebay e.g. 32 Categories > 300 sub-categories > 300 further sub-categories (you get the idea!). Should i be using Ebay as a good example of splitting up large blocks of categories for navigation or does anyone have any other good examples that are accessibility friendly?
-
Tutorial or Info needed for PHP URL query
Sorry, I meant rather than have your homepage as 'index.php' and links pointing to it as <a href="index.php">, you could change the URL so that it could be index/ that is your homepage and <a href="index/"> for any links pointing to it. I think I've found it though. It's known as "Re-writing the URL" and it can be done using mod_rewrite in Apache. http://www.sitepoint.com/article/guide-url-rewriting/2/
-
Tutorial or Info needed for PHP URL query
Hi all, I'm trying to render pages and make links in PHP using a directory name instead of a x.php. For instance, the PHP description on Wikipedia URL is http://en.wikipedia.org/wiki/Php'>http://en.wikipedia.org/wiki/Php Any other page you go on tends to have the URL and linkage format: http://en.wikipedia.org/wiki/[Title Name with underscores between seperated words] Does anyone know how this is achieved or what name/words I should be using in looking for a tutorial?
-
PHP Shopping Cart Storage Question
Cheers for the feedback. I'll post back with anything fairly interesting I find for anyone else viewing this topic.
-
PHP Shopping Cart Storage Question
Thanks. Which would you recommend researching the use of? (adv/disad)
-
PHP Shopping Cart Storage Question
<--- this is PHP / MySQL btw ---> A user in an e-commerce site adds an item or two into their shopping cart/basket and then navigates elsewhere in the site. After going elsewhere they return to the cart to find the items still there. What is the storage of this data tied to? The database or a session?
-
PHP SQL Algorithm
Hi all, I'm currently working on a bet matching algorithm (similar to Betfair) but am not quite getting the logic right. So far (in psedocode I have): ======================================== Make new Bet(); While new Bet isn't matched (using 'match for count) { Find any potential matches if num of rows > 0 { while potential matches exist (using 'match') { Find least recent match Create new record in matched table() Increase 'match' count on back table Increase 'match' count on lay table } } else { break; } } ======================================== It needs the potential to match 'parts' of bets against each other so that users can cancel bets or parts of unmatched bets. Does anyone have any ideas?
-
PHP - GET and POST security
Cheers for the input guys. I've read up on using POST by styling links as input buttons but instead I've: • Used GET to get the assID • Used trim to get rid of whitespace on the assID • Used substr to make sure the assID is exactly 6 characters long (i.e. $assID = substr($assID,0,6)) • Only allow the id to be used if it is all letters and numbers only (courtesy of Jem's ereg function). Otherwise it throws up an error message. That should make it secure enough shouldn't it?
-
PHP - GET and POST security
http://www.numyspace.co.uk/~unn_p387495/ (username - s123456 password - test) Once in just click on ass01, ass02 to send the assignmentID through the URL The assignment.php code is along the line of: $assignmentID = $_GET['id']; if(!empty($assignmentID)) { do a query WHERE assignmentID = assignmentID }
-
PHP - GET and POST security
I've currently got a page which includes an id on links like so: <a href="assignment.php?id=ass01>See assignment 1</a> <a href="assignment.php?id=ass02>See assignment 2</a> On the following page (and on any other page) I use GET to store the id as a variable. A friend is telling me that this is bad for security and that a POST function should be used instead to send the variable between pages. Is this right? If so, do I have to make every link a form and form button in order to use the post method? (If anyone wants to have a look at this in operation, let me know and I can post up the web address and sample login details to the section where it is)
-
Javascript, Speed & Accessibility
Hi all, Wasn't really sure where this topic would go in the forum so I'll try it here. I'm currently doing a project whereby the sites I'm examining are using Javascript heavily for their navigation (either through menu scripts or by the whole site using J2EE) due to the fact that processing through lots of links/options needs to be extremely quick (big factor for these types of sites). My main argument is that this use of Javascript is bad for accessibility and disabled users (e.g. no Javascript on screen readers, etc) but what I am trying to do is still be able to match (or get near) the same processing speeds but be accessible as well. Any ideas for a solution?
-
SQL LIKE Query help needed...
That works perfectly! Thanks. Does DISTINCT act like the GROUP BY clause then? Edit: Also what function would limit the results to only 6 characters e.g. ASS001