I was just trying to get this to work straight with php and mysql, at least
first off. I remember hearing others say the revmobile does not allow for
LiveCode 's mySQL commands to work from within a mobile app. I thought I had
heard, if you can just call "post" commands from within your revmobile app, you
could still access mysql from your revmobile app.
I keep trying to think of php and mysql commands the same way i think of
LiveCode. That's my problem :-)
The user log in I was referring to in the earlier post was just a mysql query
that compares what the user types in on the form for username and password. If
they match they move on, if they don't match, they get to try again. A username
and password match instigates a "session_start() and that code is placed at the
top of each html page. I think this was a pretty typically way to create a
basic form based login using php and mysql.
My attempt to query the student_user table for all students associated to that
teacher via an entry in the teacher_user table, the teacher's unique id, was
what i was after. It would be much easier to do this in a rev app. I could just
store all the teacher data from the table teacher_user, and pull it out when
querying tables other than teacher_user, such as the student_user table.
Thanks!
John Patten
SUSD
On Mar 16, 2011, at 4:36 PM, Bob Sneidar wrote:
> session_register is not a mySQL function, it is php. It is also deprecated,
> so it may or may not work depending on the version of php being used.
>
> I thought you were trying to get Livecode to tell you who the current logged
> in user was? current_user() or just user() works for me.
>
> Bob
>
> on mouseUp pMouseBtnNo
> put "select current_user()" into theSQL
> put dbconn_get("connection id", "priconn", "primary") into thePriID --
> sqlYoga function
>
> try
> put revDataFromQuery(comma, return, thePriID, theSQL) into theSQLData
> -- RevDB function
> catch theError
> answer theError
> exit to top
> end try
>
> put theSQLData
> end mouseUp
>
> This returns my on-rev user login@the ip I am connecting from as in
> mydatabase_mylogin@69.227.63.5 (I made that up). Wouldn't that do it for you?
> Or are you using some kind of internal authentication and you are trying to
> get what the user typed into a form?
>
>
> Bob
>
>
> On Mar 16, 2011, at 4:10 PM, John Patten wrote:
>
>> Hi Bob...
>>
>> session_user() appears to give me something other than the current logged in
>> user. It returns: myaccount_nameofdatabase
>>
>> This is what I did to test it out:
>>
>> $result = mysql_query( "SELECT session_user() FROM teacher_user" )
>> or die("SELECT Error: ".mysql_error());
>>
>> $num_rows = mysql_num_rows($result);
>>
>> print "There are $num_rows records.<P>";
>>
>> print "<table width=600 border=1>\n";
>> while ($get_info = mysql_fetch_row($result)){
>> print "<tr>\n";
>> foreach ($get_info as $field)
>> print "\t<td>$field</td>\n";
>> print "</tr>\n";
>> }
>> print "</table>\n";
>>
>>
>> I think even if I could return just the current user's profile (fields in
>> their record) using the session_register command in mySQL I'd be making
>> progress :-)
>>
>> Any other ideas?
>>
>> Thank you!
>>
>> John Patten
>> SUSD
>>
>> On Mar 16, 2011, at 1:24 PM, Bob Sneidar wrote:
>>
>>> You can use "SELECT session_user()" to get the currently logged in user.
>>> It's a synonym for "USER()". That help?
>>>
>>> Bob
>>>
>>>
>>> On Mar 16, 2011, at 12:15 PM, John Patten wrote:
>>>
>>>> Hi All...
>>>>
>>>> Thanks for the previous help on the on-rev php/mysql question. I have a
>>>> question about the mysql select command, session_register, and selecting
>>>> from two tables.
>>>>
>>>> I have one database with two tables. The tables are teacher_user and
>>>> student_user.
>>>>
>>>> Each table has a unique teacher-id stored in a fields. So students with
>>>> the teacher_id value of 0001 stored in their student_user record all
>>>> belong to the same teacher.
>>>>
>>>>
>>>> Teacher_table Student_table
>>>>
>>>> id - 0001 teacher_id = 0001
>>>> first first
>>>> last last
>>>> title grade
>>>>
>>>>
>>>> I also have the teacher login with their username and password comparing
>>>> what is stored in their db record for username and password. If they
>>>> match, then their username and password is then
>>>> session_register("username"); & session_register("password"); .
>>>>
>>>> What i would like to be able to do is query the database and return a list
>>>> of students to the individual teacher based on some unique information
>>>> about the teacher's record, say their username.
>>>>
>>>> is there some way I can get at the session_register("username") and use it
>>>> in my select query?
>>>>
>>>> Something like:
>>>>
>>>> select "username" from teacher_table and put "id" of table teacher_table
>>>> into tTeacher_id then
>>>> select tTeacher_id from student_table and loop through the student
>>>> printing each record
>>>>
>>>> I suppose if the teacher new their id value I could just have them type
>>>> that into a form and do a simple query the student_table and teacher_id
>>>> field by that id value. But I was trying to make it a little more
>>>> automatic and did not want teachers trying to guess other teachers' ids.
>>>>
>>>> Thanks in advance!
>>>>
>>>> John Patten
>>>> SUSD
>>>>
>>>> _______________________________________________
>>>> use-livecode mailing list
>>>> use-livecode@lists.runrev.com
>>>> Please visit this url to subscribe, unsubscribe and manage your
>>>> subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>
>>>
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>>
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
