<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3268" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2>Hi all,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2>Just found an old xerte RLO i made to allow students to
vote for their favourite slide formatting.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2><A
href="http://www.nottingham.ac.uk/~cczpl/php.rlo">http://www.nottingham.ac.uk/~cczpl/php.rlo</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2>Have a look at ResultPage - then the untitled script
at the top, and then the slideload interaction at the bottom. I've had
to change the url in this RLO so as to make sure the
proper page won't get damaged.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2>The php is effectively as such (it doesn't use mysql -
stores the values in files, but as Paul said, let the php do the work for you on
that part.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT size=1>
<P><FONT face=Verdana size=4>$string = $_GET['votes'];</FONT></P>
<P><FONT face=Verdana size=4>$array = explode(",",$string);</FONT></P>
<P><FONT face=Verdana size=4>echo "<scores>";</FONT></P>
<P><FONT face=Verdana size=4>for($i=0;$i<=count($array)-1;$i++){</FONT></P>
<P><FONT face=Verdana size=4>$filehandle = fopen($i+1,'r+');</FONT></P>
<P><FONT face=Verdana size=4>$string = fread($filehandle,8000);</FONT></P>
<P><FONT face=Verdana size=4>if($array[$i]==1){</FONT></P>
<P><FONT face=Verdana size=4></FONT></P>
<P><FONT face=Verdana size=4>$string+=1;</FONT></P>
<P><FONT face=Verdana size=4>fseek($filehandle, 0);</FONT></P>
<P><FONT face=Verdana size=4>fwrite($filehandle,$string);</FONT></P>
<P><FONT face=Verdana size=4>}</FONT></P>
<P><FONT face=Verdana size=4></FONT></P>
<P><FONT face=Verdana size=4>echo "<vote>" . $string .
"</vote>";</FONT></P>
<P><FONT face=Verdana size=4>fclose($filehandle);</FONT></P>
<P><FONT face=Verdana size=4></FONT></P>
<P><FONT face=Verdana size=4>}</FONT></P>
<P><FONT face=Verdana size=4>echo
"</scores>";</FONT></P></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2>It may be all academic now though!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2>Hope this helps</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=668440717-10042008><FONT face=Verdana
color=#0000ff size=2>Pat</FONT></SPAN></DIV><FONT face=Verdana color=#0000ff
size=2></FONT><FONT size=1></FONT><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> xerte-bounces@lists.nottingham.ac.uk
[mailto:xerte-bounces@lists.nottingham.ac.uk] <B>On Behalf Of </B>Paul
Swanson<BR><B>Sent:</B> 10 April 2008 17:59<BR><B>To:</B> Xerte discussion
list<BR><B>Subject:</B> RE: [Xerte] Xerte and Php &
MySQl<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=587475216-10042008><FONT face=Verdana
color=#0000ff size=2>I have used it with PHP. I detailed my steps in this
thread: <A
href="http://lists.nottingham.ac.uk/pipermail/xerte/2007-August/000039.html">http://lists.nottingham.ac.uk/pipermail/xerte/2007-August/000039.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=587475216-10042008><FONT face=Verdana
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=587475216-10042008><FONT face=Verdana
color=#0000ff size=2>It was just a test, but once I knew how to communicate
with PHP, I figure that's all I need from Xerte. I'll use PHP to do all the
MySQL stuff.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=587475216-10042008><FONT face=Verdana
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=587475216-10042008><FONT face=Verdana
color=#0000ff size=2>Paul</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> xerte-bounces@lists.nottingham.ac.uk
[mailto:xerte-bounces@lists.nottingham.ac.uk] <B>On Behalf Of </B>Scott
Elliott<BR><B>Sent:</B> Thursday, April 10, 2008 9:47 AM<BR><B>To:</B>
xerte@lists.nottingham.ac.uk<BR><B>Subject:</B> [Xerte] Xerte and Php &
MySQl<BR></FONT><BR></DIV>
<DIV></DIV>I'm new to the list so not familiar with the recent
posts.<BR><BR>Has anyone successfully used Xerte with Php and MySQL? I
want to be able to store data that trainees type in a text entry
frame. I also want to read data from MySQL. <BR><BR>I'm a former
Authorware user trying to find a suitable program to fill the void. I
was able to use Authorware with php and MySql. <BR><BR>Thanks in advance<BR
clear=all><BR>-- <BR>Scott Elliott<BR>Instructional Developer<BR>Abbott
Diagnostics Division<BR>Abbott Laboratories<BR>200 Abbott Park Rd.<BR>Abbott
Park, IL 60064<BR>847-937-3928 (office)<BR>630-363-6771
(Cell)<BR><BR><BR><BR><BR><BR><BR>DISCLAIMER: This email and any files
transmitted with it may be privileged, confidential, is legally protected.
This information is intended only for the use of the individual or entity
named above. The authorized recipient of this information is prohibited from
disclosing this information to any other party unless permitted to do so by
law or regulation. If you are not the intended recipient, you are hereby
notified that any use, disclosure, copying, or distribution, is strictly
prohibited. If you have received this information in error, please notify
the sender immediately and arrange for the return or destruction of these
documents. </BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>