How to make MySQL strict on types - development

How to make MySQL strict on types

Here’s the scenario, we are building a web application in Laravel, and assigned a route as follows:

Route::get('/sample/{client}', 'SampleController@SampleMethod')->name('SampleNaming');

The method SampleMethod, reads from the client variable and displays data about the client in the page.

if we go to http://localhost/appurl/sample/1 for example, it displays data about client id 1. The trick is that if we go to http://localhost/appurl/sample/1abc , it will still display the data for client id 1.

Tried the query in MySQL,

select * from clients where ID = '1abc'

It gave me the result for Client ID 1, turns out that MySQL checks the provided string and searches for the integer part in it and fetches the rows accordingly.

Surely, we can escape this in PHP / Laravel however my question is, is there a way to make MySQL strict on such scenarios?



from Laravel Questions and Answers https://laravelquestions.com/php/how-to-make-mysql-strict-on-types/
via Lzo Media

Comments

Post a Comment

Popular posts from this blog

ng-include of inline SVG does not display gradient except in Chrome

I have setup an NG-INCLUDE which loads an SVG file that has classes “hover_color_change” so that the correct polygons can have their fill attribute updated: <div class="prod-illustration-div col s12 m8"> <div class="prod-svg-wrapper" ng-include="'/img/illustrations/illustration_' + productIdObj.illustration + '.svg'" onload="defaultFill(productIdObj.colors)"> </div> </div> I then have color swatches which trigger the $scope.hoverColorText() which calls the updateSVGFill() method to display the SVG fill matching the hover color and creates a shading of gradient so it’s not a solid color. Here is live link – WORKS IN CHROME In Chrome it works, however, in Safari, FF, Edge, it does not. I referenced this suggested answer which suggests referencing the ID attribute, which I believe I am already doing: $scope.defaultFill = function (colors) { if (colors) { var defaultCol...
Read more

Using PHP and MySQL data to generate PDF letters like in MS Word mailmerge functionality - development

Using PHP and MySQL data to generate PDF letters like in MS Word mailmerge functionality I would really like to know if there is a way like MS Word mailmerge functionality that can be done using PHP and Mysql data. Like i have address data in MySQL (suppose 10 numbers) and through PHP i want to insert that address data in a pre-defined letter head area. And it will automatically generate 10 different letters with same content but different address in PDF. Can it be done? Any start up point will be helpful. As I am working on Laravel so any snippet of that sort will also be useful. Thanks in advance. from Laravel Questions and Answers https://laravelquestions.com/php/using-php-and-mysql-data-to-generate-pdf-letters-like-in-ms-word-mailmerge-functionality/ via Lzo Media
Read more

ng-show doesn’t work correct with value boolean

I have one issue like that: <input type="text" ng-model="keyword" ng-change="filterItemByName()"> <ul class="suggestion-list dropdown-menu" ng-show="isSearching"> <li ng-repeat="item in list"> <span ng-click="handleAction(item);"></span> </li> </ul> And here is the js: $scope.isSearching = false; $scope.filterItemByName = function(){ //handle for searh item $scope.isSearching = true; }; $scope.handleAction = function(item) { console.log(item); $scope.isSearching = false; }; The problem in here is, when input the keywork, my app will call an request to get the list (suggestions), but when i click on the item in the list, nothing happend, it doesn’t log anything, it didn’t call handleAction as is. I just found the problem related about the $scope.isSearching, when we show like above, the ng-click doesn’t trigger. But if i do : <ul class=...
Read more