I am using a raspian OS for my python projects, and most of the cases I run the scripts directly using a virtual environment. For the cases that i need to use a compiler like Python IDLE a way to open it from within the virtual environment is by running the following command, after you enable it of course.
python -m idlelib.idleAssuming that i have the following list
fruits=['mango','apple','orange','peach'] and from this list I want to create a new list randomly selecting specific number of values
then this is how it is being done for two random values of the fruits list
import random
random_fruits = random.choices(fruits, k=2)which results to
fruits=['mango','peach'] Today`s project was to generate an rss feed for the records in my web-project site using simple xml.
I new that most of the work had already been done, since i created the sitemap for my project. Check here.
So with a little search on the net i found some help. I am not going to write down all the steps that i ve taken to modify code written by others..but just to share some useful resources in case some novice php developer needs to do the same..
Initially i matched my existing code with the example written by Spotless Web Design. What a great and descriptive article…
Most of the word had already been done, but i needed to add some more quality stuff in the raw xml file like the atom link, so i got some more help from this guy.
Finally in order to validate the rss, i visited FeedValidator a couple of times.
That`s it for today … Next project is to link this RSS feed with an IFTTT rule to automatically post images to pintrest and twitter.. lets see how this goes.
I was trying to find an easy way to duplicate a table row in mysql, and it appears that mysql can handle that pretty easily. Just Use:
insert INTO `server`.`ad` (`adgrp`,`adname`,`ad`,`adlink`,`adtype`,`adprovider`,`visible`) SELECT `adgrp`,`adname`,`ad`,`adlink`,`adtype`,`adprovider`,`visible` FROM `server`.ad where idad=46;
to duplicate any row on any table, or use the CONCAT() function to add text to the newly created row. In my case i needed to set the name just to be “_copy” of the original one:
insert INTO `server`.`ad` (`adgrp`,`adname`,`ad`,`adlink`,`adtype`,`adprovider`,`visible`) SELECT `adgrp`,CONCAT(`adname`,"_COPY"),`ad`,`adlink`,`adtype`,`adprovider`,`visible` FROM `server`.ad where idad=46;
In the case above the idad column is of course the primary key and auto-increment, so it cannot be copied.
For my developing project i use Mysql and Dreamweaver set up with Wamp. I would say that i very familiar with databases and how to handle data etc..
Prerequisites to this project was that i could not modify either my php.ini or mysql.ini, since i am on a shared hosting plan.
One issue I had and could not fix though was that i got question-marks for special characters like quotes or Cyrillic or French characters using ascent. I did work on this many hours but with no luck. Today i finally have managed to solve it. Here is how:
Since all my databases already have data and are online, i created copies of them using the correct charset. So:
1. I Exported all the tables in my databases using mysqldump and recreated them using utf8 character set and utf8_unicode_ci table/column collation. This is essential to make sure all data are saved in the correct format
2. I made sure that all my pages had the following two meta tags in the head tag:
<meta charset="UTF-8" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
3. Finally, and that is what was missing all this time, is to make sure that all communication with the database is done through UTF. Apparently this does not happen automatically when you set the php encoding and the database collation/encoding. To do so, every time you query your database, you need to specify the communication encoding format.
mysql_select_db($database_localhost, $localhost);
$query_collections = sprintf("Select * from table WHERE packbrand=%s and serial='1' AND VISIBLE='1' order by collection asc", GetSQLValueString($colname_collections, "text"));
mysql_query("set names 'utf8'");
This last part basically fixed it.
What did not work for me:
One down many to go. Move to next project.