Table creation/Postal addresses: Difference between revisions

Content added Content deleted
m (→‎{{header|Phix}}: syntax coloured, marked p2js incompatible)
Line 794: Line 794:
=={{header|Phix}}==
=={{header|Phix}}==
{{libheader|SQLite}}
{{libheader|SQLite}}
<lang Phix>include pSQLite.e
<!--<lang Phix>(notonline)-->
<span style="color: #008080;">without</span> <span style="color: #008080;">js</span> <span style="color: #000080;font-style:italic;">-- (file i/o)</span>
constant sqlcode = """
<span style="color: #008080;">include</span> <span style="color: #000000;">pSQLite</span><span style="color: #0000FF;">.</span><span style="color: #000000;">e</span>
⚫
CREATE TABLE address (
<span style="color: #008080;">constant</span> <span style="color: #000000;">sqlcode</span> <span style="color: #0000FF;">=</span> <span style="color: #008000;">"""
⚫
addrID INTEGER PRIMARY KEY AUTOINCREMENT,
⚫
CREATE TABLE address (
⚫
addrStreet TEXT NOT NULL,
⚫
addrID INTEGER PRIMARY KEY AUTOINCREMENT,
⚫
addrCity TEXT NOT NULL,
addrState TEXT NOT NULL,
addrStreet TEXT NOT NULL,
addrZIP TEXT NOT NULL)"""
addrCity TEXT NOT NULL,
⚫
addrState TEXT NOT NULL,
⚫
addrZIP TEXT NOT NULL)"""</span>
sqlite3 db = sqlite3_open("address.sqlite")
integer res = sqlite3_exec(db,sqlcode)
<span style="color: #000000;">sqlite3</span> <span style="color: #000000;">db</span> <span style="color: #0000FF;">=</span> <span style="color: #000000;">sqlite3_open</span><span style="color: #0000FF;">(</span><span style="color: #008000;">"address.sqlite"</span><span style="color: #0000FF;">)</span>
if res=SQLITE_OK then
<span style="color: #004080;">integer</span> <span style="color: #000000;">res</span> <span style="color: #0000FF;">=</span> <span style="color: #000000;">sqlite3_exec</span><span style="color: #0000FF;">(</span><span style="color: #000000;">db</span><span style="color: #0000FF;">,</span><span style="color: #000000;">sqlcode</span><span style="color: #0000FF;">)</span>
sqlite3_close(db)
<span style="color: #008080;">if</span> <span style="color: #000000;">res</span><span style="color: #0000FF;">=</span><span style="color: #000000;">SQLITE_OK</span> <span style="color: #008080;">then</span>
else
<span style="color: #000000;">sqlite3_close</span><span style="color: #0000FF;">(</span><span style="color: #000000;">db</span><span style="color: #0000FF;">)</span>
⚫
-- can show eg "sqlite3_exec error: 1 [table address already exists]"
<span style="color: #008080;">else</span>
printf(1,"sqlite3_exec error: %d [%s]\n",{res,sqlite_last_exec_err})
⚫
<span style="color: #000080;font-style:italic;">-- can show eg "sqlite3_exec error: 1 [table address already exists]"</span>
⚫
end if</lang>
<span style="color: #7060A8;">printf</span><span style="color: #0000FF;">(</span><span style="color: #000000;">1</span><span style="color: #0000FF;">,</span><span style="color: #008000;">"sqlite3_exec error: %d [%s]\n"</span><span style="color: #0000FF;">,{</span><span style="color: #000000;">res</span><span style="color: #0000FF;">,</span><span style="color: #000000;">sqlite_last_exec_err</span><span style="color: #0000FF;">})</span>
<span style="color: #008080;">end</span> <span style="color: #008080;">if</span>
⚫
<!--</lang>-->


=={{header|PHP}}+SQLite==
=={{header|PHP}}+SQLite==
Retrieved from "https://rosettacode.org/wiki/Table_creation/Postal_addresses"