(Full HD) New Mili Naghma "PAK WATAN" By Junaid Jamshed, Noman Shah, An...

Installing Apache ant

Ant is a favorite build tool for most of front-end developers & is an excellent choice for JavaScript also. Ant install is like a breeze on MAC but is a bit tricky on Windows. The instructions below are only for Windows 7.

1. Make sure JDK is installed already from http://bit.ly/V7yv7Z. For my purpose I have used x86 version instructions would also be on the same lines.
2. Download the .zip for the binaries from http://ant.apache.org/bindownload.cgi.
3. Extract the binaries on the path C:java\ant\ where [java] and [ant] would be self created folders you can store in any directory structure of your preference.
4. Set up Environment variables with the names JAVA_HOME & ANT_HOME.
5. To set up the variables › Right Click My Computer › Click Properties › Click Advanced system settings  › Click Environment Variables › Click New System Variable.
6. For ant variable name would be ANT_HOME and value would be c:\java\ant\.
7. For JDK depending on the version and platform i.e. x86 the path would be c:\Program Files (x86)\Java\jdk1.7.0_09. The version 1.7.0_09 might only differ if you have installed the x86 platform base of JDK in the default location seleted by JDK installer.
8. Open Command Prompt & from there go to c:\java\ant\bin and type command ant and you should get the message Buildfile: build.xml does not exist!
   Build Failed!
9. This means ant is installed properly and looking for build.xml
10. If you want to be able to run ant command from anywhere while inside Command prompt need to add your ant path in my case which is C:\java\ant\bin to Path environment variable there will be other paths also there each separated by semi-colon(;).

Create daily mysql backup with task scheduler

Here is one example of creating daily backup of mysql database and keep the database file on another sever for later use.
creat one batch file mysql-backup.bat. and keep this code in the batch file.

@echo off
echo Running dump...
C:\wamp\bin\mysql\mysql5.5.20\bin\mysqldump.exe -e -uexampleuser -ppass123 --result-file="\\path-to-server\dbbackup\foo-db-%DATE:~10,4%-%DATE:~7,2%-%DATE:~4,2%.sql" foodb
echo Done!

Then create a scheduled task and run this batch file. So it will take the daily backup and will keep different name depend on the server date.

You can ignore some tables if you like

@echo off
echo Running dump...

C:\wamp\bin\mysql\mysql5.5.20\bin\mysqldump.exe -e -uexampleuser -ppass123 --result-file="\\path-to-server\dbbackup\foo-db-%DATE:~10,4%-%DATE:~7,2%-%DATE:~4,2%.sql" foodb --ignore-table=foodb .mdl_log --ignore-table=foodb .mdl_sessions

echo Done!

keep in mind that you have to give your mysqldump.exe path and also the path of the file, where you want to keep your db dump.

Run cron jobs on Windows

You can just cron your jobs in windows environment with just one line. I have almost spent my 5 hours so i want to share with other is make a task.

 

In program give php.exe path, with my installation it is c:\wamp\bin\php\php5.3.5\php.exe.

 

Second you have to put the file absolute path, which you want to run. -f c:\wamp\www\foo\foo.php in the argument

So that's complete. There is no need for installing anything.

Array

Array:
Array is a group of items similar in properties.
Item consist of two items, key and value.
PHP is loosely typed, so there is no need to define the array at the begining and there is no need to tell the size before using it.
Create an array with array() keyword.

Moving Data to Drupal / Ubercart

Update (August 2011): We’re now recommending that people try using the Migrate module (http://drupal.org/project/migrate) first, before trying a custom-coded import solution. Use with MigrateUI, and check their list of required modules carefully (depends on version of Drupal you’re using). The solution below is for situations that Migrate can’t handle well, or where you need to do imports that tie into custom modules that have their own data tables. We’ve also built a similar importer as a Drupal module (its highly customer-specific – if there’s demand we can look at generalizing it) which can work well in situations where you need a quick upload and import inside the admin panel with a well-defined data layout (i.e. a CSV product list).

The following blog entry describes the solution to an issue encountered by Jeremy and Nathan in moving data from an old website to a new one. Based on a brief search for a solution, it looks like many other people may find a use for the (admittedly rather crude) code that we wrote to solve the problem. We hope this helps!

We’ve recently had to convert data from an old custom-built shopping cart, to a new website based on Drupal and Ubercart. The old website had approximately 5000 products, with a data structure that was completely unlike the one used by Drupal to store data. We initially tried using the Drupal data loader module, but as other people have discovered, it isn’t necessarily a good fit for loading Ubercart product data, particularly when the products have images, or – and this is especially the case – custom data fields.

You can download a copy of our script here.

In the end, we put together a custom php script to pull data directly from one database to another. The script is fairly crude, but it may be useful to somebody trying to import data into Ubercart from another non-standard system.

As a result, I will link a copy of the script below. Please bear in mind that a) we accept no responsibility whatsoever for its use (i.e. back up your databases first!!!), and b) while we have documented our assumptions, this is a crude script that is specifically designed for our particular needs. Be that as it may, you may be able to find a use for this.

Additionally, it was a pain just getting a list of the Drupal and Ubertcart tables that needed to be looked at in order to do the data conversion. The list below may be useful to you as well.

How it works:

The old shopping cart had two relevant tables: a category listing (hierarchical), and a products table, which included some customer specific fields, as well as a single url to a product photo.

Drupal/Ubercart, on the other hand, uses a large number of tables to represent the same data. This is because products use the same node-based system as the rest of Drupal, in addition to a number of product specific tables.

In addition, product images are dealt with using Drupal’s file cacheing system, which is relatively complex in nature. All in all, our data goes from two tables to approximately nine (depending on your specific needs) in Drupal.

The script has some handling – very buggy still – in place for keeping track of the current position in the old database. This means that you can run the data conversion in small chunks, checking at each point to see how well it is doing. You can also set how many records to convert each time. In order for this to work, a very simple table to track the record pointer needs to be added into the old database.

We did not cover the conversion of product categories, since typically there are a much smaller number of categories than products, and in addition, the Drupal data loader does a reasonably good job of loading them.

List of tables involved:

• node – in Drupal, everything is a node, including products. Each new product record will need a corresponding node of the correct type.
• node_revisions – this table contains much of the actual textual data (i.e. product description text) involved in displaying the node.
• content_type_product – if you need to create custom fields for your Ubercart products, the data will go here. Our code in this section will probably not map directly to what you’re working on.
• uc_product – where the product records “live”. There will be one record here for each of the product nodes.
• uc_product_stock – contains stock-related data (i.e. how many of the product you have on hand etc) for products.
• files – each product image needs to have a record in this table, which stores the file names and locations – but does not map these images directly to the product records (you need another table for that!).
• content_field_image_cache – this is the mechanism that ties a product image to the underlying product. We didn’t really try to work with Drupal’s actual cache mechanism, so after you have loaded the products, you may want to clear the cache.
• term_data – this is where product category information resides, based on Drupal’s vocabulary / hierarchy system. We hacked the solution in a fairly inelegant way – by doing a category name lookup to retrieve the term id.
• term_node – a connection table between a term (i.e. a product category) and a node (in this case the products).

Base assumptions:

• We assumed that the old and new websites both have mysql databases.
• Both databases will probably have to be on the same server (or at least one of them needs to be externally accessible if that isn’t the case)
• The script should be uploaded and run from the new website’s location.
• We assumed that there is only one product image per product – although this would be fairly easy to modify.
• We manually added our categories to the new website
• We manually moved product images across – there are comments in the script where you could automate this though.
• Error checking is extremely rudimentary; if this scripts hits a problem it just stops.
• If you hit data conv snags, the fastest way to proceed is to restore your backup database, reset the pointer record, and start over.

City country example with ajax and php

"

Test Page

Country
Please select one country Ireland England
City
Please select one city

"

'.join('',$countries).'';
echo ''.join('',$countries).'';


?>

Test Page

Country
Please select one country Ireland England
City
Please select one city

$country = $_REQUEST['country'];

switch ($country)

{

case 'ie':

$countries = array('city1_ie','city2_ie');

break;

case 'en':

$countries = array('city1_en','city2_en');

break;

default:

$countries = false;

}

if(!$countries) echo "There is no city";

else

// echo ''.join('',$countries).'';

echo ''.join('',$countries).'';

?>