Jump to content


NigelRel3

Member Since 07 Mar 2017
Offline Last Active Nov 02 2017 09:21 PM

Posts I've Made

In Topic: Why my basic insertion won't work?

24 April 2017 - 03:10 PM

You are trying to insert into 3 values for your insert statement and bind only 1.


In Topic: Help needed in select command using table A and B

18 April 2017 - 02:54 PM

OMG! All this time I have been slaving away making sure of my case usage and now I find out what you knew all the time.
Don't know what made me think that case mattered....

What an idiot I am!

I think it's better to maintain the same case anyway - using Linux a lot means you tend to get used to the fact that case matters in a lot of things (which is why table names can be case sensitive)

 

I'm a fan of camel case and I think it makes things more readable - but inconsistent use of case for the same field can (IMHO) lead to confusion.


In Topic: Help needed in select command using table A and B

18 April 2017 - 02:23 PM

You do realize that sql statements use case-sensitive names for the fields?

Although consistency of names IMHO is important, just to clarify ( from https://dev.mysql.co...ensitivity.html )

 

Column, index, stored routine, and event names are not case sensitive on any platform, nor are column aliases.


In Topic: In laravel 5.4 retrieving with several criteria

18 April 2017 - 08:27 AM

You could build an array of conditions, where can take something like...

$binT = \App\BinType::where([['binTypeID', '>', 1], ['sizeX', '<', 10]])->get();

So if you get to the end of all the possible conditions, you can make a choice of including the where only when you know there are criteria to use.


In Topic: no data going to sql

17 April 2017 - 06:58 PM

Have you looked at using HTML5 required attribute - this will do a lot of the work for you!