SQL insert and select at once

Just got a good lesson from a friend i met in internet, its bout SQL, so this post is to remind me how to insert and select from sql data base in one query.

INSERT tableA(id,name,contents)
SELECT DISTINCT id, title, page_content FROM tableB
WHERE title= $strtomatch

Thank you my friend

Recursive function for php, mysql, suckerfish

This is code snippet for php recursive function that works with mysql and suckerfish, for instance if we have database with table named menu

=========================================
id | parent_id | name     | link
=========================================
1  | 0         | home     | index.php
2  | 0         | about us | about_us.php
3  | 2         | carreer  | career.php
4  | 2         | jobs     | jobs.php
==========================================

and we want to use jquery suckerfish menu to display it.

Continue reading “Recursive function for php, mysql, suckerfish”

Audio conferencing services

If a company must often coordinate with their clients or with their employees about important issues then they need a system of interactive telecommunication technologies which memungkinkankan two or more parties in different locations and they can interact with each other in real time via two-way delivery of audio or video this why audio conferencing service is a powerful and efficient alternative to the meeting.
Many companies that offer audio conferencing services, so if our company has not been able to make, or can afford to build one or install the conference program itself may be useful if we hire a this services from a telecommunication service providers.

engagement ring

The engagement is a sign that someone had tied her spouse and will soon be ready to lead to the wedding. Prior to the wedding, engagement rings are set and the the groom family come to know each other while deciding best date and all preparation of the wedding.
However, before holding the event have make decision of a model of your engagement ring or wedding ring? if you haven’t, you ought to know the latest model or trending ring of the year check out makemypromisering.com this website particularly set a handful of information about rings .

Codeigniter searches data

Been playing for awhile with codeigniter, i decided to convert some of my project website which was built on joomla to codeigniter, while it is challenging i found some difficulties in porting the site. One of the problem is when is use active record function like(), it seem this function is only working if you query a word only.
For example if you search “bali” on sentence “bali update” it will return true but when i search “bali update” it return false.

The work around is to use php function rawurldecode

$search = rawurldecode( $this->input->post('search') );
$this->db->like('search', $search);
$rows = $this->db->get('category')->result_array(); 

information technology jobs

Based on my observations and experience, here are some types of information technology jobs which can be selected. hopefully it is useful for those who wish to pursue a career in the future or for those whose still off one’s trolley to decide what types of education they should take.

1.Computer Technician
2.Programmer
3.System analyst
4.Researcher or lecturer
5.Admin ( database administrator, network administrator and application administrator (like ERP) )
6.Security administrator
7.IT consultant / compliance
8. Art/design (web designer, 3d designer)
9.Data analyst

And the orifice of it will be ‘which job pay the most’ , well its all back to the companies that hire us, such as it is uncertain that a programmer salary’s is less than an analyst for instance, because there are some companies pay more fro a programmer than analyst.

Digitalizing data

Converting and saving your data/documents in digital format, you do not have to worry anymore regarding your important data, whether personal data, business data of your company.
Your data document can be easily managed, easy to find with certain keywords, it only takes a small room for storage, it can be printed again and many more benefits which you can earn by doing digitizing your documents using rightdocument management system ,digitalizing your data can be a very effective and cost efficient.

kvm switch

Few years ago i worked at a travel agent company, i was in charged of maintaining their local server and website. The company uses two servers, one handling all emails , users, fax server and the other one is for database and locahost (intranet site). when i got there in the server room was full with keyboards, mouses, and monitors that is sure of taking whole space on the server room. fortunately there is a handy tool called KVM switch.
KVM switch is a device to control a lot of CPU, using only 1 set of keyboard, mouse and monitor. Very useful for servers, or your computer technicians, so i made a proposal to purchase the tool.
Now server room is neat and tidy!