c4 Code - About Technologies

How can swap same feilds data using Mysql ? Table Name Color ID | Color -------------------- 1 Black 2 Whilte 3 Whilte 4 Black We can swap feilds data using following query. update `test` as i , test as c set i.color='black',c.color = 'white' where i.color='white' and c.color='black' What is MYSQL ? MySQL is an open source relational database management system (RDBMS) which uses Structured Query Language (SQL). MYSQL is the most popular language that is available for both Linux and Windows operating system.

How can swap same feilds data using Mysql ? Table Name Color ID | Color -------------------- 1 Black 2 Whilte 3 Whilte 4 Black We can swap feilds data using following query. update `test` as i , test as c set i.color='black',c.color = 'white' where i.color='white' and c.color='black' What is MYSQL ? MySQL is an open source relational database management system (RDBMS) which uses Structured Query Language (SQL). MYSQL is the most popular language that is available for both Linux and Windows operating system.

What are the difference between require_once and include, include_once? require_once(), include_once() both the functions include script once in file even it include many times using *_once function. require() and include() function provide facility to include file many times in script file. What is the difference between mysql_fetch_object & mysql_fetch_array? There is only difference between mysql_fetch_object() and mysql_fetch_array(). mysql_fetch_object() : it is return an object. mysql_fetch_array() : it is return an Array. In mysql_fetch_object() you can access the data by the field names whereas in mysql_fetch_array() you can access data by it's offsets. Who is the father of PHP ? Rasmus Lerdorf is know as a father of PHP. What is PHP ? PHP Hypertext Preprocessor is An open source server side scripting language/programming language used to create dynamic web pages that allows web developers to create dynamic pages that interacts with databases.

1) What is Flex? Flex is used to devleop Rich Internet Application (RIA) You can both desktop & web based applicaiton.It is markup language and object-oriented languages its many syntax match with flash action script. Flex Developers use typically five distinct phases to develoep Rich Internet Application. Design Configure Build Deploy Secure 2) How do i get Page URL and Query String ? We can use mx.core.Application.application.url (mx.core)package to work with current page URL. & query string. 3) Describe flex component file types ? There are following file types we can use in flex. extension .mxml - a component implemented as an MXML file. extension .as - a component implemented as an ActionScript class. extension .swc - a SWC file contains components in a packge. 4) Difference between target & currentTarget ? target : This property is set by the dispatchEvent() method. You cannot change this to a different object. currentTarget : This property is set by component instan

How to download Files From SharePoint Using php? This example is useful to download sharepoint data file using php. I have try to download sharepoint file using PHP CURL and i have done it so try it. <?php $sp_login_id = "test"; // sharepoint user id $sp_password = "********"; //sharepoint password $sp_data_file_url = "http://server/test.doc"; // data file url $ch = curl_init(); // initialize curl handle curl_setopt($ch, CURLOPT_URL,$sp_data_file_url); // set url to post to curl_setopt($ch, CURLOPT_USERPWD,"$sp_login_id:$sp_password"); curl_setopt($ch, CURLOPT_FAILONERROR, 1); // curl error curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);// allow redirects curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); // return into a variable curl_setopt($ch, CURLOPT_TIMEOUT, 5000); // times out after 5s curl_setopt($ch, CURLOPT_GET, 1); // set GET method $result = curl_exec($ch); // execute the whole process //curl errors $curl_info = curl_getinfo($ch); switch($cu

Java Script Cookies Set and Get functions There are four function which is useful to work with javascript cookies. there are no predefine function in javascript so that we can use these function to work with browser cookies. here is description of functions. 1) Javascript function set_cookie(name,value) :- This is a void function take two parametters name & value. name param is used for cookies name & value is used to set cookies value. 2) Javascript function get_cookie(name) :- This string function, which return value of that particualr cookie which you pass as param. 3) Javascript function is_cookie(name) :- This is boolean function, which return true or false for cookies existence. 4) javascript function delete_cookie(name) :- This is a void function which is used to delete cookies. name param takes name of cookies which you want to delete. <Script Language="javascript"> function set_cookie(name,value){ var name=name.toLowerCase(); document.cookie=name

We can create dynamic Array Collection in flex using following code. var ob:Object; var n:String = "Name"; var a:String = "Address"; var ar:ArrayCollection = ""; ob = new Object(); ob[n] = "Ar"; ob[a] = "xyz, UK"; ar = new ArrayCollection(); ar.addItem(ob); It binds data into array just like. arrayCollection = [{Name:'Ar',Address:'xyz, UK'}]; setPropertyIsEnumerable() is use to hide ArrayCollection item. which we can use like. ar.setPropertyIsEnumerable("Name",true); After using above method we can hide array collection item.

There is no function to trim string in javascript. We can use following user define function to trim string using javascript. Mainly we need three type of trim function which we use in program. Right Trim Javascript User Define function. function rightTrim(str) { return str.replace(/\str+$/,""); } Left Trim Javascript User Define function. function leftTrim(str) { return str.replace(/^\str+/,""); } Trim javascript function for both left and right side. function trim(str) { return str.replace(/^\str+|\str+$/g,""); }

There is very big problem in flex that's cache problem. When I was developing a Rich Internet application. I faced flex cache problem in Internet Explore & Firefox browser i was stuck badly. Then I wrote this code for avoiding flex cache problem & i think it works a bit. Well still working on it. I have added this code into index.template.html which is located into flex project html-template/index.template.html. <Script Language="javascript"> var url = location.href; var ots = parseInt(url.substring(url.indexOf("=")+1,url.length))+6000; var dt = new Date(); var n = dt.getTime(); if(url.indexOf("?timeStamp=")!=-1) { if(isNumber(ots) && ots!=""){ if(nts>ots){ location.href=url.substring(0,url.indexOf("?"))+"?timeStamp="+nts; } }else{ location.href=url.substring(0,url.indexOf("?"))+"?timeStamp="+newTimeStamp; } }else{ location.href=url.substring(0,url.indexOf("?")