Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

Search In

Insert Data into MySQL database from HTML SubForms

Hello EveryOne, I have 2 HTML Forms: 1. Register/Login 2. After User gets Login, He used to update details of him. I used MySql database in order to save Login details of User. And also i have another table for updating details of him after his log

How to export Schema without data in MySQL?

Sometimes we need to export Schema without data means table structure only. We can do this easily by providing "--no-data" option in mysqldump command. Command: mysqldump -u root -p --no-data database_name > database.sql Example: mysq

How to use "Where clause with multiple attributes" in ZEND Framework

Hello guys if you are looking to use where clause with multiple attribute in ZEND Framework. Please use the below code for the same:: $databaseObj = Zend_Db_Table::getDefaultAdapter(); $selectQuery = $this->select(); $selectQuery->from(array('

Use of AVG() Function in MySql

The MySql provides us with various for wide use for handling the database. The AVG() function is also one of the important function used in MySql. The AVG() is used to calculate the average value of the columns. Syntax: SELECT AVG(column-name) FR

How to access the database with SQL PLUS?

Hello all, I am unable to access my SQL database as I forgot the login details. I have tried with some but getting error "ORA -12560: TNS : protocol adapter error." Kindly suggest me the way to retrieve the details. Is there any command to

Working with Oracle in ADO.NET

While working with ADO.NET ActivexDataObject we use datasources for retrieving ,updating,inserting and deleting data.   Oracle is most used database in the modern industry. In Ado.net to make connection we can have multiple options. For this p

encode password before saving it to database

Hello Readers. Here is small code to encode password before it is saved into database. Add the following code in your Model file User.php App::uses('BlowfishPasswordHasher', 'Controller/Component/Auth'); class User extends AppModel { public

How to delete records in OpenERP/Odoo ?

Records can be deleted in bulk by providing their ids to unlink(). For example code like below. models.execute_kw(db, uid, password, 'res.partner', 'unlink', [[id]]) check if the deleted record is still in the database models.execute_kw(db, uid, pas

How to solve PostgresSQL Error connecting to the server:received invalid response to ssl negotition

Hi Friends, Please help me with the error ,when I am opening my database(pg-admin) in window server 2008 R2 It is giving me below mentioned error. Error connecting to the server:received invalid response to SSL Negotiation

How to install own cloud on Ubuntu 12.04

Pre requisites-->you need to have the lamp server running on your ubuntu. Downloading pakages sudo sh -c "echo 'deb http://download.opensuse.org/repositories/isv:/ownCloud:/community/xUbuntu_12.04/ /' >> /etc/apt/sources.list.d/ownclou

1 148 161
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: