Please help contribute to the Reddit categorization project here

    bhoffman20

    + friends - friends
    5,582 link karma
    54 comment karma
    send message redditor for

    [–] What is sql injection? bhoffman20 3 points ago in ProgrammerHumor

    Tables are more like an Excel spreadsheet than a file. A database stores data in rows of these tables, and later looks it up with a sql statement that tells it, "Return a row where Column A has Value B."

    (SELECT * FROM Table where ColumnA = 'Value';)

    [–] What is sql injection? bhoffman20 3 points ago in ProgrammerHumor

    Check this out. It might help. Basically he was taking an input (Name) from the user and doing a SQL select statement to get information from a Database about a person.

    Since it's just using the String passed in to finish building the sql statement, and you can run multiple sql statements in a row by separating them with a semicolon, Bart can simply start his String with a quote (because Name is a String, it must be quoted in sql.) and a semicolon to end the statement.

    After that he can run whatever sql statements he wants, such as "DROP TABLE *;" Which would delete all of the tables from the database. He could put together as many sql statements as he wants by just separating them with semicolons.

    The final "--" is how you write a code comment in sql, essentially telling it to ignore the rest of the statement.

    [–] What is sql injection? bhoffman20 1 points ago in ProgrammerHumor

    If you're interseted, there's this. It's kind of a long post, but explains the concept pretty well, I think.

    [–] What is sql injection? bhoffman20 1 points ago in ProgrammerHumor

    Alternatively, there's this as well.

    [–] Ideas for a concrete baesment floor? (X-post from r/DIY) bhoffman20 1 points ago in HomeImprovement

    I really like this idea, it looks great in those pictures, and it seems like exactly what I need. I will definitely be looking into this.

    [–] Ideas for a concrete baesment floor? (X-post from r/DIY) bhoffman20 1 points ago in HomeImprovement

    Sorry, I updated the post in r/DIY, but forgot to do it here. Obviously fixing the leak is priority #1. I believe I found the leak, it looks like there's a crack in the mortar between the cinder blocks in the wall. The downspouts are all dumping ~12 ft. away from the house. I think the previous owner actually did some repair, because they told me the whole basement had standing water in it, and now it only gets a small puddle next to the wall. It doesn't look like the foundation is cracked or anything like that, but this is my first home, and I don't know much about what I'm doing yet. I'm going to try to seal up the crack today, but I'm just worried that next spring water could come in from somewhere else. I will take some pictures tonight and update the post.

    [–] ideas for a basement floor? bhoffman20 1 points ago in DIY

    Polishing was my first choice. I think it looks amazing, and there's really no mantainence to it. But I've been having trouble even finding someone in my area that is willing to do a residential basement, and even if I did find one, the floor isn't very level, and I think the worse it is, the more expensive it will be to polish.

    [–] data_irl bhoffman20 1 points ago in dataisbeautiful

    Not Data.

    [–] data_irl bhoffman20 1 points ago in dataisbeautiful

    Data.

    [–] Kind of an urgent question about an engine misfire bhoffman20 1 points ago in MechanicAdvice

    I've been telling her that all morning, she doesn't want to, but I'll keep trying to convince her.

    [–] Kind of an urgent question about an engine misfire bhoffman20 1 points ago in MechanicAdvice

    Hopefully that's all it is then, thanks a lot for responding