Table Contents Archives - SEO, SEM, Web, ECommerce, IOS And Android | SEO, SEM, Web, eCommerce, iOS and Android

Archive for 'Table Contents'

Sencha Datastore connection to PHP

Tuesday, November 1st, 2011 at 8:46 am

Create a Table “Employee” with following fields in Mysql:

ID, FirstName, LastName, Salary

After that you need to create a php file “data-file.php” with script for listing table contents.

Then we need to create a Datastore to connect our php file data_file.php:

EmployeeDataStore = new Ext.data.Store({
id: 'EmployeeDataStore',
proxy: new Ext.data.HttpProxy({
url: 'data_file.php',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // PHP file to connect to database or an array with data
method: 'POST'
}),
baseParams:{task: "LIST-ALL"}, // this parameter asks for listing
reader: new Ext.data.JsonReader({
// we tell the datastore where to get his data from
root: 'results',
totalProperty: 'total',
id: 'id'
},[
{name: 'ID', type: 'int', mapping: 'ID'},
{name: 'FirstName', type: 'string', mapping: 'firstname'},
{name: 'LastName', type: 'string', mapping: 'lastname'},
{name: 'Salary', type: 'float', mapping: 'salary'}
]),
sortInfo:{field: 'ID', direction: "ASC"}
});

EmployeeDataStore = new Ext.data.Store({

id: 'EmployeeDataStore',

proxy: new Ext.data.HttpProxy({

url: 'data_file.php',      // PHP file to connect to database or an array with data

method: 'POST'

}),

baseParams:{task: "LIST-ALL"}, // this parameter asks for listing

reader: new Ext.data.JsonReader({

// we tell the datastore where to get his data from

root: 'results',

totalProperty: 'total',

id: 'id'

},[

{name: 'ID', type: 'int', mapping: 'ID'},

{name: 'FirstName', type: 'string', mapping: 'firstname'},

{name: 'LastName', type: 'string', mapping: 'lastname'},

{name: 'Salary', type: 'float', mapping: 'salary'}

]),

sortInfo:{field: 'ID', direction: "ASC"}

});

Incoming search terms:

sencha store php

Acessing SQLite Database in Corona

Monday, February 28th, 2011 at 11:10 am

Leave your comment

I’ll explain the basic steps to access SQLite database and loop through records in a table using Corona sdk.

Create sqlite database. (here I created country_capital.sqlite.)
Create table tbl_country_capital with the columns country and capital.

Copy the code below, paste it in main.lua file and execute it.. You’ll be able to see your table contents

-- inlcude sqlite db

require "sqlite3"


-- set the database path, here its the same folder where main.lua file resides.

local path = system.pathForFile("country_capital.sqlite", system.ResourceDirectory)

-- open db
db = sqlite3.open( path )
-- a variable to dynamically change the Y coordinate

local count = 1
-- sql query
local sql = "SELECT * FROM tbl_country_capital"
-- looping through result set and printing the output.

for row in db:nrows(sql) do

local text = row.country..", "..row.capital.." "
local t = display.newText(text, 50, 50 +(40 * count), native.systemFont, 30)
t:setTextColor(255,255,255)
count = count + 1
end

-- inlcude sqlite db

require "sqlite3"

-- set the database path, here its the same folder where main.lua file resides.

local path = system.pathForFile("country_capital.sqlite", system.ResourceDirectory)

-- open db

db = sqlite3.open( path )

-- a variable to dynamically change the Y coordinate

local count = 1

-- sql query

local sql = "SELECT * FROM tbl_country_capital"

-- looping through result set and printing the output.

for row in db:nrows(sql) do

local text = row.country..", "..row.capital.." "

local t = display.newText(text, 50, 50 +(40 * count), native.systemFont, 30)

t:setTextColor(255,255,255)

count = count + 1

end

Incoming search terms:

sqlite3 corona sdk
corona sdk database
corona sqlite select where
corona sqllite
select count corona

SEO, SEM, Web, eCommerce, iOS and Android

Categories

Archives

Archive for 'Table Contents'

Sencha Datastore connection to PHP

Incoming search terms:

Acessing SQLite Database in Corona

Incoming search terms:

Blogroll

Pages