-
Posts
501 -
Joined
-
Last visited
Content Type
Forums
News
20th
EduGeek EDIT Conference
Blogs
Everything posted by Cools
-
take the mortgage out with the people you with now.. it should be easyer then take a new one some where else..
-
my old account manager now works for PROMO IT.. i always ask if he's been fired.. yet.. 5 days a go i got a "Errr.. yes.." 28th last moth they went under.. he said. and most of them work for PROMO IT now..
-
[PHP] Grab name from mysql and but display in date order with next and prev
Cools replied to Cools's topic in Web Development
i know what you mean.. lol.. -
Can I look at your Moodle......please?
Cools replied to s1mon321's topic in Virtual Learning Platforms
Can I look at your Moodle......please? Dirty boy.. -
[PHP] Grab name from mysql and but display in date order with next and prev
Cools replied to Cools's topic in Web Development
Well i re-did the page.. found some code.. so not all my work. from :: How to use PHP & MySQL Search Rows Data and Paging/Pagination | ShotDev.Com so here it is of any one needs it if you need the autocomplete.js msg me.. or see zip above. session_start(); ob_start(); require_once "conf.inc.php"; ?> <br /> .tableth {<br /> font-family: Tahoma, Geneva, sans-serif;<br /> }<br /> </pre><form name="frmSearch" method="get" action="<?=%24_SERVER%5B'SCRIPT_NAME'%5D;?>"> Students Name "> </form><br><br>if($_GET["txtKeyword"] != "")<br>{<br>$objConnect = mysql_connect("localhost","root","C0nfus3d!") or die(mysql_error());<br>$objDB = mysql_select_db("sen");<br>// Search By Name or Email<br>$strSQL = "SELECT * FROM comments WHERE (users_name LIKE '%".$_GET["txtKeyword"]."%')";<br>$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");<br>$Num_Rows = mysql_num_rows($objQuery);<br><br><br>$Per_Page = 5; // Per Page<br><br>$Page = $_GET["Page"];<br>if(!$_GET["Page"])<br>{<br> $Page=1;<br>}<br><br>$Prev_Page = $Page-1;<br>$Next_Page = $Page+1;<br><br>$Page_Start = (($Per_Page*$Page)-$Per_Page);<br>if($Num_Rows<=$Per_Page)<br>{<br> $Num_Pages =1;<br>}<br>else if(($Num_Rows % $Per_Page)==0)<br>{<br> $Num_Pages =($Num_Rows/$Per_Page) ;<br>}<br>else<br>{<br> $Num_Pages =($Num_Rows/$Per_Page)+1;<br> $Num_Pages = (int)$Num_Pages;<br>}<br><br><br>$strSQL .=" order by date DESC LIMIT $Page_Start , $Per_Page";<br>$objQuery = mysql_query($strSQL);<br><br>?><br><table bgcolor="#0080FF" cellpadding="0" cellspacing="1" width="80%" border="0" align="center"> Student Name Date Comments Lesson Staff Memeber while($objResult = mysql_fetch_array($objQuery)) { ?> =$objResult["users_name"][/url]?> =$objResult["date"][/url]?> =$objResult["lesson"][/url]?> =$objResult["stuser"][/url]?> } ?> </table><br><br><br><br> <p align="center">Total = $Num_Rows;?> Record : =$Num_Pages;?> Page : if($Prev_Page) { echo " << Back "; } for($i=1; $i<=$Num_Pages; $i++){ if($i != $Page) { echo "[ $i ]"; } else { echo " $i "; } } if($Page!=$Num_Pages) { echo " Next>> "; } mysql_close($objConnect); } ?> </p><br><script type="text/javascript"><br /> // <![CDATA[<br /> $(document).ready(function(){ <br /> $("#txtKeyword").autocomplete("ac/get_list.php", {<br /> width: 260,<br /> matchContains: true,<br /> //mustMatch: true,<br /> //minChars: 0,<br /> //multiple: true,<br /> //highlight: false,<br /> //multipleSeparator: ",",<br /> selectFirst: false<br /> });<br /> }); <br /> // ]]><br /> </script><br><br><br><b -
[PHP] Grab name from mysql and but display in date order with next and prev
Cools replied to Cools's topic in Web Development
Dont worry i spoke to soon.. lol now i have added more test students. it's still not working right.. lol.. but at least next/prev page is working if you want to have a look.. goto http://server.ilimits.co.uk/epms/sen i have zip code to have a look at. http://server.ilimits.co.uk/epms/sen/sen.zip PS. i working from tget2.php to get in fro from DB... -
[PHP] Grab name from mysql and but display in date order with next and prev
Cools replied to Cools's topic in Web Development
I love you Bud... lol Got it working... i did not need... $totalusers = mysql_num_rows(mysql_query("SELECT id FROM $tablen"));[php] but i need... [php]$totalrows = mysql_num_rows(mysql_query("SELECT id FROM $tablen"));// Counts the total rows [php] but changed to.... [php]$totalrows = mysql_num_rows(mysql_query("SELECT users_name FROM $tablen"));// Counts the total rows [php] and now it works... new code.. [php] include("conf.inc.php"); // Includes the db and form info. $tablen = $con;//Sets the table name $users_name=$_POST['users_name']; //Pagination $limit = 10;// Set the limit of results per page $page = $_GET['page'];// Sets the page, the default is ?page= $totalrows = mysql_num_rows(mysql_query("SELECT users_name FROM $tablen"));// Counts the total rows if(empty($page))// If the page is empty { $page = '1';// Page is 1 }; $start = ($page-1)*$limit; $start = round($start,0);// Sets the start $result = mysql_query("SELECT * FROM $tablen ORDER BY date DESC LIMIT $start, $limit");// Normal query while ($r = mysql_fetch_array($result)) { echo nl2br(" </pre><table align='\"center\"' width='\"80%\"' bgcolor='\"#d8EEF4\"' border='\"0\"' cellpadding='\"1\"' cellspacing='\"0\"'> ".$r["users_name"]." - ".$r["lesson"]." ".$r["comment"]." ".$r["date"]." By ".$r["stuser"]." "); echo (" Delete | Edit "); echo " </table><br>";// Echoes the content<br>};<br>//$totalusers = mysql_num_rows(mysql_query("SELECT id FROM $tablen"));<br>// echo "<br>Total posts: $totalusers<br>";// Echoes the total users<br>$totalpages = $totalrows / $limit;// Get the total pages<br>$totalpages = ceil($totalpages);// Rounds the total pages to the highest possible numer<br>if($page == 1)// If the page is 1<br>{<br>$actualpage = '1';// Sets the actual page<br>}<br>else// Else<br>{<br>$actualpage = "$page";// The page is the one it's specified in ?page=<br>}<br>if($page < $totalpages)// If the actual page is smaller than the totalpages<br>{<br>$nv = $page+1;// Sets the next variable<br>$pv = $page-1;// Sets the preview variable<br>$nextpage = "<a href="?page=%24nv" rel="">></a>";// Sets the next page<br>$prevpage = "<a href="?page=%24pv" rel=""><</a>";// Sets the prev page<br>$firstpage = "<a href="%5C%22?page=1%5C%22" rel="">«</a>";// Sets the first page<br>$finalpage = "<a href="%5C%22?page=%24totalpages%5C%22" rel="">»</a>";// Sets the final page<br>}<br>if($page == '1')<br>{<br>$nv = $page+1;<br>$nextpage = "<a href="?page=%24nv" rel="">></a>";<br>$prevpage = "<";<br>$firstpage = "«";<br>$finalpage = "<a href="%5C%22?page=%24totalpages%5C%22" rel="">»</a>";<br>}elseif($page == $totalpages){<br>$pv = $page-1;<br>$nextpage = ">";<br>$prevpage = "<a href="?page=%24pv" rel=""><</a>";<br>$firstpage = "<a href="%5C%22?page=1%5C%22" rel="">«</a>";<br>$finalpage = "»";<br>}<br>if($totalpages == '1' || $totalpages == '0'){<br> $nextpage = ">";<br> $prevpage = "<";<br> $firstpage = "«";<br> $finalpage = "»";<br>}<br>echo "<p align='\"center\"' class='\"post-footer' align-center> $firstpage $prevpage Actual Page: $actualpage $nextpage $finalpage Pages: $totalpages </p> ";<br><br>?><b -
[PHP] Grab name from mysql and but display in date order with next and prev
Cools replied to Cools's topic in Web Development
i dont get it.. does this part of the code not do that $result = mysql_query("SELECT * FROM $tablen ORDER BY date DESC LIMIT $start, $limit");// Normal query while ($r = mysql_fetch_array($result)) { echo nl2br(" </pre><table align='\"center\"' width='\"50%\"' border='\"1\"' cellpadding='\"1\"' cellspacing='\"0\"'> ".$r["users_name"]." - ".$r["lesson"]." ".$r["comment"]." ".$r["date"]." By ".$r["stuser"]." "); echo (" Delete | Edit "); echo " </table><br><br>";// Echoes the content <br>} -
[PHP] Grab name from mysql and but display in date order with next and prev
Cools replied to Cools's topic in Web Development
it's for SEN.. A comment is post in to the MySQL db with Values of : ID, Student_name , Staff_name, Date, Lesson and Comment. so I want to get the same back out but in date order when I search for a student. Other staff members need see the comments as there are added.. at the other end of the school saving on paper work.... -
wondering if any one could help.. wondering of the any's...... i want to pull a student info from mysql DB, searching for Studen by name but output ordered by date. The code is below... if there's a simple way of doing it.. im all up for it.. it's a OLD bit of code i found and it works so im happy.. it's not for public use, just for in house for staff. ------- this line $result = mysql_query("SELECT * FROM $tablen ORDER BY date DESC LIMIT $start, $limit");// Normal query if i add WHERE users_name='$users_name' $result = mysql_query("SELECT * FROM $tablen WHERE users_name='$users_name' ORDER BY date DESC LIMIT $start, $limit");// Normal query i can search for name and it displays in date order for the next and prev does not work. Thanks. Add a commnet. include("conf.inc.php"); // Includes the db and form info. $tablen = $con;//Sets the table name $users_name=$_POST['users_name']; //Pagination $limit = 10;// Set the limit of results per page $page = $_GET['page'];// Sets the page, the default is ?page= $totalrows = mysql_num_rows(mysql_query("SELECT id FROM $tablen"));// Counts the total rows if(empty($page))// If the page is empty { $page = '1';// Page is 1 }; $start = ($page-1)*$limit; $start = round($start,0);// Sets the start $result = mysql_query("SELECT * FROM $tablen ORDER BY date DESC LIMIT $start, $limit");// Normal query while ($r = mysql_fetch_array($result)) { echo nl2br(" </pre><table align='\"center\"' width='\"50%\"' border='\"1\"' cellpadding='\"1\"' cellspacing='\"0\"'> ".$r["users_name"]." - ".$r["lesson"]." ".$r["comment"]." ".$r["date"]." By ".$r["stuser"]." "); echo (" Delete | Edit "); echo " </table><br><br>";// Echoes the content<br>};<br>$totalusers = mysql_num_rows(mysql_query("SELECT id FROM $tablen"));<br>// echo "<br>Total posts: $totalusers<br>";// Echoes the total users<br>$totalpages = $totalrows / $limit;// Get the total pages<br>$totalpages = ceil($totalpages);// Rounds the total pages to the highest possible numer<br>if($page == 1)// If the page is 1<br>{<br>$actualpage = '1';// Sets the actual page<br>}<br>else// Else<br>{<br>$actualpage = "$page";// The page is the one it's specified in ?page=<br>}<br>if($page < $totalpages)// If the actual page is smaller than the totalpages<br>{<br>$nv = $page+1;// Sets the next variable<br>$pv = $page-1;// Sets the preview variable<br>$nextpage = "<a href="?page=%24nv" rel="">></a>";// Sets the next page<br>$prevpage = "<a href="?page=%24pv" rel=""><</a>";// Sets the prev page<br>$firstpage = "<a href="%5C%22?page=1%5C%22" rel="">«</a>";// Sets the first page<br>$finalpage = "<a href="%5C%22?page=%24totalpages%5C%22" rel="">»</a>";// Sets the final page<br>}<br>if($page == '1')<br>{<br>$nv = $page+1;<br>$nextpage = "<a href="?page=%24nv" rel="">></a>";<br>$prevpage = "<";<br>$firstpage = "«";<br>$finalpage = "<a href="%5C%22?page=%24totalpages%5C%22" rel="">»</a>";<br>}elseif($page == $totalpages){<br>$pv = $page-1;<br>$nextpage = ">";<br>$prevpage = "<a href="?page=%24pv" rel=""><</a>";<br>$firstpage = "<a href="%5C%22?page=1%5C%22" rel="">«</a>";<br>$finalpage = "»";<br>}<br>if($totalpages == '1' || $totalpages == '0'){<br> $nextpage = ">";<br> $prevpage = "<";<br> $firstpage = "«";<br> $finalpage = "»";<br>}<br>echo "<p align='\"center\"' class='\"post-footer' align-center> $firstpage $prevpage Actual Page: $actualpage $nextpage $finalpage Pages: $totalpages </p> ";<br><br>?><br><br><br><br><b
-
Pc or MAC ffmpeg look up BinKit-v2.0 in google. theres a mac ver and PC and Nix. it has scripts built in for 240p-360p-480p-720p-iphone outputs to flv but i use it for staff using flip cams that make mod files.to convert them to wmv just need to mod script to it outputs to mp4.
-
try this i use it all the time.. Install XP from USB - reboot.pro ----USB_MultiBoot.cmd - Install XP from USB-----
-
Here’s how the changes will work: ■New Spotify users will be able to enjoy our unrivalled free service as it is today for the first 6 months. ■As of May 1st, any user who signed up to the free service on or before November 1st 2010 will be able to play each track for free up to a total of 5 times. Users who signed up after the beginning of November will see these changes applied 6 months after the time they set up their Spotify account. ■Additionally, total listening time for free users will be limited to 10 hours per month after the first 6 months. That’s equivalent to around 200 tracks or 20 albums. https://www.spotify.com/se/blog/archives/2011/04/14/upcoming-changes-to-spotify-free-open/
-
Moodle SSO - tearing my hair out!
Cools replied to jgcracknell's topic in Virtual Learning Platforms
only ever got sso to work with IE.. and that was with IIS and on Nix .. -
Re-using old PCs as thin clients for VMWare View
Cools replied to DLW13's topic in Thin Client and Virtual Machines
the "Windows Thin PC by Microsoft | Windows Enterprise " looks good get windows 7 on a pc and it only takes up 270 mb ram.. and i have 4gb to play with.. of it does not have all the nice gui but who needs it.. and it runs fast and loads fast.. might have to start installing some software on it.. theres nothing thinclient about it.. just windows 7 thined down to XP speeds and ram.. install is still big.. might be good to keep the life of the PC's going for a extra yr and gives you the space to move to windows 7 on some of the older pcs..... need to test on my very old end PC's now.... -
Re-using old PCs as thin clients for VMWare View
Cools replied to DLW13's topic in Thin Client and Virtual Machines
it's very simple.. have a look at for things you my ask.. http://www.edugeek.net/forums/thin-client-virtual-machines/2038-thinstation.html -
for a sans i would go for Dell Equallogic you can have half ssd and half sas the SSD will give you the boot speed for the RD's in the morn... and SAS for storage.. the more its used the better it learns to place that start up profiles, so you get max speed from it at client boot up.. smart bit of kit..
-
Re-using old PCs as thin clients for VMWare View
Cools replied to DLW13's topic in Thin Client and Virtual Machines
PXE Boot thinstation... Job Done.. :: Thinstation - a light, full-featured Linux thin client OS :: -
Try this line... robocopy.exe "d:\From" "X:\To" *.* /S /COPY:DATSO /MOVE /ZB /NP /XA:RHS /XF *.ini *.ico /MINLAD:20080901 /R:2 /W:10 i had the same problem i had to change /COPYATSO /MOVE to /COPY:DATSO /MOVE after i added /MINLAD:20080901
-
lol.. what ever next..
-
change the /MINLAD:730 you the date format YYYYMMDD 20090901 the 730 is days ..
-
Any one know much about wan optimization...?? looking to improve BB Speed.. I have look at Traffic Squeezer - Open Source WAN Optimization
-
sorry i did not mean /MINAGE:... what i meant was /MINLAD: as Plexer corrected me on.. we have to look at 2 things: 1. Space wasted from files never accessed for more then 2 years and the cost of space on SAS. (and also WAV files and WMV to MPEG that can be compressed) 2. We are only archiving not deleting as you may have to keep the data for a number of years. I see it better to archive files not access more then 2years "from there last access date" and hard backup to a data storage device usb/nas/Whatever for fast access if you need to.
-
Well My "staffarea" with set to 730 days moved over 51GB of old files. Still got staff personal folders to do.. lol.. might user last access time for that...
