Home Solutions Showcase Articles Blog Quote Contact

Home » Pixelconnect Web Design Weblog

Pixelconnect Web Design Weblog

Jan
4
2010

Import a CSV file to MySQL via phpMyAdmin

Since there were no articles around for this topic from searching google, I thought I would write a short article on helping you import a CSV file to Mysql via phpMyAdmin.

I had recieved a large excel sheet, some 16k rows and 20 columns large, and needed to transfer this to mysql for a postage calculation. Ill lead you through the steps to achieve this process.

  • Name your columns appropriately in the Excel File
  • Set up identical columns names in correct order in the MySQL db
  • Export your excel document as a csv (the .csv should be the same name as your table set up in phpMyAdmin)
  • Open the csv file and cut the column names out (so they are on your pasteboard) that appear at the top
  • You should have just comma delimted data
  • Go to Import Tab and add the location of your text file
  • Select CSV using LOAD DATA
  • Check 'Replace table data with file'
  • Change Fields terminted to a comma, and remove enclosed and encapsulated fields
  • Paste the column names from your clip board into the column names field
  • Untick 'Use LOCAL keyword

Once submitted, the next page should like something like the above. If you have any questions, please post a comment.
Dec
21
2009

Web Design Manly

If you are interested in sourcing website design, or online information management system, feel free to get in contact with Manly Web Design company Pixelconnect, Located on the Beautiful Northern Beaches, for an obligation free quote with your business plan and website proposal details.

Manly Web Design

Benefits of working with someone locally in Manly:

  • Meet and interact with the web designers and developers
  • Be active and involved in the building process
Dec
13
2009

Did You Know

Awesome clip about current trends in the exponential times that we live in (With the awesome Fatboy 'Right Here Right Now' Theme song. A few that I liked.

  • The top 10 in demand jobs in 2010 did not exist in 2004
  • A super computer in 2013 will have a greater computational ability than the human brain, and in 2049, will have a greater computational ability than the entire human race.
  • There are 540,000 words in the English language, 5x more than in Shakespears time.
  • A weeks worth of news in the New York Times, is more information than what someone living in the 18th centuary would have come across in a lifetime
Dec
9
2009

Add Extra Fields in Drupal Contact Form

First Drupal Module!

This module will give you extra fields integrated into your drupal sitewide contact form, and include it into your email, configurable from Drupal Administration.

There are two options for adding a phone number. The first is a required field, which is added just below where the user enters there email. The second, gives 2 check boxes, in response to how they would like to be responded to (email or phone), and if they check reply via phone, a new text input slides down with jQuery for the user the place the phone number into. This was the original idea, and purpose of this whole project, since I found what I believe was a Wordpress plugin that did something very similar on another website, and decided to replicate it into Drupal.

A third option, allows you to choose a title, and add an additional text field. It has been defaulted to 'Company Name' as I couldn't seem to think of anything else at the time.

  • Working demo here
  • Download it here (Drupal 6)

If you would like any additional changes or extra options, let me know, and ill get back to you!
Jun
28
2009

Curl Curl Website Design

Northern Beaches agency Pixelconnect located near Curl Curl beach, is an established and successful website design and development agency, who focuses on building quality search engine friendly websites.

Our focus can produce excellent quality:

  • Blogging and Forum Community projects (Allowing customers to interact with other customers and your company!)
  • Social Networking and Search Engine Marketing (Getting your business found!)
  • Content Managment Solutions (Allowing you and your company to edit and maintain the website, when and where as desired without a fuss!)
  • Modern and Appropriate Design and Themes with Modern Technologies, to make your customers experience as smooth and enjoyable as possible.
  • Ongoing and Friendly Team to supply technical support locally on the Northern Beaches, near Curl Curl Beach!
Curl Curl Website Design
Curl Curl Pool, Northern Beaches, on sunrise, 2009

If you would like to get your company online with a strong web presence, in an affordable manner, please don't hesitate to contact us for a quote with your business details.
May
11
2009

Dee Why Website Design

Pixelconnect is a fast and growing new age web design company, providing customers around the Dee Why and wider Northern Beaches area with Web Design, Development and Online Marketing Strategies, for the last decade.

If your interested in gaining an online presence, to grow your business market, and client base, the internet has an exponential growth of opportunity and people to gain access to your online business.

Services that we can offer to our Lovely and Friendly Dee Why Residents include:

  • CMS Solutions - Allowing you to update and edit your publications and media online, without having to come to us.
  • Modern and Custom Web Design Solutions that make you stand out from the crowd. Check our growing portfolio here.
  • Cutting Edge front end and back end technologies, that allow your online website applications to be fast, smooth, and sleek, to help your customers enjoy their online experience on your company website.

To see more details, visit our front page here or our pricing and solutions here.

The beauty of having a local company, allows your business to interact with out designers and developers and help them develop the best online project from start to finish, as to satisfy and meet your companies goals and objectives.
May
4
2009

PHP CSS Theme Switcher with Cookies

Although i wrote this a while ago, figured id put it up to start my blog posts and test out how well google actually indexs’ these pages. It was also the first script i officially developed myself =)

Also it was rather relevant article to put up, due to there being absolutly no prewritten php scripts for this concept. I suppose most people are quite happy to do something like this in javascript (which is alot easier). But id figured to try and achieve this with php, for the simple reason of it being server side.

replace the first three variable names with the name of the style sheet you have available, ive used business, modern, web2 here as examples. you will need to have the style sheets uploaded on the same directory.

It is critical that this first section goes before the html <head> tag, and that there are no white spaces infront of the <?php tag, otherwise the browser will parse the white space, and the header will be already sent for the page, and not allow ’setcookie’ to work.

before doctype

<?php
$theme1 = business;
$theme2 = modern;
$theme3 = web2;
if(isset($_POST['style']))
{setcookie('style', $_POST['style'], time()+(60*60*24*1000));
$style=$_POST['style'];}
elseif(isset($_COOKIE['style']))
{$style=$_COOKIE['style'];}
else
{$style=$theme1;} ?>

head

<head>
<link href="<?PHP echo $style; ?>.css" rel="stylesheet" type="text/css" />
</head>

body

<body>
<form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post"> 
<select name="style"> <option <?php echo "value='$theme1'";
if($style == $theme1)
{
echo "selected='selected'";
}
?>><?php echo $theme1; ?></option>
<option <?php
echo "value='$theme2'";
if($style == $theme2)
{
echo "selected='selected'";
}
?>><?php echo $theme2; ?></option>
<option <?php
echo "value='$theme3'";
if($style == $theme3)
{
echo "selected='selected'";
}
?>><?php echo $theme3; ?></option>
</select><input type="submit" />
</form>
</body>

This switcher, will remember the option you have chosen with cookies (change this to a session if you would like), remember your selection in the drop down, and update the style sheet on first page load (a cookie wont take effect until the 2nd page load, since it is being set on the first page, so the selection was captured through the forms method variable).

Example here - (NB no style sheets uploaded, but you can view source to understand what i mean)
Apr
19
2009

Freshwater Website Design

Pixelconnect is a web design and development company located on the northern beaches near Freshwater Beach. Our design agency can help you with website design, development and online marketing, with a proven track record of success and experience over many years.

freshwater web design

Our specialties include, blogging platforms, content management systems (allowing you to edit your own website content), optimising websites for Google & Yahoo, E-commerce Platforms, and website security.

Since we are local at Freshwater, this means that you can have a hands on approach, and interact with the team, feeling as though you have an input to the process in building the website, so it fits to your companies goals and directions perfectly.
Apr
19
2009

Balgowlah Website Design

If your business is looking for a website design company to move your business into the 21st Century, Pixelconnect has the local Balgowlah website design services and skills to help you with your business goals.

Our company offers experienced award winning web design services, with search engine optimization strategies to help push your business to the front page of Google, and gain high traffic results. Additional Technical and Online Software solutions are available at your disposal to get the best result that we can for yourself, and especially for your customers.

The benefits that we are local in Balgowlah to you, means that we can visit and interact with the design and development phases, and feel like you have an input into the design and development of your company website.

Checkout our Solutions and Pricing and get in Contact with us for a website quote.
Apr
17
2009

Seaforth Website Design

Pixelconnect is a up and coming web design company, located near Seaforth on the Beautiful Northern Beaches.

Pixelconnect can offer a variety of online services such as website design, website development, graphic design, technical online development, online application development, blogging platforms, content management solutions, online marketing maintenance, adword account managment, search engine optimisation, keyword marketing, modern web technologies and most importantly local and interactive team to help translate your business objectives into a viable online solution.

Having a team nearby can help you translate your business objectives into a successful online solution, and allow you to feel involved in the process of building and developing your web presence for your northern beaches and global customers.
  Website Design Northern Beaches © May 2013 | ABN: 29 288 517 592
FolioArticlesBlog