• Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Formatting Dates

    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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching Formatting Dates

    How do i formatt the dates do the come out as DD/MM/YYYY please <?php $convar = mysqli_connect("localhost","root","","ffp_calendar"); if(mysqli_connect_errno()) { echo "Error occured while connecting with the database ".mysqli_connect_errno(); } $sqlvar …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching Storing PHP serialize/json_econde data

    I have a table that will have several fields, such as counties, age_groups, gender, sports, etc.. on countries I will be storing data with this format["US","CA","DK","FI","RU","SE"] on age groups I …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Storing PHP serialize/json_econde data

    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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Undefined Element ?

    > document.getElementById("five").style.width="800px"+backgroundColor="black"; > Sorry, how do you chain css styles in Js, concatenating with plus(+) doesn't work ? You can't chain by accessing the CSS properties via the *style* object. …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching can anybody guess the no of tables in database ?

    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 ?
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in can anybody guess the no of tables in database ?

    > 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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Undefined Element ?

    > I know, I fouled up. Food poisoning along a minor cold will cause this because of one cup of Hot Cocoa. > I wanted to overwrite the css.width with …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching LinkedIn icon for Simple Grid Theme

    Hi, I'M using the simple grid theme and I want to add a LinkedIn social media button on the top right that linkS to my LinkedIn profile. Most of the …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in LinkedIn icon for Simple Grid Theme

    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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in What are the available technologies to implement chat server application?

    > Hello Bob, I study in a terrible college in Indonesia, they are collaborating with other college abroad, and these assignment came from them, but my local lecturer is clueless …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Created Stored Routines: Word Filtering Inside the Database

    # 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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching Stored Routines: Word Filtering Inside the Database

    # 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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching MySQL Update Query

    Hey there. I'm building a project in PHP/MySQL and it is a sort of [FaceMash](http://en.wikipedia.org/wiki/History_of_Facebook#Facemash) project. I am able to call the images (with image name and points) from the …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in MySQL Update Query

    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 Bob Hensley
    Bob Hensley

    Began Watching What are the available technologies to implement chat server application?

    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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in What are the available technologies to implement chat server application?

    > 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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching SEO

    i want to leanr SEO audit..plzz help me
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in 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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Undefined Element ?

    > This code look right to you ? It's not changing my background color to blue :( JorgeM has provided you with the appropriate code. But to explain the situation: …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Undefined Element ?

    > It's the same method if instead of getting a class you got an id then you get the variable, and add the css rules, correct ? You can search …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching Include file question

    I have been trying to work around a problem but am not having much luck. I have classes that include a file with my db settings. The problem is I …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Include file question

    > > 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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching Facebook is useful or not?

    Facebook is useful or not? Regards
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Facebook is useful or not?

    > Facebook is useful or not? > > Regards In what context? General usage? As a marketing platform? For sales?
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching need help for make form with local db

    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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in need help for make form with local db

    > 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. …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Undefined Element ?

    > But what is the correct answer? Check my last post for a code example. As I explained, *getElementsByClassName()* is a function of all DOM elements. If you wish to …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching Anyone in for homeopathy?

    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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Anyone in for homeopathy?

    > 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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in mysql_result() error Help!

    > The user is the problem, not the backticks. I'd worry more about SQL injection in the above code then about backticks, and the fact that the mysql extension is …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching malicious JS code

    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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in malicious JS code

    > 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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching mysql_result() error Help!

    I have problem with this code show mi error Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\wamp\www\blogcode\resources\func\blog.php on line 34 function category_exists($name){ $name = mysql_real_escape_string($name); $query …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in mysql_result() error Help!

    > 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, …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching PHP defined functions

    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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in PHP defined functions

    > 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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching Building a website so it can be used as a management system

    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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Building a website so it can be used as a management system

    > 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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching Undefined Element ?

    var one = getElementsByClassName("orange")[0]; one.style.color = "orange"; The code above gives me the following error, why ? Error: 'getElementsByClassName' was used before it was defined.
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Undefined Element ?

    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*. …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching Split database data (tables, columns, data, etc) into various files

    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? …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Split database data (tables, columns, data, etc) into various files

    > 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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Began Watching Textarea border not showing in chrome browser

    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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Textarea border not showing in chrome browser

    > 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. …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in problem with time zone

    > how to include Europe time in this code? All of the information you need can be found within the two links I provided you. For example, if you want …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in How to integrate 93.5 FM radio to a website ?

    > 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 …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Please Mark as Solved.

    > 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' …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in problem with time zone

    > i want to set my own country time zone. That's a better explanation. Your first post did not even hint at that! You'll want to use PHP's [date_default_timezone_set()](http://php.net/manual/en/function.date-default-timezone-set.php) function. …
  • Member Avatar for Bob Hensley
    Bob Hensley

    Replied To a Post in Should this code work?

    > 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 …

The End.