Posts
 
Reputation
Joined
Last Seen
Ranked #1K
Strength to Increase Rep
+5
Strength to Decrease Rep
-1
96% Quality Score
Upvotes Received
30
Posts with Upvotes
23
Upvoting Members
23
Downvotes Received
1
Posts with Downvotes
1
Downvoting Members
1
3 Commented Posts
3 Endorsements
Ranked #486
Ranked #686
~44.9K People Reached
About Me

I'm a web developer and marketing professional by day; database theory junkie by night. Born and raised in New England, I live in Concord, NH (just an hour or so outside of Boston) with my lovely wife and son. I'm a technologist, and thoroughly enjoy…

Interests
Trying new restaurants... especially when there's fresh seafood on the menu. Finding new local beers…
Favorite Tags

76 Posted Topics

Member Avatar for vegaseat

*We can't solve problems by using the same kind of thinking we used when we created them.* **Albert Einstein** I love this quote and feel it can be applied to most anything.

Member Avatar for Reverend Jim
15
13K
Member Avatar for LastMitch

I went and saw Skyfall in theaters last night. I'm not typically a James Bond fan but I enjoyed the movie.

Member Avatar for LoanHensley
6
6K
Member Avatar for Magic8Computing

The example at Rproffitt's link is on the right track. You'll want to reference [PHP's Date/Time Supported Date & Time Formats list](http://php.net/manual/en/datetime.formats.date.php) to ensure MySQL's *CURDATE()* function returns a date formatted in a manner that works. Thankfully *CURDATE()*'s standard output is YYYY-MM-DD is an OK format to work with. $format …

Member Avatar for benanamen
0
311
Member Avatar for Bob Hensley

# MySQL Stored Routines: Another Useful Scenario # [In a past guide](http://blog.bobbyhensley.com/sql-procedures-functions-authentication-example/) I discussed MySQL stored routines within MySQL. Now I’m back with another guide on MySQL stored routines. And this time it’s a more concrete case; one that you may run into yourself in the future (or maybe you …

Member Avatar for batuzai04123
2
517
Member Avatar for robert_14

> Facebook is useful or not? > > Regards In what context? General usage? As a marketing platform? For sales?

Member Avatar for goodtaste
0
340
Member Avatar for Reapt

> Newbie programmer here. I want to really learn C#. Other than VS what other IDE's are there? Mono is probably the next most popular IDE after Visual Studio. It's not bad, I've used it sparingly over the years. But I think you'll find that you're better off sticking to …

Member Avatar for JOSheaIV
0
264
Member Avatar for iAssistant

Hot and humid here in Lima, Peru. I recently moved here (wife is Peruvian) from New Hampshire, USA. Bit of a change, as I'm sure NH was high 40s/early 50s today.

Member Avatar for Stuugie
0
4K
Member Avatar for ddanbe

> I'm not. > My idea is: if you want to stop a tsunami(a disease) you have to build a strong, huge concrete wall(a medication), a pebble(a dilution of a dilution?) will have little effect. I don't believe homeopathy has a place in modern medicine. When you're sick enough that …

Member Avatar for jwenting
0
734
Member Avatar for extjac

Typically speaking, it is very bad practice to store serialized (or JSON) data in a database. This is big, red flag that you are not normalizing your database. Thus you're going to have dependencies all over the place, and it will make maintaining your data an absolute nightmare. Could you …

Member Avatar for extjac
0
157
Member Avatar for adamchippy

Where are you defining the $row variable? And what is it defined as? Also, what data type is the *row* attribute in the table

Member Avatar for GliderPilot
0
264
Member Avatar for Siberian

The function *getElementsByClassName()* needs to be called on a DOM object. Simply put- you need to tell it what it should be searching through. Very often this is the *document*. But you could limit its scope to a table, a DIV, etc. etc. `var one = document.getElementsByClassName('orange')[0];`

Member Avatar for Siberian
1
191
Member Avatar for junaid_5

> file.php?sub=3&main=10&date=2010-04-20 > sub value has max 3 and main has max 10 , can anybody tell me how many tables or columns this website has ? Even if this information is readily available in the query string, why is it important to you?

Member Avatar for junaid_5
-1
111
Member Avatar for gogs85

> Table names and column names must not be surrounded by single quotes, but by backticks. Backticks are really unnecessary unless you are using reserved words as labels. Fact is, they're a MySQL construct and not defined by the ANSI SQL standard. Using the backticks will limit you strictly to …

Member Avatar for pritaeas
0
193
Member Avatar for ahmedzahir
Re: SEO

> i want to leanr SEO audit..plzz help me Can you expand on that, please? Do you want us to perform an SEO audit? Or are you trying to, as I'm assuming is the case, learn how to perform SEO audits yourself? And if that's the case, are you familiar …

Member Avatar for mamahadija
0
205
Member Avatar for ecleary

The directory containing the other images: [BLOG-ROOT]/wp-content/themes/simplegridtheme/images/ http://www.manwithavandublin.ie/wp-content/themes/simplegridtheme/images/ You're going to need to modify your own image though, I'm afraid. [LinkedIn provides their logo](http://press.linkedin.com/logo-images) in numerous formats, just for this kind of situation. But you'll need to resize and greyscale it, to make it fit in per your theme.

Member Avatar for Bob Hensley
0
311
Member Avatar for Wisnu_1

> Hello, I've got an assignment where I'm told to create a chat room application. I have already created the application using Java. But I am also asked to research at least three different technologies to implement chat room application, but I only know one... that is using Java Sockets. …

Member Avatar for Bob Hensley
0
317
Member Avatar for begueradj

> Howdy, > > I am looking to download a list of malicious JS code in order to test it on my localhost website I am developing. > Is there any place to download such a list ? > > Thank you in advance for your answer. > Begueradj What …

Member Avatar for iamthwee
0
286
Member Avatar for Ole Raptor

> > I found it. > include($_SERVER["DOCUMENT_ROOT"]."/filepath"; I'd just like to point out that there's a syntax error here: you omitted the terminating parenthesis. I would also recommend, if this file is critical to your application, you use the *require_once()* function instead.

Member Avatar for Bob Hensley
0
155
Member Avatar for ali.win

> hi > i want to make a form with html but i want get that information in a local database like access db or sql db in my pc. > how can i do it? plz help me with code or info about that. > tanx alot guys You're …

Member Avatar for Bob Hensley
0
109
Member Avatar for saadi06

> Hi, > I have a question regarding php defined function. I want to see the logic implemented for all the php defined functions. How can I see that. For example I want to see what is the logic behing strstr or how strtolower works.Where can I see in wamp …

Member Avatar for jkon
0
209
Member Avatar for Muni123

> hi, > I need a few opinions on this, I am sort of new to web dev. I'm intending on building a website for > a charity, where the charity workers will be able to add charity events to their website. Vulnteers of the charity will then be able …

Member Avatar for Bob Hensley
0
180
Member Avatar for rubai

> Hi all, > > I have a contact form. In the message text area the right border is not showing in chrome browser. It is cool in other browsers. > here is the link http://theshortstoriesonline.com/amarnamrub/ > > Thanks The issue is stemming from the *slideInLeft* class on the label …

Member Avatar for rubai
0
1K
Member Avatar for Doogledude123

> I was just thinking about all of the unsolved threads, the ones that actually are solved, and I was thinking, maybe @Dani could add a 'Please Mark as Solved' button that users could click to notify the owner of the thread that they should mark it as solved. > …

Member Avatar for Dani
4
341
Member Avatar for riahc3

> I would like to be able to store data in various files instead of one huge one to make remote backups easier on MySQL. How can I set this up? > > Thank you You asked this question a week ago. I even posted and you never responded. I'll …

Member Avatar for riahc3
0
274
Member Avatar for hapiscrap

> How do you create a spritesheet? You would use a graphics editing application. Adobe Fireworks is popular for this, Photoshop is always a viable option, GIMP would be a free option, and the list goes on. A spritesheet is simply one single image containing multiple sprites. Within the game …

Member Avatar for hapiscrap
0
184
Member Avatar for riahc3

> We have various databases on several offsite locations and we want to do a backup to here. Problem is that database is problably going to weigh GBs of data so it would be better to split it into several "files" so we can only get the updates in small …

Member Avatar for riahc3
0
372
Member Avatar for vitalisz

> hello all i have problem with time zone What is your problem? The code you posted does not hint at the issue. For that matter, code practically never speaks louder than a good explanation by the author. Please explain what problem(s) you're running into and what you've tried to …

Member Avatar for Bob Hensley
0
167
Member Avatar for chaitu11

> Any source code available I'm assuming 93.5FM is a radio station local to your area? And that you want to stream that radio on your web page? If that's the case then check out the site for that station; it's possible they provide streaming options. The only way this …

Member Avatar for Bob Hensley
0
84
Member Avatar for RikTelner

> Does it work? Nope. > What's wrong with it? A very good tool when writing front-end code is the developer console. Chrome and Firefox have this built in. I would encourage you to seek it out and use it religiously. You'll catch any and all JavaScript errors and where …

Member Avatar for Bob Hensley
0
120
Member Avatar for stokie-rich

> Hope someone can help me, someone has suggested that i change sql to sqli That person gave you very valuable advice. The original MySQL extension, which you're using, has been deprecated as of PHP 5.5. Development on the MySQL extension ended years ago. Even if you disregard the deprecation …

Member Avatar for Bob Hensley
0
230
Member Avatar for KonRadicool

> Hey Everyone > > Just wandering what are the best ways that you have used to generate a steady online income so far. Could you give some recommendations and tips for someone who is really starting out. > Regards > Konrad What exactly is your skillset?

Member Avatar for KonRadicool
0
200
Member Avatar for AmrMohammed

> Greetings, > > I'm having a table that I need to retrieve its data in a specific order based on a column value(s). I need to retrieve first all rows that have the value 0 in that column in ascending order (default order) then rows that have value(s) greater …

Member Avatar for Jefferson_1
0
204
Member Avatar for hiiiiii@

If you really need these variables set in JavaScript then you might do the following: var today = new Date(), nextMonth = new Date(); nextMonth.setDate(nextMonth.getDate() + 30);

Member Avatar for hiiiiii@
0
278
Member Avatar for joshl_1995

> Hello Community, > I'm about to start making a website for someone. So what I'd like to know is does the website creator credit themself, like have my name in the footer of the page. > > What is the right way to go about doing this? Simple question …

Member Avatar for joshl_1995
0
236
Member Avatar for student71

Are you referring to how it's 9i (the "i") and 10g (the "g")? If so then it's simply marketing. The letter has no significant importance.

Member Avatar for jwenting
0
104
Member Avatar for misge

> how can i develop pen pal program through pen pal I understand what a pen pal is, but I have no clue what you're actually referencing. What is a pen pal program? And what do you mean by "through pen pal?" Are you actually familiar with C++?

Member Avatar for mcconnell_34
0
110
Member Avatar for centenond

> Hi, i working on a profile system, each users has their public profile and its directory is in http://website.com/username but the proble is that my root is gonna get a bit messy if all folders of each user is created ther, so i want to put all users folder …

Member Avatar for centenond
0
257
Member Avatar for RikTelner

> I am about to make website, where explain my skills (if any), kind of portfolio. > I'd like to make two seperate choices in menu, > one for the client-side work (HTML, CSS, JS) and > one for the server-side work (PHP, SQL) seperately. > > I thought of …

Member Avatar for RikTelner
0
195
Member Avatar for ckide

> Wow to Assembly!! Yeah, ASM is rather cryptic to look at. And the simplist of tasks requires more work than you'd think.

Member Avatar for vmanes
0
415
Member Avatar for waqarulsalam

> I want to become a great programmer and software devolper. Start now then. Programming is not a career you prepare for strictly through school. I've always said software development is very much a hobbyist profession. If it's not something you enjoy doing or you are not self-driven to learn …

Member Avatar for Bob Hensley
0
92
Member Avatar for PulsarScript

> Hi all,how do i link lets say thankyou.html page to my conatct.html page,so the idea is after submiting the page,by pressing the > submit button,the confirmation page should pop up. Thank you. You would set the action attribute of the form element to "thankyou.html", if that's where you wish …

Member Avatar for Bob Hensley
0
191
Member Avatar for carlosvz21

Okay, if I am understanding this correctly: you wish to include a file depending on which sales option has been chosen? Here's a simple demonstration: <?php if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['soptns'])) { $salesFiles = array ( 'ns': 'ns.inc.php', 'pt': 'pt.inc.php', 'sp': 'sp.inc.php', 'up': 'up.inc.php' ); $chosen = $_POST['soptns']; if …

Member Avatar for Fernando_4
0
231
Member Avatar for fiey.hamzah

Where is $GroupCode being defined? The lack of a definition (due to it being indicative of having register_globals turned on) is more worrysome than the rest of the issues in your code. Let's start with that and work our way through it.

Member Avatar for Szabi Zsoldos
0
290
Member Avatar for mattyd

Does *writeMessage()* work correctly (ignoring the lack of style)? Please post that function so that we might work on altering it to facilitate your needs. > My email vaildation is working correctly now. > > But, I would like to alter the message color from black to red by styling …

Member Avatar for JorgeM
0
101
Member Avatar for Anubhav_1

I'm confused on why you're using MySQLi in your insertion script, yet the original *and long-since dropped, but now officially deprecated*, MySQL extension. Using the original MySQL extension is incredibly inappropriate these days. You have some MySQLi usage in your project; standardize on it and take advantage of [parameterized statements](http://php.net/manual/en/mysqli.prepare.php)

Member Avatar for Bob Hensley
0
227
Member Avatar for vanitha.A

> I am beginer of php. > Now only i have learned inserting deleting and implemented in my website now i need to insert image,, > What is your logic behind wanting to store the image within the database system instead of the regular file system? It's not that it's …

Member Avatar for urtrivedi
0
151
Member Avatar for Harry_5

`if($results = mysql_num_rows($sql_query)) !== 0) //here!!!!` That line is throwing an error because you have closed both parenthesis, but then continued on to use a conditional operator. It looks to me that you attempted to do this: `if (($results = mysql_num_rows($sql_query)) !== 0)` Perhaps most importantly: I would strongly encourage …

Member Avatar for diafol
0
1K
Member Avatar for kal_crazy

The outlook for programmers is good. IT as a whole is thriving as far as number of jobs, and those opening up, goes. The career opportunities are rather endless outside of game development. You could go to work for a software house, contributing to whatever software it is they sell. …

Member Avatar for HoverportMedia
0
208
Member Avatar for dean.ong.14

Using *mysqli_error ()* **won't** solve the problem. Rather, it'll aid in diagnosing it. What is the output received when you kill on *mysqli_error*? The PHP error you're receiving is due to a bad query, so the output of *mysqli_error* is critical.

Member Avatar for dean.ong.14
0
1K
Member Avatar for satbir4

> Hi all, > > I have more than 50 pages in a site. suppose, in every page i want to write "ABC" and edit every some days. Please anybody tell me the code how i can call ajax file in php. And complete code for both files. First off, …

Member Avatar for almostbob
1
295

The End.