Jump to content

DeanWhitehouse

Members
 View Profile  See their activity

  • Posts

    2,527

  • Joined

  • Last visited

 Content Type 

Posts posted by DeanWhitehouse

    Experienced Web Developer - Dean Whitehouse

    in Archived Job Offerings

    Posted

    Hello,

     

    I'm an experienced web developer with 5 years of experience in PHP, HTML, CSS and JavaScript. I also am experienced in ASP.net, C#.net, Java, *NIX Web Servers, SQL, AWS and more.

     

    I'm currently looking for some medium sized web projects to work on. I offer very reasonable rates and will work with clients to help develop systems within their budget. I can offer full hosting and management packages or can just provide the client with the code they require.

     

    My portfolio is at www.deanwhitehouse.co.uk

     

    For more information get in touch at [email protected], message me on here or use my websites www.deanwhitehouse.co.uk/contact page

     

    Article Review - Session Caching in PHP

    in Miscellaneous

    Posted

    Thorpe: It just makes it easier to store items in a session and retrieve them when implementing on a website where you are unsure of the possible $_SESSION index names. It's basically just a few functions to manage a sites session caching instead of a user writing their own. Would only take a few minutes to re-create the functions yourself so I can see how it may seem pointless.

     

    ignace: I'm afraid I don't see how the class name is misleading, could you please expand. Thank you for the links I'm not very experienced in OOP design or guidelines such as them so will be good for me to learn.

    PHP Freelancer looking for small jobs

    in Archived Job Offerings

    Posted

    Hello,

     

    My name is Dean Whitehouse and I'm a PHP developer with skills also in MySQL, CSS, HTML, JavaScript (Ajax + jQuery too), AS3 and more.

    I am looking for some small projects to work on, generally jobs that can be completed within a few hours.

     

    The company I am the web developer at maintains the websites for Radio Academy, Fun Kids Radio and provides tools to Planet Rocks websites, Red FM and more!

     

    For my portfolio please visit my website http://www.deanwhitehouse.co.uk where my contact details for skype, mobile and email can be found.

     

    If you require references, quotes or just a chat please contact me through here or my website.

     

    Cheers,

    Dean Whitehouse

    Remove UTM tags from URL (regex)

    in PHP Coding Help

    Posted

    Hello all,

     

    I'm trying to generate a regex that will remove UTM parameters from my refferrer URLs.

     

    <?php
//"test" parameter is lost
echo preg_replace("/&?utm_(.*)\=[^&]+/","","?utm_source=bottom&utm_medium=widget&test&test&utm_campaign=testcamp");
?>

     

    The regex works on removing the paremeters whilst keeping parameters before and after in tact. However parameters in-between are lost.

     

    Any ideas would be great.

     

    I'm testing the above code on http://writecodeonline.com/php/

    Freelance Services

    in Archived Job Offerings

    Posted

    Hello,

    I am currently looking for new projects to work on.

    I have worked on a multitude of sites and have experience in PHP, CSS, HTML, Basic SEO, Mid-Level Javascript, Flash/AS3 and more.

    I have very competitive prices.

    I can also provide web design at a very competitive price.

    Contact me via PM or email at [email protected]

     

    Cheers,

    Blade

    IE Spacing Issue

    in CSS Help

    Posted

    Thanks for the reply, afraid not, already tried all that.

     

    I've narrowed down the problem to this div style

    div#core #images
{
float:left;
width:660px;
height:248px;
padding:2px;
border:1px solid #dadada;
} 

div#core
{
width:827px;
margin-left:178px;
margin-top:30px;
padding:0;
}

div#core #images ol
{
padding:0px;
display:inline;
}

div#core #images li
{
display:inline;
}

     

    The core div surrounds the main image area and the search box, the spacing appears in the image div area on the left. I can't find any cause or solution :s

    Advanced Query, not working, and crashed mysql

    in MySQL Help

    Posted

    Easier to read ;)

    <?php
$query = "
SELECT *,
MATCH(product_title,product_description,cat_name) 
AGAINST ('+$query* *+$query' IN BOOLEAN MODE) 
AS relevance
FROM `{$config['tables']['product']}`,category 
WHERE 
category.id = (SELECT main_cat_id FROM cat_product WHERE product_id = {$config['tables']['product']}.product_id)
AND 
cat_name LIKE '%".$query."%' 
OR 
category.id = (SELECT sub_cat_id FROM cat_product WHERE product_id = {$config['tables']['product']}.product_id) 
AND 
cat_name LIKE '%".$query."%' 
OR 
product_title LIKE '%".$query."%' 
OR 
product_description LIKE '%".$query."%' 
".(isset($order) ? $order : "ORDER BY relevance DESC")." ".$limit;
?>

    Advanced Query, not working, and crashed mysql

    in MySQL Help

    Posted

    Ok, a few problems with this query

     

    First one, it said it cannot search as the data encoding is different for one of the tables to the other one. I think i have fixed this in mysql but can't be sure as i need this query to be perfect, as we took the server down with it last night :$

     

    Second the query doesn't seem to work as i think it should

     

    The Query

    <?php
$query = "SELECT *, MATCH(product_title,product_description,cat_name) AGAINST ('+$query* *+$query' IN BOOLEAN MODE)AS relevance FROM `{$config['tables']['product']}`,category WHERE category.id = (SELECT main_cat_id FROM cat_product WHERE product_id = {$config['tables']['product']}.product_id) AND cat_name LIKE '%".$query."%' OR category.id = (SELECT sub_cat_id FROM cat_product WHERE product_id = {$config['tables']['product']}.product_id) AND cat_name LIKE '%".$query."%' OR product_title LIKE '%".$query."%' OR product_description LIKE '%".$query."%' ".(isset($order) ? $order : "ORDER BY relevance DESC")." ".$limit;

     

    I need the query to search two tables;

    The first table is "{$config['tables']['product']}", here it searches against the product_title and product_description.

     

    The second table is categories, here it searches against the cat_name.

     

    Now the hard part

    The cat name to search against needs to be the category the product is in, so it needs to find the products category id from cat_product table then find the category name using the category id then search against the search criteria.

     

    Complex :(

     

    Any help and suggestions please?

     

    Thanks,

    Blade

     

     

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.