Read… and study it!
http://us2.php.net/manual/en/function.flock.php
Comments (0) Posted by sp on Monday, May 4th, 2009
Filed under Programming
This macro will allow you to extract a url/mailto from excel and place it into the next cell.
To see more options: Click here
CODE:
-
Sub ExtractHL()
-
Dim HL As Hyperlink
-
For Each HL In ActiveSheet.Hyperlinks
-
HL.Range.Offset(0, 1).Value = HL.Address
-
Next
-
End Sub
Comments (0) Posted by sp on Saturday, May 2nd, 2009
Filed under Programming
CODE:
-
<select name="date">
-
<option value='01'>01</option>
-
<option value='02'>02</option>
-
<option value='03'>03</option>
-
<option value='04'>04</option>
-
<option value='05'>05</option>
-
<option value='06'>06</option>
-
<option value='07'>07</option>
-
<option value='08'>08</option>
-
-
<option value='09'>09</option>
-
<option value='10'>10</option>
-
<option value='11'>11</option>
-
<option value='12'>12</option>
-
<option value='13'>13</option>
-
<option value='14'>14</option>
-
<option value='15'>15</option>
-
<option value='16'>16</option>
-
<option value='17'>17</option>
-
-
<option value='18'>18</option>
-
<option value='19'>19</option>
-
<option value='20'>20</option>
-
<option value='21'>21</option>
-
<option value='22'>22</option>
-
<option value='23'>23</option>
-
<option value='24'>24</option>
-
<option value='25'>25</option>
-
<option value='26'>26</option>
-
-
<option value='27'>27</option>
-
<option value='28'>28</option>
-
<option value='29'>29</option>
-
<option value='30'>30</option>
-
<option value='31'>31</option>
-
</select>
Comments (0) Posted by sp on Monday, April 13th, 2009
Filed under Programming
Same issue with states I have with dates lol
CODE:
-
<select name="month">
-
<option value = "1">January</option>
-
<option value = "2">February</option>
-
<option value = "3">March</option>
-
<option value = "4">April</option>
-
<option value = "5">May</option>
-
<option value = "6">June</option>
-
<option value = "7">July</option>
-
<option value = "8">August</option>
-
<option value = "9">September</option>
-
<option value = "10">October</option>
-
<option value = "11">November</option>
-
<option value = "12">December</option>
-
</select>
Comments (0) Posted by sp on Monday, April 13th, 2009
Filed under Programming
This always drives me crazy, finding a quick dropdown for the 50 us states. So here you go!
CODE:
-
<select name="sale_state">
-
<option value="AL">Alabama</option>
-
<option value="AK">Alaska</option>
-
<option value="AZ">Arizona</option>
-
<option value="AR">Arkansas</option>
-
<option value="CA">California</option>
-
<option value="CO">Colorado</option>
-
<option value="CT">Connecticut</option>
-
<option value="DE">Delaware</option>
-
<option value="DC">District of Columbia</option>
-
<option value="FL">Florida</option>
-
<option value="GA">Georgia</option>
-
<option value="HI">Hawaii</option>
-
<option value="ID">Idaho</option>
-
<option value="IL">Illinois</option>
-
<option value="IN">Indiana</option>
-
<option value="IA">Iowa</option>
-
<option value="KS">Kansas</option>
-
<option value="KY">Kentucky</option>
-
<option value="LA">Louisiana</option>
-
<option value="ME">Maine</option>
-
<option value="MD">Maryland</option>
-
<option value="MA">Massachusetts</option>
-
<option value="MI">Michigan</option>
-
<option value="MN">Minnesota</option>
-
<option value="MS">Mississippi</option>
-
<option value="MO">Missouri</option>
-
<option value="MT">Montana</option>
-
<option value="NE">Nebraska</option>
-
<option value="NV">Nevada</option>
-
<option value="NH">New Hampshire</option>
-
<option value="NJ">New Jersey</option>
-
<option value="NM">New Mexico</option>
-
<option value="NY">New York</option>
-
<option value="NC">North Carolina</option>
-
<option value="ND">North Dakota</option>
-
<option value="OH">Ohio</option>
-
<option value="OK">Oklahoma</option>
-
<option value="OR">Oregon</option>
-
<option value="PA">Pennsylvania</option>
-
<option value="RI">Rhode Island</option>
-
<option value="SC">South Carolina</option>
-
<option value="SD">South Dakota</option>
-
<option value="TN">Tennessee</option>
-
<option value="TX">Texas</option>
-
<option value="UT">Utah</option>
-
<option value="VT">Vermont</option>
-
<option value="VA">Virginia</option>
-
<option value="WA">Washington</option>
-
<option value="WV">West Virginia</option>
-
<option value="WI">Wisconsin</option>
-
<option value="WY">Wyoming</option>
-
</select>
Comments (0) Posted by sp on Monday, April 13th, 2009
Filed under Programming
I'm not sure why, but I always forget how to remove a border on an iframe... funny.
CODE:
-
frameborder="0"
Comments (0) Posted by sp on Monday, March 30th, 2009
Filed under Programming, Javascript
Fantastic solution was found here:
http://www.jsnippet.com/?p=103
Comments (0) Posted by sp on Tuesday, March 24th, 2009
Filed under Programming, Javascript
I always run into this little problem - how to check all and uncheck all checkboxes no a single page. Heres a nice easy solution.
CODE:
-
function checkAll()
-
{
-
if(document.getElementById('checkallbox').checked == true) // the element that you will check to check all boxes.
-
{
-
var checks = document.getElementsByName('CHECKBOXNAME');
-
for(var i=0;i<checks.length;i++)
-
{
-
checks[i].checked = true;
-
}
-
}
-
else
-
{
-
var checks = document.getElementsByName('CHECKBOXNAME');
-
for(var i=0;i<checks.length;i++)
-
{
-
checks[i].checked = false;
-
}
-
}
-
}
Enjoy!
Comments (0) Posted by sp on Saturday, March 21st, 2009
Filed under Programming
Its quite simple actually - you create your favicon.ico file (which is normally 16x16) in an graphic editor you choose.
Next upload it to your website. Once uploaded add the below code to the header of your website:
And your done!
Comments (0) Posted by sp on Thursday, February 26th, 2009
Filed under Programming
How to preview a site in plesk, well its very simply once you know how.
https://YOUR_IP_ADDRESS_HERE:8443/sitepreview/http/SITE_YOU_WANT_TO_VIEW/
Newer versions of plesk have this feature enabled on your sites control panel, you will see an icon called "Site Preview". However; this is not on older versions. So for example you want to view a site called helloworld.com.
You would do:
https://YOUR_IP_ADDRESS_HERE:8443/sitepreview/http/helloworld.com/
Hope this helps someone lol
Comments (0) Posted by sp on Thursday, February 26th, 2009