Skip to content

Tarik Billa

  • Web Development
    • html
    • vue.js
    • laravel
    • css
    • javascript
    • jquery
    • node.js
    • php
    • asp.net
  • Programming
    • python
    • java
    • c
    • c++
    • c#
  • git
  • android

mysql

Why shouldn’t I use mysql_* functions in PHP?

August 24, 2022 by Tarik

The MySQL extension: Is not under active development Is officially deprecated as of PHP 5.5 (released June 2013). Has been removed entirely as of PHP 7.0 (released December 2015) This means that as of 31 Dec 2018 it does not exist in any supported version of PHP. If you are using a version of PHP … Read more

Categories php Tags mysql, php Leave a comment

How can I prevent SQL injection in PHP?

August 24, 2022 by Tarik

The correct way to avoid SQL injection attacks, no matter which database you use, is to separate the data from SQL, so that data stays data and will never be interpreted as commands by the SQL parser. It is possible to create an SQL statement with correctly formatted data parts, but if you don’t fully … Read more

Categories php Tags mysql, php, security, sql, sql-injection Leave a comment

Should I use the datetime or timestamp data type in MySQL?

August 23, 2022 by Tarik

Timestamps in MySQL are generally used to track changes to records, and are often updated every time the record is changed. If you want to store a specific value you should use a datetime field. If you meant that you want to decide between using a UNIX timestamp or a native MySQL datetime field, go … Read more

Categories mysql Tags datetime, mysql, sqldatatypes, timestamp Leave a comment
Newer posts
← Previous Page1 … Page413 Page414

Tarik Billa

Software Engineer
tarikbilla@gmail.com
+8801884414000
  • Reuse a hash in YAMLApril 17, 2024
  • Dockerfile: how to redirect the output of a RUN command to a variable?April 16, 2024
  • How to cd to a directory with spaces in the directory name?April 16, 2024
  • Maximum MIME type length when storing the type in a databaseApril 16, 2024
  • What is the difference between Unit, Integration, Regression and Acceptance Testing?April 16, 2024
© 2026 Tarik Billa