World: r4wp
[Databases] group to discuss various database issues and drivers
| older newer | first last |
| afsanehsamim 10-Nov-2012 [250x2] | 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 [283x3] | yes |
i want to save value from the form into the database! | |
any solution? | |
| Pekr 11-Nov-2012 [286x3] | I think, that your script is wrongly constructed! What you seem to do is to just print a form, which then gets delivered to user's browser screen. But at that time, there is no value yet. You should study, how to do CGI in REBOL. You need a separate html form, then you need to read CGI values and store them in a DB ... |
plese study following link - on the right side, there is a link, of how to process forms using REBOL: http://www.rebol.com/docs/cgi1.html | |
this is how you should do it - http://www.rebol.com/docs/cgi2.html | |
| afsanehsamim 11-Nov-2012 [289] | but in those links ,i can not find database example! i read that link before ,i created html form and cgi as well, it is working properly ... the point is when user enter input and click submit it goes to cgi page. i need save that input in database ...plz guid me or show me one example how can i save value from the form into db? |
| Pekr 11-Nov-2012 [290x4] | please use: values: decode-cgi read-cgi then you will get block of values IIRC |
then you pick a value and save it ... | |
>> blk: decode-cgi "var1=Petr" == [var1: "Petr"] >> type? blk == block! >> object: construct blk >> object >> object/var1 == "Petr" | |
so use: values: decode-cgi read-cgi result: construct values insert db ["insert into data1(oneone) values(?)" result/oneone] | |
| afsanehsamim 11-Nov-2012 [294] | how can i write <input ...> in block? |
| Pekr 11-Nov-2012 [295x4] | uh, my question is, if you ever worked with CGI? |
examples on the above page are pretty straightforward? | |
there are two things - 1) you have to write a form, basically a html file, with fields, etc., and submit button, linking it to your cgi script 2) you have to write a CGI script, being able to read submitted values ... | |
I might dig-up some simple example later ... | |
| afsanehsamim 11-Nov-2012 [299] | i am using the first one ... can i use codes which you mensioned in above ? values: decode-cgi read-cgi result: construct values insert db ["insert into data1(oneone) values(?)" result/oneone] |
| older newer | first last |