Web Development Source
A collection of notes, sources and turotials for your development journey
git – the simple guide
just a simple guide for getting started with git. no deep shit 😉
How to make multiple routes share the same URL structure or URL parameters
If you have the following URLs: (They all share the first part of the URL –Â /control-panel/{team_id}) Then you don’t have to write out the routes
A Basic Guide to SQL Server Stored Procedures
A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.
SQL Server Stored Procedure Parameters
When you call this stored procedure, it just simply runs the query and returns a result set.
In this tutorial, we will extend the stored procedure which allows you to pass one or more values to it. The result of the stored procedure will change based on the values of the parameters.
SQL Alias – AS Keyword
Alias is used to give an alias name to a table or a column, which can be a resultset table too. This is quite useful in case of large or complex queries.
PHP PDO object & prepared statements.
This is a short PHP tutorial on how to use the wildcard character when using prepared statements with the PDO object. In this guide, I will show you how to bind the wildcard and the string you are attempting to match to a given parameter.
