Friendsnippets

1. connection a une base de donnée MySQL en C

   view plain - save this

   Code en C permettant l'accès a une base de donnée MySQL C code wich permit MySQL access

    1 /*********************************************************
    2 **Attention il est impératif de compiler ce code avec l'option de compilation -lmysqlclient
    3 **********************************************************/
    4 
    5 #include <stdio.h>
    6 #include <errno.h>
    7 #include <stdlib.h>
    8 #include <iostream.h>
    9 #include <fstream>
   10 #include <mysql/mysql.h>
   11 #include <sys/types.h>
   12 #include <sys/wait.h>
   13 
   14 #define MY_SERVER_HOST "localhost"
   15 #define MY_SERVER_PORT 0
   16 #define MY_ACCOUNT "root"
   17 #define MY_PASS "test"
   18 #define MY_DB_NAME "itest"
   19 #define MY_TABLE_NAME "test_tbl"
   20 #define MY_UX_SOCK NULL
   21 #define MY_CLIENT_FLAG 0
   22 
   23 void main()
   24 {
   25         MYSQL *mysql;
   26         MYSQL_RES *res;
   27         MYSQL_ROW row;
   28         MYSQL_ROW rowchamps;
   29         const char *query;
   30         string qutmp;
   31 
   32         int t,f,tt,ff;
   33 
   34         mysql=mysql_init(NULL);
   35 
   36         if (!mysql_real_connect(mysql,MY_SERVER_HOST,MY_ACCOUNT,MY_PASS,bd,MY_SERVER_PORT,MY_UX_SOCK,MY_CLIENT_FLAG)) {
   37                 printf( "Erreur de connexion : %s\n",mysql_error(mysql));
   38         }
   39         else {
   40                 qutmp = "SHOW FULL COLUMNS FROM TABLE ";
   41                 query = qutmp.c_str();
   42                 t=mysql_real_query(mysql, query, (unsigned int) strlen(query));
   43                 if((res=mysql_use_result(mysql))) {
   44                         f=mysql_num_fields(res);
   45                         while((row=mysql_fetch_row(res))) { 
   46                                 for(f=0;f<t;f++){
   47                                     cout<<row[f]<<endl;
   48                                 }
   49                          }
   50                          mysql_free_result(res);
   51                 }
   52         }
   53         mysql_close(mysql);
   54 }
   

   first posted by cybersax to c c c++ ... saved by 7 persons ... 0 comments ... 1 year, 2 months

2. Envoyer un mail html avec python

   view plain - save this

   Comment envoyer un mail au format html en python. Pratique pour de gros envois de mail.

    1 import smtplib
    2 import MimeWriter
    3 import mimetools
    4 import StringIO
    5 
    6 def sendHtmlMail(to,frommail,text,html):
    7 	encoding = "base64"
    8 	charset = "iso-8859-15"
    9 	 
   10 	#déclaration des buffers
   11 	out = StringIO.StringIO() 
   12 	htmlin = StringIO.StringIO(html)
   13 	txtin = StringIO.StringIO(html)
   14 		  
   15 	#déclaration et initialisation du writer
   16 	writer = MimeWriter.MimeWriter(out)
   17 	writer.addheader("Subject", text)
   18 	writer.addheader("MIME-Version", "1.0")
   19 	writer.addheader("From", frommail)
   20 	writer.addheader("To", to)
   21 	writer.startmultipartbody("alternative")
   22 	writer.flushheaders()
   23 					   
   24 	#ajout de la partie text
   25 	textPart = writer.nextpart()
   26 	textPart.addheader("Content-Transfer-Encoding", encoding)
   27 	pout = textPart.startbody("text/plain", [("charset", charset)])
   28 	mimetools.encode(txtin, pout, encoding)
   29 	txtin.close()
   30 							    
   31 	#On ajoute la partie html
   32 	htmlPart = writer.nextpart()
   33 	htmlPart.addheader("Content-Transfer-Encoding", encoding)
   34 	pout = htmlPart.startbody("text/html", [("charset", charset)])
   35 	mimetools.encode(htmlin, pout, encoding)
   36 	htmlin.close()
   37 												     
   38 	#on clot le mail
   39 	writer.lastpart()
   40 	mail = out.getvalue()
   41 	out.close()
   42 	smtp = smtplib.SMTP("localhost")
   43 	#smtp.connect()
   44 	smtp.sendmail(frommail, [to], mail)
   45 	smtp.close()
   

   first posted by Fufu to python python mail ... saved by 7 persons ... 0 comments ... 1 year, 2 months

Pages : 1