webdevRefinery Forum: Marked - Viewing Profile - webdevRefinery Forum

Hi guys,

So I'm a hobbyist web dev. I am wondering how you guys manipulate associative array values, for example if I called the latest 5 posts from the database and I wanted to convert the timestamps into a readable dates.

So far I've been doing something like so

  $query = new Query("SELECT");
        $query->from("ibf_topics");
        $query->field("date"); //UNIX Timestamp
        $query->limit(5);
        $stmt = $query->prepare();
        $stmt->execute();
        $result = $stmt->fetchAll();

        $new_array = array();
        $count = 0;
        foreach ($result as $item) {
            $new_array[$count]['date'] = date("XYZ", $item['date']);
        }

Just wondering

Hi guys,

I'm wondering how to properly go about this.

I want to insert a row in the database when an event occurs. For example, a member makes his 100th post on the forum.

I was thinking of making an if statement in the index file, that would be an easy way for that particular event because the post count is called from the DB anyway.

So yeah, quite a general question but I was wondering how you guys would go about doing things like that.

Thanks in advance,
Mark.

Hi guys.

I'm using Hydrogren for my project. I started out with the demo which uses a URL structure that generally excludes the ending slash from the URL (which I thought it was a bit different, but nvm).

When the same url is loaded with the ending slash, a 404 is returned. What I would like to do when a forward slash returns a 404 error is test the same URL without a forward slash to see if no 404 is returned, and if not, the user is redirected to the URL without the ending slash.

On my site I have a whole bunch of URL's that do have a forward slash (I've integrated 3rd party software into the site), so the main thing I'm looking to achieve is taking a URL and testing to see if it doesn't return a 404 without the ending slash.

Hope that made sense...

Thanks in advance!

Hi guys,

I'm bout to write a tag system for an app on my site, I'm pondering how to go about it. I'm not sure if there's a standard or anything.

I use IPB and had a look at their tag system. They add a new row into the follow structure for each tag


Seems a bit over the top. Also doesn't look useful for searches. The main idea behind the tags is to use them in a search query, such as app/search/mytag

So what I'm thinking of doing is just making a 'tags' column and using implode to make a string like "tag1,tag2" etc. then using a query like

SELECT * FROM tags WHERE tags LIKE %{search query}%

or something.


Thoughts?

Hi guys,

This is the source code with errors highlighted by google chrome



I have no idea what's wrong with either of those lines (the errors shown directly below).

Any ideas?