Search In
Here is a simple program code to enter the form data to the database using php.
HTML Code:
<!DOCTYPE html>
<html>
<head>
<title>Form To Db</title>
<style type="text/css">
.container{width: 80%;text-align: le
Fetching a data in the form of table from the database can is explained here in this blog, User have to define a function in the controller with the same file name in which user are displaying table using HTML code, for example here it is 'fetch&
Most of time we need to insert multiple rows at a time into the database but some developer use multiple INSERT statements to insert multiple rows while it is a bad approach to solve this problem. Codeigniter provides a insert batch function.
Example
To rename a table in MySQL you need to execute the following command:
RENAME TABLE old_table_name TO new_table_name;
The old_table_name must exist n the database and the new_table_name must not. For example, we have a table name demo and we want t
Steps to create Ramdisk and take backup in oracle
Install SoftPerfect Ram disk software(eg installed location is C:\Program Files\SoftPerfect)
Create a .bat with following content and run it:
REM stop db
oradim -SHUTDOWN -SID DB_SID
REM create a ra
A simple command to export tables from Amazon RDS into a csv file
mysql -uroot -ptest123 --database=test -e "select concat(id,',',login) FROM users" > userdata.csv
This command will simply connect to mysql from terminal using root as username ,
Updation in CakePHP is basically based on knowing the primary key(Id) of the records one wants to change/edit.
You can update a field in CakePhp by two ways:-
a)By using saveField method
$this->ModelName->id=$id;
$this->ModelName->
Triggers are recorded in database as record IDs (together with the model name) and refer to the workflow instance waiting for those records. The transition definition provides a model name (attribute trigger_model) and a Python expression (attribute
We will understand the process of binding a list box to MySQL by an example. Suppose we have a database "test" having table ex1 which contains columns id,name. We need to bind the name field with the list box. For this we will use the following PHP s
In MySQL, SUM() function is used to return the total sum of a numeric column in a table.
SUM() Syntax
SELECT SUM(column_name) FROM table_name;
We have a table "employee" as below:
employee
id first_name last_name salary
