Articles

How to install DRACULA theme in NOTEPAD ++

Image
How to install DRACULA theme in NOTEPAD ++ Step1: Download this folder :  https://www.dropbox.com/sh/3qu5xo8mk1egw6n/AAAFogo6ZnqCfB5ps66sSTDJa?dl=0 Step 2: Inside the folder copy the file named Dracula.xml Step 3: Open RUN , and type this command:  %AppData%\Notepad++\themes Step 4: Paste the Dracula.xml inside the folder Step 5: Now Restart Notepad ++ Step 6: Now go to Setting, Style configuration in THEME choose DRACULA. Enjoy !!!

How to send mail by mutiple People using JAVA

Image
Requirement:  1) You need to have JAVA  installed in your PC 2) You need to configure JAVA in your PC, to test if JAVA in configured in your PC. Open Command Prompt in type: JAVAC if you have a response means JAVA it's installed 3) You need a JAVA MAIL library you can download it here: https://www.oracle.com/technetwork/java/javamail/index-138643.html 4) You need to add this code in your IDE. can be (BLUE J, NETBEANS or ECLIPSE) 5)You need an INTERNET connection 6) COPY and PASTE this code in your IDE: import java.util.Properties; import javax.mail.Message.RecipientType; import javax.mail.MessagingException; import javax.mail.Session; import javax.mail.Transport; import javax.mail.internet.InternetAddress ;  import javax.mail.internet.MimeMessage; import java.util.Properties; import javax.mail.Message.RecipientType; import javax.mail.MessagingException; import javax.mail.Session; import javax.mail.Transport; import javax.mail.internet.InternetAddr...

Display current DATETIME form MYSQL database using Select command

Image
Let's say we have a database called atest and a table called atest with a column called DateT with those date values: +---------------------+ | DateT               | +---------------------+ | 2018-10-05 13:53:34 | | 2018-10-04 00:00:00 | +---------------------+ We know want to display with SELECT command the first date time with is:    2018-10-05 13:53:34 Here is the query for that:    select * from atest where DateT >= cast((now()) as date)and DateT< cast((now() + interval 1 day) as date); And if you have a column which is DATE only use this query:  select * from atest  where DateT = CAST(CURRENT_TIMESTAMP AS DATE) ;

How to make Arithmetic operation on mysql DATABASE EASY

Image
Let say we have a table called transaction and differents columns  we want to make this operation montant=500 -100 with the column  idtransaction  and montant  Step 1: Write this command in mysql: update transaction set montant= montant -100 where idtransaction= -1; The result is: 400 We did a minus operation 500-100 = 400  in mysql 

Comment changer le password d'un compte windows

Comment changer le password d'un compte windows  Etape 1: Ouvrez CMD en mode Administrateur Etape 2: Tapez NET USER, Une liste d' utilisateur va s'afficher, Etape 3: Tapez NET USER suivit du nom d'utilisateur puis * Exemple: NET USER BLOGGER* Etape 4: entrez le nouveau mot de passe Etape 5 : enter, pour valider.

How to change account password in Windows PC using CMD

How to change account password in Windows PC using CMD Step 1: open cmd as Administrator Step2: Type: net user , All user are shown in the panel Step 3: Now type net user [Username] follow by * Example: net user blogger* Step 4: Enter your password Step 5: Hit enter to validate.

Comment prendre les données d’un formulaire EXCEL pour les ajoutées dans une base de donnée MYSQL ? EXCEL a MYSQL

Image
       Comment prendre les données d’un formulaire EXCEL pour les ajoutées dans une base de donnée MYSQL ? EXCEL a MYSQL Etape1: Installer Wamp server sur le PC Etape 2: C r ée   un fichier excel appel é  le try.csv ce fichier contient le champs name et email , peupl é  ce champs de valeur,  puis sauvegarder le dans le meme dossier ou se trouve le script et le library PHPEXCEL:  https://www.dropbox.com/s/ncnvkhbsrs79w98/PHPExcel.rar?dl=0 Etape 3: Note : il faut que le library PHPEXCEL soit dans le même dossier que le script Voici le script (code) PHP permettant de prendre les données dans un fichier Excel( try.csv ) pour les mettrent dans une base de donnée : <?php $connect = mysqli_connect("localhost", "root", "", "test");   //$file = $_FILES["excel"]["$absolute_path"]; // getting temp orary source of excel file   include("PHPExcel/IOFactory.php"); // Add PHPExcel Library in th...