Bienvenido al blog de Parzibyte. Vas a encontrar tutoriales y tips de programación, bases de datos, redes, electrónica e informática general. Ejemplos de código, aplicaciones gratuitas y open source
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here:
Cookie Policy
Although there are millions of tutorials about MySQL and PHP, I decided to make mine but in a very very simple way. Before you start, you must have a basic knowledge in MySQL.
Source code of PHP file connection
It is worth mentioning that we will not see good practices of databases, relationships, etc. We will use the tables as they are, without looking at normalization, or things like that.
Note: this tutorial uses PDO, but remember that we can also use mysqli functions. Personally I recommend PDO, because it is object oriented. However, I hope to write a tutorial about mysqli in the future.
In this post I will show you how to print a receipt in a thermal printer directly from web browser, without user interaction and confirm dialogs, by using a free plugin.
In this post I will introduce to you a plugin for printing tickets, receipts or invoices on a thermal printer using client-side JavaScript even if your web page or application is on a cloud server.
This plugin allows you to print directly from browsers, without dialogs and without browsers compatibility issues because you only have to send a HTTP request to print silently and in the background.
In this post I will show you how to print a ticket or receipt by using JavaScript (client side) and a thermal printer. At the end we will have a great ticket that looks like this:
Receipt printed in thermal printer using JavaScript only
Obviously you can change the font family, size, logo and so on. And remember: we will be using only pure CSS, HTML & JavaScript, no frameworks; though you can use any framework to render the content before printing.
You can see the demo here, and the full code on my GitHub.
Dialog and AlertDialog with custom layout on Android
In this post I will show you how to create custom dialog on Android using a layout created by us, that is, create a custom alert by adding elements such as EditText, Button, etc.
Custom alerts on Android serve to display an alert that is not a confirmation alert, since we can define a custom layout.
To achieve this we will use the Dialog and AlertDialog.Builder classes.
The express-generator package helps a lot in the development of web applications with Node, because it generates the skeleton of an application.
A small disadvantage is that, when generating the code, we do not know how to change some very basic things, for example, the port on which the app listens (the default port is 3000).
In this post I will show you how to change the port in some app generated by express-generator. Continue reading…
When we migrate customers from MijoShop to OpenCart there is a little problem: the methods to hash passwords are different and thus when our customers try to login the passwords do not match.
In this post I will show you how to migrate and fix the problem.
Today we will see how to reset the OpenCart password (e-commerce system in PHP) manually, directly in the database; generating the hash and the salt manually with a function created by me.
Function that generates salt and new password
Here I leave the code, and the explanation at the end.
The function returns an array that has the salt and the password, the way to call it is to pass the password in plain text. You can try and use the function here.
Once you have the salt and the password just do an update of your database table.
In my case:
My table is called oc_user because when I installed OpenCart I used that prefix, in your case it can vary.
The algorithm and the way that OpenCart uses it
Thanks to OpenCart is open source we can see how it generates the salt and saves the hashes.
It uses the function called token defined in helpers/general. php and then calls it, obtaining a random string of 9 digits. Then concatenate it and hash it with SHA1:
Hashed OpenCart password with SHA1
Finally, in the database it saves everything in the user table in the salt and password fields:
Salt location and user password in OpenCart database
Knowing all those things we could write a function that generates the salt and the password to be able to reset the password of a user manually in OpenCart.
In this tutorial I will show how to install OpenCart in its version 3 on a server with PHP. You can mount it directly on a server in production, or on your localhost for testing.
In this post we will see how to install Node.Js and NPM (Node package manager) in Android.
At the end we will be able to run Node.js applications as if we had a Linux server.
We will also see how to install dependencies using the npm install command, since it is a possible thing in Android thanks to Termux.
Specifically we will install version 6.9.0 of NPM and version 12.3.1 of node, although perhaps when you read this post you will install a newer version.
Install web server and process PHP files: build a LAMPP stack on Android
This is not a post of those who use tricks to attract visitors, we are really going to install an Apache server on Android, configure it to process PHP files and finally write a Hello World: everything running from our mobile device.
Android mobile devices are not designed to be servers (although some of them are powerful), however it is always interesting to see how technology advances and day by day we can do more things with our phones.
Today we will see how to install the MySQL or MariaDB server on Android, thanks to the Termux application. For that it is enough to execute a few simple commands and voila, we will have a MySQL database server in our Android; fully functional and ready to execute queries.
If we want to put it for production, we can do it as long as we configure security. In short, we will not see more advanced topics; we will only see how to install mysql on Android.
Here we will use MariaDB and MySQL as synonyms; that is, if you see that I say MariaDB do not get confused, I mean MySQL; and vice versa.
I know that there are really more differences especially with the licenses, but that is another topic and you can search it in Google if you wish.
Today we will see how to install and configure Termux on Android, as well as a brief introduction to its use.
Termux is an application that will allow us to have a terminal on our device, but apart from that it gives us the possibility of installing very interesting packages; and if we configure them well and install well, we can have a complete and stable server on our mobile.
This application does not require root access, you only need that our Android phone has a recent version (I think it works from Android 6).
