World: r4wp
[Databases] group to discuss various database issues and drivers
| older newer | first last |
| afsanehsamim 9-Nov-2012 [234x5] | in rebol interpreter only created table |
i mean when i run data.r it creats table | |
i do not know how should i mix cgi file with database file | |
the results is like this: | |
do %data.r
Script: "Untitled" (none)
Script: "MySQL Protocol" (12-Jul-2008)
MySQL protocol loaded
connecting to: localhost
[
["raj" "pune"]
["ekta" "delhi"]
["ankur" "mumbai"]
]
| |
| Arnold 9-Nov-2012 [239] | you have to mix them something like
#! "C:/wamp/bin/apache/Apache2.2.11/cgi-bin/rebol-core-278-3-1.exe"
-cs
REBOL [Title: "Table"]
do %mysql-protocol.r
db: open mysql://[root-:-localhost]/test
insert db {create table data (
name varchar(100),
address text
)}
insert db {INSERT into data VALUES
('raj', 'pune'),
('ekta', 'delhi'),
('ankur', 'mumbai')
}
insert db "SELECT * from data"
results: copy db
print "content-type: text/html^/"
print [<HTML><BODY><TABLE bgcolor="black" border="1">
{
<tr bgcolor="white">
<td style="width:30px; height:30px;"><input name="one-one" type="text"
size="1">}
print results/name
print {</td>}
etc
|
| afsanehsamim 9-Nov-2012 [240] | and what extension should i use ? .r ???/ |
| Arnold 9-Nov-2012 [241] | learning comes with a lot of try and err even for a 'simple' language as REBOL Probably yes and have your apache server set up right for .r files |
| afsanehsamim 9-Nov-2012 [242] | you're right,i configured my apache server for cgi ... i think i should configure again |
| TomBon 9-Nov-2012 [243] | just rename it to .cgi you have the correct shebang at the top. apache should recognize it automatically. don't forget to chmod your cgi to grant execution permission. |
| afsanehsamim 9-Nov-2012 [244x2] | but my OS is windows 7 |
i am not using linux | |
| BrianH 9-Nov-2012 [246] | Then you don't have to chmod, you just have to put it in the right directory. |
| TomBon 9-Nov-2012 [247] | correct |
| afsanehsamim 10-Nov-2012 [248x4] | thank you Arnold.... i van fetch data from database :) ...i am working on compare two values (value that is entered by user and value that is correct )... |
do you know for comparing which aommand should i use? | |
command for comparing values in mysql database ???? | |
hey guys... do you know how we can check values of two tables in mysql?????!!!! | |
| Arnold 10-Nov-2012 [252] | select * from table where answer = useranswer select * form table1, table2 where table1.field = table2.field Do you have google? Any MySQL tutorial out there holds the answer to your question. Or want to compare from wihin your REBOL script? It is either [ left = right][do-something][do-else-thing]. |
| afsanehsamim 10-Nov-2012 [253] | i exactly meant that how we can use Mysql queries(checking two values in two different table) in Rebol script !!!!! |
| Arnold 10-Nov-2012 [254] | so you have put the users answer also in a mySQL table? read both tablerows from the tables into different variables and compare the subfields of the returned rows result1/fielda result2/fielda |
| afsanehsamim 11-Nov-2012 [255x5] | if user wants insert values to table and it should save in database ,what is the command for that ??? |
this command is correct ??? : insert db ["insert into data1 values (?)" myfields name] | |
guys ,i want insert data into database ,i wrote the following codes but no value save !!... :( | |
#! "C:/wamp/bin/apache/Apache2.2.11/cgi-bin/rebol-core-278-3-1.exe"
-cs
REBOL [Title: "Table"]
do %mysql-protocol.r
db: open mysql://[root-:-localhost]/test
insert db { DROP TABLE IF EXISTS data1;
create table data1 (
oneone varchar(1),
onetwo varchar(1),
onethree varchar(1),
twoone varchar(1),
twothree varchar(1),
threeone varchar(1),
threetwo varchar(1),
threethree varchar(1)
)}
print "content-type: text/html^/"
print [<HTML><BODY>]
print [<form><input type="submit" value=" submit !" />]
print [<TABLE bgcolor="black" border="1">]
print {<tr bgcolor="white">
<td style="width:30px; height:30px;"><input name="oneone" type="text"
size="1">}
insert db ["insert into data1 (oneone) values (?)" ]
results: copy db
print {</td>}
| |
i do not know what i should write for values(?)... plz help | |
| Pekr 11-Nov-2012 [260] | http://www.rebol.com/docs/database.html#section-18 |
| afsanehsamim 11-Nov-2012 [261x3] | i tried that link but no value save in database ... :( |
my form should get value from <input name="oneone" type="text">.... | |
in values(?) i should put what???? as i said it should get value from <input ...> !!!!!! | |
| Pekr 11-Nov-2012 [264x4] | nothing |
insert db ["insert into data1 values(?)" value-here] | |
insert db-port [{
INSERT INTO table1 (First, LastName, Title, Phone)
values (?, ?, ?, ?)
} fname lname title phone
]
| |
you see? The use four ? ? ? ?, and after the string { }, there are
four values fname lname title phone
| |
| afsanehsamim 11-Nov-2012 [268x3] | i completely underestand !!!! but fname,lname,title,phone are string and before query ,they are defiend as : fname: "Johnny" lname: "Johnson" title: "President" phone: "(707) 555-1212" |
i have <input ....>,how should i define it as string???? | |
i should write like fname:<input name="oneone" type="text" size="1">???? | |
| Pekr 11-Nov-2012 [271] | what do you want exactly to be put into the database field? |
| afsanehsamim 11-Nov-2012 [272x4] | character |
when i write like this :print [<form><input type="submit" value="
submit !" />]
print [<TABLE bgcolor="black" border="1">]
print {<tr bgcolor="white">
<td style="width:30px; height:30px;"><input name="oneone" type="text"
size="1">}
insert db ["insert into data1(oneone) values(c)"]
results: copy db
print {</td>}
| |
it saves c to database | |
but it will not save user input | |
| Pekr 11-Nov-2012 [276x3] | yes, you have basically two options:
1) work with string - insert db {insert into data1 ....} - you simply
construct the DB string directly
2) work with block - insert db ["initial string here, contatining
values(?)" value] - which allows to work with rebol blocks and evaluate
some things ...
|
so in your case it should be: insert db ["insert into data1(oneone) values(?)" "c"] | |
or something like: value: "c" insert db ["insert into data1(oneone) values(c)" value] | |
| afsanehsamim 11-Nov-2012 [279x3] | but value should not be as constant ! when user put character it should save in values ,now plz tell me how should i write ? i should write like : value:"c" |
ishould write like : value :<input ...> ? | |
@Peker : i am using option one ,but i does not save any value ... | |
| Pekr 11-Nov-2012 [282] | you want to save value from the form into the db? |
| afsanehsamim 11-Nov-2012 [283] | yes |
| older newer | first last |