Posts by Bob Hensley

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 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 = 'd/m/y';

$todaysdate = new DateTime($rowvar['CurrentDate']);
$weekdate = new DateTime($rowvar['WeekStartDate']); 
$perioddate = new DateTime($rowvar['PeriodStartDate']); 

echo $todaysdate->format($format);
echo $weekdate->format($format);
echo perioddate->format($format);

Now obviously I pulled the format out and stored it in a variable, which you may or may not choose to do. If you're running different formats for the various dates, you wouldn't want to. But this way, if you are keeping them the same format, your code follows the DRY principle a bit more.

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 paint a more complete picture on what all of this data is and how it's being used? I'd be happy to help you design better schema, but I need the bigger picture

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. You either need to modify them seperately, or all at once via cssText.

// Separately
elem.style.width = '800px';
elem.style.backgroundColor = 'blue';

// cssText
elem.style.cssText = 'width: 800px; background-color: blue';

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?

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 the with in the javascript, I've noticed this is not possible ?

You just want to set the element's width with JavaScript? This is very possible.

var sour = document.getElementById('two'),
  width = '500px',
  bgColor = 'blue';

sour.style.cssText = 'background-color: ' + bgColor + '; width: ' + width;

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

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 and doesn't know what he's teaching. that's why I'm asking it here, because I believe people in this website has more knowledge than my lecturer, hahaha.

But I do think what they mean by technology is same as yours. I'll research more on web sockets and ajax as you suggested! But is there any advantages or disadvantages of using one over another?

Both have their place. In a chat application, however, I would say Web Sockets hold an advantage over Ajax.

It's a true TCP connection, supporting communication in both directions (full-duplex, as you'll probably see it called). It's a persistant tunnel, where data is pushed from client-to-server and server-to-client.

Ajax, on the other hand, is a way of making asyncronous HTTP requests. It's not a persistant mode of communication. Each new request, to pull updates, is a new session with the server.

In a past guide 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 already have)! Let’s jump right on, shall we?

You’re implementing a comments system to your application. Users will be able to comment on articles you and your staff post. A concern arises: explicit comments. It’s something all web developers have to deal with: people being crude and just not decent at all.

Chances are your first intuition would be to filter explicit words in the application code. Maybe you hard-code the words into an array. Perhaps you put them in the database. Either way, you’d be handling the manipulation within the application code instead of the database.

In data-driven applications there will always be a juggle: how much should be handled by the application and how much by the database itself? I firmly believe that we should pass the buck off on the database anytime it makes sense. And in this scenario, I believe it makes sense.

By using stored routines we can push more responsibility onto the database. Should your application really care about what words are not allowed? I don’t believe so. After all, if the data is clean and secure then …

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

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.
Is there any other technology? if there is, what is the easiest to implement a chat room application (and the server)?

Actually I still don't understand the word "Technology", whether that means the programming language used to implement the application or some frameworks or other things. Note that I'm still a beginner in programming :(.

I'm sorry if this question is too basic and stupid but I really have no idea. If anybody could help me then I will be really grateful. Thank you.

The word "technology" can be used many different ways. I tend to use it when referring to protocols or broader topics. But many will, and not incorrectly, use it as a more encompassing term. In such a situation, languages themselves may be considered seperate technologies. You're best bet is to ask the proctor for the exam to define technology.

A couple other "technologies" that might be used: Web Sockets and Ajax (on an interval).

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 with SEO to begin with? Or is this an entirely new subject for you?

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:

You have, once again, forgotten to use the method on a DOM element. What are you searching through? You're searching through the document, presumably. Thus your definition needs to read:

var sour = document.getElementById('two');

Second, your backgroundColor statement is just right out invalid. backgroundColor is a method of style, which is a method of a DOM element. As such, it needs to be written like so:

sour.style.backgroundColor = 'blue';

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 by ID as well. A nonsense example:

// can only return one, so no need for array index
var elem = document.getElementById('the_id');

elem.style.cssText = "color: #f00; font-weight: bold";

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.

Facebook is useful or not?

Regards

In what context? General usage? As a marketing platform? For sales?

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 going to need to use a technology on the server itself that is able to communicate with their an Access database or relational database. Traditionally MySQL would be used, but maybe you have preferences otherwise (MariaDB, SQLite, Postgres, SQL Server, etc.)?

If you do go with MySQL then this can very easily be done via PHP and its MySQLi extension.

It's really not possible for us to help you any further, with the information you've provided. Nor can we write a script for you without seeing your form. Not that we should anyways- this is a good learning exercise.

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 learn more then I would encourage you to check out the MDN documentation on this function.

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 medication is necessary, it's not a matter of activating the "healing system" of your body. It's about augmenting it with chemical agents that will more specifically attack the cause of the illness.

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 deprecated ;)

You'll hear no disagreement from me on those points. I suppose I have a bit of a pet peeve in regards to backticks. I often wonder if they would've become so widly used if phpMyAdmin didn't include them in its SQL output.

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 sort of malicious scripts are you looking for? For example, here's a collection of malicious scripts.

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 MySQL; should you ever port to Postgres, for example, you will need to rewrite every single query.

That may not be a big deal, if you're confident you'll never move off the MySQL platform. But backticks are also a vector for bad practices: using reserved words and being allowed to do so. It's a poor practice, and one that will result in problems the moment a backtick is forgotten. Better to just forgo them all together, in my opinion.

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 these definitions.
Thanks in advance.

PHP is an open source project. If you want to, you can download the source and look at how those functions are defined. Or you can browse through it via PHP's Github account, found here.

The strstr() function, for example, can be found in ext/standard/string.c:

/* {{{ proto string strstr(string haystack, string needle[, bool part])
   Finds first occurrence of a string within another */
PHP_FUNCTION(strstr)
{
    zval *needle;
    char *haystack;
    int haystack_len;
    char *found = NULL;
    char needle_char[2];
    long found_offset;
    zend_bool part = 0;

    if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "sz|b", &haystack, &haystack_len, &needle, &part) == FAILURE) {
        return;
    }

    if (Z_TYPE_P(needle) == IS_STRING) {
        if (!Z_STRLEN_P(needle)) {
            php_error_docref(NULL TSRMLS_CC, E_WARNING, "Empty needle");
            RETURN_FALSE;
        }

        found = php_memnstr(haystack, Z_STRVAL_P(needle), Z_STRLEN_P(needle), haystack + haystack_len);
    } else {
        if (php_needle_char(needle, needle_char TSRMLS_CC) != SUCCESS) {
            RETURN_FALSE;
        }
        needle_char[1] = 0;

        found = php_memnstr(haystack, needle_char,  1, haystack + haystack_len);
    }

    if (found) {
        found_offset = found - haystack;
        if (part) {
            RETURN_STRINGL(haystack, found_offset, 1);
        } else {
            RETURN_STRINGL(found, haystack_len - found_offset, 1);
        }
    }
    RETURN_FALSE;
}

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 to see the charity event on their smart phone divices. In addition,
using their smart phones vulnteers can suggest types of fundraising to the charity, the suggestions are then updated to the website which can then be approved and reviewed by the authroised charity workers. Is this a good idea? can a website like this be used as a mangement system?

There's no reason why it couldn't be. Everything you've mentioned is very much in the realm of possibility.

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];

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 try again:

Are you using the InnoDB engine? Or is it MyISAM?

If you are using InnoDB then look at XtraBackup. I'll do what you're looking to accomplish: make backing up more efficient.

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 housing the textarea. Removing that class actually remedies the issue. Specifically, it's the animation, as removing the -webkit-animation-name property from the class will fix the problem.

It looks like you're using a downloaded animation stylesheet. It may be more worth your time to just apply a patch, instead of trying to locate the root of the issue. One simple patch would be to put the border on the label and remove the border from the textarea. A couple inline styles and you'll be good to go.

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 to set the timezone to Europe/Rome:

date_default_timezone_set('Europe/Rome');

This isn't a random value, however. I linked you to the page before, but I'll do it again: all timezones supported are listed here.

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 is possible is if the broadcast is being put online at some point.

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.
Obviously, this could be abused, but if we put specific limitations on it, lets say, only let the user click it once, or limit its use to Moderators only, then maybe we could all help clean up the "unsolved" threads.

Just an idea.

I think the majority of those who leave threads unanswered are people who came here for the sole purpose of asking that question. They have little to no ambition to partake in, or care about, this community or any of its nuances.

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() function. You can see the list of supported timezones here.

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 they're occuring. You can also then use console.log() to track down pesky issues throughout your script.

Anyways, two issues with your code:

("html, body").animate({

You need to begin this statement with the $ character. Otherwise you're going to get an error about an undefined function.

$("."+id)

This is actually going to search all elements for those with a class of the given ID. Not ID, as you're intending. The selector notation for an ID is the pound sign (#)- just as it is in CSS.

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 you should be aware that it is missing features that make it very worthwhile to convert for (chiefly parameterized statements. Your code is extremely vulnerable to SQL injection attacks; parameterized statements are your solution.

As for your problem:

$b=mysql_select_db("database_name",$a);

This is your problem. In submit_form.php you haven't declared a value for $a. You have in config.php, though. But you don't bring in config.php for over 10 more lines. Fix this by requiring config.php at the top of your script.

Also, you're declaring $b in config.php. No need to do it in submit_for.php as well.

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 do to remedy it.

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 amounts.

How can this be done in MySQL?

Are you using InnoDB, per chance? If so I would encourage you to use XtraBackup. It's designed to do just this: efficiently backup large databases.

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 you would load the single spritesheet and then only display one portion at any given appropriate time. It's more efficient to load into memory the single image than dozens more. Hence why spritesheets are used.

So keeping that in consideration: I would grid out the spritesheet into equal sections and ensure no one sprite exceeds said dimensions. Or at least not in a way you cannot effectively account for within your engine.

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?

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 is: are you being paid (be it salary or agreed-upon fee per-project) for this web site? If you are then you're likely giving whoever is paying you the right to use your code without any branding. Mileage will vary here, as it's possible to collect payment but still retain all rights and reservations, but that's less common.

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.

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 word "Coding" for client-side work.
But which word could I use for server-side work,
assuming visitor has no idea what the difference is.

I suppose you could use "design" and "development" for client and server, respectively.

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 Visual Studio unless you have a very convincing reason to not use it. Especially given Microsoft provides the Express edition free of cost.

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++?

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 in a folder name users, but then the url be like http://website.com/users/username

Is it posible to some how when enter http://website.com/username still get the content of http://website.com/users/username

Thanks and sorry for my bad english

This is a good scenario for using Apache's mod_rewrite module. With it you can manipulate the URL and where it actually goes.

In this case you want to redirect everything to the users directory. Below is an example of how to do that. It checks to make sure the request isn't an actual file or directory first. If it is then you'll serve that and not a file in the users directory.

<IfModule mod_rewrite.c>
    RewriteEngine On

    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d

    RewriteRule ^(.*) /users/$1
</IfModule>

If the URL entered is (for example) http://domain.tld/someusername, this rewrite rule will actually serve http://domain.tld/users/someusername. The end-user will be none-the-wiser that their request is being modified internally.

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 (and continue learning), then it's not a profession you will succeed in.

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 than 0 in a descending order.

This sounds like two queries to me:

SELECT cols FROM table WHERE col = 0 ORDER BY col ASC
and
SELECT cols FROM table WHERE col > 0 ORDER BY col DESC

It's the pairing of the conditional and return order that makes me think this has to be done in two queries. But you can union the two:

SELECT cols FROM table WHERE col = 0 ORDER BY col ASC
UNION ALL
SELECT cols FROM table WHERE col > 0 ORDER BY col DESC

You can eliminate duplicate results by dropping the ALL statement from UNION.

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 the form to submit to.

contact.html

<!DOCTYPE html>
<html lang="en">
    <head>
        <title>Form Example</title>
    </head>

    <body>
        <form action="thankyou.html">
            <input type="email" name="email" placeholder="Enter your email address." />
            <input type="text" name="subject" placeholder="Email Subject" />
            <textarea name="body" placeholder="Say something..."></textarea>
            <button type="submit">Send</button>
        </form>
    </body>
</html>

Part two - how to set up php so the request/submited page is sent to my email

There are many ways this can be done. I'll demonstrate one simple way:

Edit your contact form so that it points to the right file (thankyou.php, not thankyou.html- assuming a conventional web server configuration) and make it use HTTP POST instead of HTTP GET.

<form action="thankyou.php" method="post">

Then, in thankyou.php:

<?php

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $returnEmail = (!empty($_POST['email']) ? htmlentities($_POST['email']) : '');
    $subject = (!empty($_POST['subject']) ? htmlentities($_POST['subject']) : null);
    $body = (!empty($_POST['body']) ? htmlentities($_POST['body']) : null);

    if ($subject && $body) {
        mail('you@yourdomain.tld', $subject, "{$body}\n\nReturn email: {$returnEmail}");
    }
}

?>
<!DOCTYPE html>
<html lang="en">
    <head>
        <title>Form Example</title>
    </head>

    <body>
        <p>Thank you</p>
    </body>
</html>

What we're doing is checking to see if the page has been requested via HTTP POST (it will have been if the form was submitted). We then go through the fields we have …

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 (array_key_exists($chosen, $salesFiles)) {
        require_once($salesFiles[$chosen]);
    }
}

We first check to see if we're responding to an HTTP POST request (the form has been submitted). If so, has the sales option been passed through?

Assuming it has, we declare an associative array containing the legal sales option values. The values in this array are the files to be included. The purpose of this array is to define what file belongs to each possible option. It's a whitelist, if you will. And we can grab the chosen value by simply referencing $_POST['soptns'].

If the array contains a key equal to the given option then it's legal. So we check for that. And ultimately we then include the file by grabbing it from the array and passing it to the require_once() function.

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 it somehow.

I have attempted such things as:

Code Redacted

The insertion being:

message.style.color == 'red';
The result is the entire script breaks.

Any ideas? Should I be using CSS for this?

Thank you,
Matthew

Wow to Assembly!!

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

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.

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