3

Still waiting for links UI. For a bit of entertainment I looked up some amazing contributions UniqueIdeaMan has made to the web. Here's a great one:

Problem is, googling brings out forums and forums are full of amateurs too with amateurish samples

So, let's stop helping him, clearly we're too amateurish.

On a brighter note, here's another person hitting the nail on the head.

Jesus Christ, dude. You have no ****ing clue what you are doing and just stabbing your **** around hoping to hit something. You're submitting your form using GET and then looking for POST. Do you even have an idea what those words mean? What's the difference between them?

The first ****ing thing you do is realize your IF condition is failing if you don't see an echo result, so a normal person would take a look in $_SERVER to see what's going on. Well, a normal person would understand the basics by this point and know what POST and GET mean.

I know you're trying to learn, man, but you keep coming in here with syntax errors. You have no understanding of the basics.

1

As a SQL contractor who comes across computer-generated messes like this rather frequently, I'd like to make a suggestion. Break this up into manageable chunks.

Here's your query with syntax highlighting:

Screen_Shot_2017-08-18_at_12_38_15.png

Attempting to do the case statements alongside aggregate functions with a load of joins and criteria is complex, but you can make it easier by creating an intermediate view that just does the select and case statements. Then, from that view, try to add your where clause. If that's all fine, now try adding the aggregates (sum and group by).

1

Since the odds are against me then how-about I pay you nothing if I lose but you pay me everything of your wealth if you lose ? Can you afford to bet like this ? I doubt it! Programmers in other forums have told me my ideas are good enough that they told me to shoot the top 10 sites in the world without talking too much. One even pleaded me to not reveal my ideas to the "clowns in the forum". Therefore, I have stopped).

You've not had any ideas though, because if you did you wouldn't be wasting your time arguing on here and you'd be building something. How about you point me at the homepage of one of your world beating projects, or to a patent detailing your top ten websites in the world ideas and then I'll apologise and admit that you're not a complete sham?

That sounds like a fair bet to me; and at this point I'd rather send you £100 than admit you have a clue.

So, the challenge has been set, UI has the simple task of pasting a URL to one of his creations, ideas or projects. If he can, all is forgiven and I'll let him continue conquering the world. If he can't, he's a phony.

4

I think you misunderstood UI

It's not the first time.

The general consensus is that UniqueIdeaMan's ideas are indeed unique. Unfortunately they aren't the good kind of unique.

This hasn't only been established here. Benanaman on codingforums knows the score. And Mittineague on sitepoint's forums goes as far as claiming that he is

missing a basic understanding of how things are.

As the old saying goes, there's no smoke without fire.

The nicest possible thing I can say about UI is that he is clueless timesink.

Votes + Comments
Please can we not resort to name calling. If you have nothing nice to say ...
3

UI, I'm still waiting for you to share the details of your browser that is on the verge of setting the world on fire. Please can you post some information or I won't be able to remove you from the "bullshitting timewaster" category that you are currently a member of.

Votes + Comments
The last two set the world on fire showed me a hacked up firefox and chromium based browser. Both were infested with spyware. "It's my feature!"
1

So how come the link is marked as broken in my post? It works just fine.

https://help.qwant.com/help/overview/how-does-qwant-index-the-web/

The button to continue to the page should be more strongly coloured than the 'go back' button, too. Without having full trust in the 'is the link dead' checker, it's probably what most people want to do. If it is dead, they can just click back.

Votes + Comments
The link worked once for me then mysteriously broke.
1

The main question is the amount of work it would take to build your own search engine

Building a search engine that works well would be incredibly complicated. Having it index a decent enough chunk of the web to be useful would be incredibly expensive. Getting people to actually favour your search engine over what's already out there would be almost impossible.

Keep in mind, when Microsoft needed a search engine they didn't build one from scratch. They already had the dated and not-very-successful MSN search, plus they went out and bought Powerset, Farecast and VideoSurf (probably others, too).

3

Because, when I mentioned my browser somewhere (that revolves around my big ideas), one of the major international advertising company (from where the money would be coming from to the browser users) read the concept and told me not to go ahead publicising it anymore unless they get back to me.

So are you going to show us this world-beating browser?

Votes + Comments
Show me the money! (or broswer.)
3

Yes, you can definitely normalise further, like with the nutrients approach @diafol suggests, but you need to know the data before making a judgement on whether it's worth it.

There are advantages and disadvantages in cases like that.

Votes + Comments
Thanks for the advise!
1

Should I turn those into an extra column or should they become seperate tables?

They should definitely be stored in a separate table (say, food_category) and you should add an appropriately-named foreign key to the table you posted (let's called that food).

In SQL, you'd use a statement like this to create the tables with the foreign-key relationship in place, note the references line:

create table food_category (
        id     serial primary key,
        name   varchar(32) not null unique
);

create table food (
        id          serial primary key,
        category_id int references food_category(id) not null,
        name        varchar(32) not null unique,
        calories    numeric,
        cholesterol numeric,
        sugar       numeric
);
2

On another note, this is where the StackOverflow 'style' of questions and answers, with plenty of non-nonsense moderators, works well.

Homework questions like this are good for nothing. If the student can't be bothered to formulate a sensible question they are weakening whatever community is left and making it more difficult for any potential non-chump users to find something worth reading.

If someone has made an effort and posted some code that's stripped down to the essentials and well-formatted, I'm more than happy to go out of my way to help. When it's a case of

NEED STUDENT ATTENDANCE SYSTEM PLS HALP

Yeah.. no.

As someone of Indian descent, it's pretty embarrassingly focussed, too.

1

For every image you want to store a separate watermarked version of that image. So, you need a 'task' that runs per upload. For your already-uploaded images you need to also be able to run that task.

In Rails, let's say you have a class called Image with method generate_watermark

class < ActiveRecord::Base

  after_save :generate_watermark, if: :image_changed?

  def generate_watermark
    ...
  end

end

So, this method is called every time the image is changed. Easy. Now, for your backlog you need to call this method for every Image that has no watermark. Fire up a Rails console:

Image
  .where(watermark: :nil)
  .each(&:generate_watermark)

Easy, huh? You'd use the same approach in Laravel.

2

Back in 2012, I once built a .exe bot that finds you WP blogs that still have their commenting section open and then posts your comment.

Well done, your posting bot has obviously evolved to posting to forums and ever since you added the Rambling::Bullshit module and pointed it at daniweb.com it's gone from strength to strength. Keep up the good work, with all your amazing ideas you're clearly destined for the top.

2

Another advantage of Python (and other interpreted languages) is that you can learn the syntax much more quickly and easily while using a REPL. For those who don't know, you can just type in code and it evaluates it and prints the result:

>>> colours = ["red", "yellow", "pink", "green"]
>>> for colour in colours:
...     print(colour)
...
red
yellow
pink
green

If you make a mistake, you'll see it as soon as you hit enter.

>>> for colour in colours:
...     print(uh_oh)
...
Traceback (most recent call last):
  File "<stdin>", line 2, in <module>
NameError: name 'uh_oh' is not defined

For people learning to code, this is way more intuitative and less frustrating than the way I learned many years ago; the feedback loop is much tighter and there isn't much that can go wrong inside a REPL, you don't have to take the extra steps of learning to use a compiler and a shell, troubleshoot non-executable files and permissions and other things that we don't think twice about but trip up newbs.

1

I'd start by getting someone who speaks native English to proof-read your text. I'd also drop the name Microsoft from your company name, it's likely to make potential customers think you're a scam outfit. Get rid of the obviously fake customer reviews and dodgy stock photos.

Think about what you are actually trying to provide and make that clear on your site. Summarise it in 3 sentences and throw away everything else.

Getting backlinks by posting useless questions in other support forums and having the URL in your sig isn't going to do you any good in the long run, I'd nip that in the bud.

2

Using tables for borders like that is no longer required, it's very brittle (as you've found out) and unnecessarily fiddly.

Drop shadows can be implemented with a single line of CSS:

.card.login-form {
  margin-top: 8rem;
  box-shadow: 6px 6px 66px 6px rgba(0,0,0,0.39);
}

Here's how your login form would look using a modern CSS framework (Bootstrap, here). Code is here. Screenshot below:

Screen_Shot_2017-06-21_at_11_46_10.png

1

I don't envy the task ahead of you Dani. There just isn't the enthusiasm there once was.

Tech support has largely been supplanted by stackoverflow, the social/discussion aspect by Reddit, Facebook, etc.

Maybe putting DW on ice and concentrating on Dazah making inroads into its intended market is best. The idea sounds like it could work and things that grease the wheels of commerce tend to, but without a solid example of a market where it's actually connecting people I think it's going to be an uphill struggle.

I get the impression (and would bet you agree) that the current users of Daniweb, the fifteen or twenty regular posters and the people needing homework help aren't the cohort you need to be targetting.

Votes + Comments
Clear thinking
2

So you're building an OS and an IDE but the contents of a project file are confusing?

Just do yourself a favour and use something built by experts until you see a shortfall that you'd like to address.

Note, I'm not saying don't build an OS, an IDE or a language, but don't try to do all three at once unless you are Fabrice Bellard.

Votes + Comments
That's Fab!
Nice!