|
PHP - Php Script For Jeditable
Hi everyone, first time here!
I am trying to use Jeditable. Not sure if anyone knows about it. http://www.appelsiini.net/projects/jeditable Basically its a Edit-in-place plugin for JQuery. However it requires a PHP script and Im pretty sure a mySQL db to work properly. I believe the PHP does something along the lines of taking the new inputted data, sending it to a db then echoing it back to where ever it came from, I think it achieves this using the $_POST function. This is exactly what I want! However this is the first time I have dealt with PHP. Im not too bad at Javascript but PHP is new to me. I have googled my brains out looking for an example php file for this but they don't seem to be around. I understand it cant just be written for me because it would be a different script for every one, and that's not what i want either. But some examples would be great ! The javascript i have so far is Code: [Select] <html> <head> <style type="text/css"> a.test { font-weight: bold; } </style> <script type="text/javascript" src="jquery-1.4.3.min.js"></script> <script src="jquery.jeditable.js" type="text/javascript"></script> <script type="text/javascript"> $(document).ready(function() { $('.edit').editable('http://Example.com/save.php', { indicator : 'Saving...', tooltip : 'Click to edit...' }); $('.edit_area').editable('http://Example.com/save.php', { type : 'textarea', cancel : 'Cancel', submit : 'OK', indicator : '<img src="img/indicator.gif">', tooltip : 'Click to edit...' }); }); </script> </head> <body> <div class="edit" id="div_1">Dolor</div> <div class="edit_area" id="div_2">Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</div> <a href="http://jquery.com/">jQuery</a> </body> </html> Any help would be great! I think its at least mostly right so far but perhaps I'm missing something important which is why I cant get it all to come together. Similar TutorialsHi All, I have a table (with an ID of example) that can be seen he http://tinyurl.com/cfla7wp The following script calls jeditable.js and makes the Telephone & Mobile columns editable. Once edited, the table shows the new value plus a * symbol. Code: [Select] <script type="text/javascript"> $(document).ready(function() { /* Init DataTables */ var oTable = $('#example').dataTable(); /* Apply the jEditable handlers to the table */ $('td:eq(4), td:eq(5)', oTable.fnGetNodes()).editable( 'update_table_tenants.php', { "callback": function( sValue, y ) { var aPos = oTable.fnGetPosition( this ); oTable.fnUpdate( sValue, aPos[0], aPos[1] ); }, "submitdata": function ( value, settings ) { return { "row_id": this.parentNode.getAttribute("1"), "column": oTable.fnGetPosition( this )[2] }; }, "height": "14px" } ); } ); </script> What I need to do however is add the value entered into my database, but I do not know how to do this. I believe I need to do something like: UPDATE my_table VALUE whatever column has been edited in the table WHERE tenID is the same as the row selected in the table i.e. if I update the MOBILE NUMBER of the person called BILL GATES it would find his tenID, update numMobile in the table called my_table All help appreciated Dave Hi everyone! I've been working on a php script to replace links that contain a query with direct links to the files they would redirect to. I'm having trouble echoing $year in my script. Listed below is the script, just below ,$result = mysql_query("SELECT * FROM $dbname WHERE class LIKE '%$search%'") or die(mysql_error());, in the script I try to echo $year. It doesn't show up in the table on the webpage. Everything else works fine. Any help wold be appreciated greatly. Thanks in advance. <?php include 'config2.php'; $search=$_GET["search"]; // Connect to server and select database. mysql_connect($dbhost, $dbuser, $dbpass)or die("cannot connect"); mysql_select_db("vetman")or die("cannot select DB"); $result = mysql_query("SELECT * FROM $dbname WHERE class LIKE '%$search%'") or die(mysql_error()); // store the record of the "" table into $row //$current = ''; echo "<table align=center border=1>"; echo "<br>"; echo "<tr>"; echo "<td align=center>"; ?> <div style="float: center;"><a><h1><?php echo $year; ?></h1></a></div> <?php echo "</td>"; echo "</tr>"; echo "</table>"; // keeps getting the next row until there are no more to get if($result && mysql_num_rows($result) > 0) { $i = 0; $max_columns = 2; echo "<table align=center>"; echo "<br>"; while($row = mysql_fetch_array($result)) { // make the variables easy to deal with extract($row); // open row if counter is zero if($i == 0) echo "<tr>"; echo "<td align=center>"; ?> <div style="float: left;"> <div><img src="<?php echo $image1; ?>"></div> </div> <?php echo "</td>"; // increment counter - if counter = max columns, reset counter and close row if(++$i == $max_columns) { echo "</tr>"; $i=0; } // end if } // end while } // end if results // clean up table - makes your code valid! if($i > 0) { for($j=$i; $j<$max_columns;$j++) echo "<td> </td>"; echo '</tr>'; } mysql_close(); ?> </table> Hi i have this upload script which works fine it uploads image to a specified folder and sends the the details to the database. but now i am trying to instead make a modify script which is Update set so i tried to change insert to update but didnt work can someone help me out please this my insert image script which works fine but want to change to modify instead Code: [Select] <?php mysql_connect("localhost", "root", "") or die(mysql_error()) ; mysql_select_db("upload") or die(mysql_error()) ; // my file the name of the input area on the form type is the extension of the file //echo $_FILES["myfile"]["type"]; //myfile is the name of the input area on the form $name = $_FILES["image"] ["name"]; // name of the file $type = $_FILES["image"]["type"]; //type of the file $size = $_FILES["image"]["size"]; //the size of the file $temp = $_FILES["image"]["tmp_name"];//temporary file location when click upload it temporary stores on the computer and gives it a temporary name $error =array(); // this an empty array where you can then call on all of the error messages $allowed_exts = array('jpg', 'jpeg', 'png', 'gif'); // array with the following extension name values $image_type = array('image/jpg', 'image/jpeg', 'image/png', 'image/gif'); // array with the following image type values $location = 'images/'; //location of the file or directory where the file will be stored $appendic_name = "news".$name;//this append the word [news] before the name so the image would be news[nameofimage].gif // substr counts the number of carachters and then you the specify how how many you letters you want to cut off from the beginning of the word example drivers.jpg it would cut off dri, and would display vers.jpg //echo $extension = substr($name, 3); //using both substr and strpos, strpos it will delete anything before the dot in this case it finds the dot on the $name file deletes and + 1 says read after the last letter you delete because you want to display the letters after the dot. if remove the +1 it will display .gif which what we want is just gif $extension = strtolower(substr($name, strpos ($name, '.') +1));//strlower turn the extension non capital in case extension is capital example JPG will strtolower will make jpg // another way of doing is with explode // $image_ext strtolower(end(explode('.',$name))); will explode from where you want in this case from the dot adn end will display from the end after the explode $myfile = $_POST["myfile"]; if (isset($image)) // if you choose a file name do the if bellow { // if extension is not equal to any of the variables in the array $allowed_exts error appears if(in_array($extension, $allowed_exts) === false ) { $error[] = 'Extension not allowed! gif, jpg, jpeg, png only<br />'; // if no errror read next if line } // if file type is not equal to any of the variables in array $image_type error appears if(in_array($type, $image_type) === false) { $error[] = 'Type of file not allowed! only images allowed<br />'; } // if file bigger than the number bellow error message if($size > 2097152) { $error[] = 'File size must be under 2MB!'; } // check if folder exist in the server if(!file_exists ($location)) { $error[] = 'No directory ' . $location. ' on the server Please create a folder ' .$location; } } // if no error found do the move upload function if (empty($error)){ if (move_uploaded_file($temp, $location .$appendic_name)) { // insert data into database first are the field name teh values are the variables you want to insert into those fields appendic is the new name of the image mysql_query("INSERT INTO image (myfile ,image) VALUES ('$myfile', '$appendic_name')") ; exit(); } } else { foreach ($error as $error) { echo $error; } } //echo $type; ?> I'm trying to use this script known as SimpleImage.php that can be found here <a href="http://www.white-hat-web-design.co.uk/articles/php-image-resizing.php">link</a> I'm trying to include what is on the bottom of the page to my existing script can anyone help me I've tried several ways but its not working. Code: [Select] <?php session_start(); error_reporting(E_ALL); ini_set('display_errors','On'); //error_reporting(E_ALL); // image upload folder $image_folder = 'images/classified/'; // fieldnames in form $all_file_fields = array('image1', 'image2' ,'image3', 'image4'); // allowed filetypes $file_types = array('jpg','gif','png'); // max filesize 5mb $max_size = 5000000; //echo'<pre>';print_r($_FILES);exit; $time = time(); $count = 1; foreach($all_file_fields as $fieldname){ if($_FILES[$fieldname]['name'] != ''){ $type = substr($_FILES[$fieldname]['name'], -3, 3); // check filetype if(in_array(strtolower($type), $file_types)){ //check filesize if($_FILES[$fieldname]['size']>$max_size){ $error = "File too big. Max filesize is ".$max_size." MB"; }else{ // new filename $filename = str_replace(' ','',$myusername).'_'.$time.'_'.$count.'.'.$type; // move/upload file $target_path = $image_folder.basename($filename); move_uploaded_file($_FILES[$fieldname]['tmp_name'], $target_path); //save array with filenames $images[$count] = $image_folder.$filename; $count = $count+1; }//end if }else{ $error = "Please use jpg, gif, png files"; }//end if }//end if }//end foreach if($error != ''){ echo $error; }else{ /* -------------------------------------------------------------------------------------------------- SAVE TO DATABASE ------------------------------------------------------------------------------------ -------------------------------------------------------------------------------------------------- */ ?> hey guys im really just after a bit of help/information on 2 things (hope its in the right forum).
1. basically I'm wanting to make payments from one account to another online...like paypal does...im wondering what I would need to do to be able to do this if anyone can shine some light please?
2.as seen on google you type in a query in the search bar and it generates sentences/keywords from a database
example:
so if product "chair" was in the database
whilst typing "ch" it would show "chair" for a possible match
I know it would in tale sql & json but im after a good tutorial/script of some sort.
if anyone can help with some information/sites it would be much appreciated.
Thank you
Hello, I stored a fsockopen function in a separate "called.php" file, in order to run it as another thread when it needs. The called script should return results to the "master.php" script. I'm able to run the script to get the socket working, and I'm able to get results from the called script. I tried for hours but I can't do the twice both My master.php script (with socket working): Code: [Select] <?php $command = "(/mnt/opt/www/called.php $_SERVER[REMOTE_ADDR] &) > /dev/null"; $result = exec($command); echo ("result = $result\r\n"); ?> and my called.php script Code: [Select] #!/mnt/opt/usr/bin/php-cli -q <?php $device = $_SERVER['argv'][1]; $port = "8080"; $fp = fsockopen($device, $port, $errno, $errstr, 5); fwrite($fp, "test"); fclose($fp); echo ("normal end of the called.php script"); ?> In the master script, if I use Code: [Select] $command = "(/mnt/opt/www/called.php $_SERVER[REMOTE_ADDR] &) > /dev/null"; the socket works, but I have nothing in $result (note also that I don't anderstand why the ( ... &) are needed!?) and if I use Code: [Select] $command = "/mnt/opt/www/called.php $_SERVER[REMOTE_ADDR]"; I have the correct text "normal end of the called.php script" in $result but the socket connection is not performed (no errors in php logs) Could you help me to find a way to let's work the two features correctly together? Thank you. Well the subject line is pretty explicit. I found this script that uploads a picture onto a folder on the server called images, then inserts the the path of the image on the images folder onto a VACHAR field in a database table. Code: [Select] <?php //This file inserts the main image into the images table. //address error handling ini_set ('display_errors', 1); error_reporting (E_ALL & ~E_NOTICE); //authenticate user //Start session session_start(); //Connect to database require ('config.php'); //Check whether the session variable id is present or not. If not, deny access. if(!isset($_SESSION['id']) || (trim($_SESSION['id']) == '')) { header("location: access_denied.php"); exit(); } else{ // Check to see if the type of file uploaded is a valid image type function is_valid_type($file) { // This is an array that holds all the valid image MIME types $valid_types = array("image/jpg", "image/jpeg", "image/bmp", "image/gif"); if (in_array($file['type'], $valid_types)) return 1; return 0; } // Just a short function that prints out the contents of an array in a manner that's easy to read // I used this function during debugging but it serves no purpose at run time for this example function showContents($array) { echo "<pre>"; print_r($array); echo "</pre>"; } // Set some constants // This variable is the path to the image folder where all the images are going to be stored // Note that there is a trailing forward slash $TARGET_PATH = "images/"; // Get our POSTed variable $image = $_FILES['image']; // Sanitize our input $image['name'] = mysql_real_escape_string($image['name']); // Build our target path full string. This is where the file will be moved to // i.e. images/picture.jpg $TARGET_PATH .= $image['name']; // Make sure all the fields from the form have inputs if ( $image['name'] == "" ) { $_SESSION['error'] = "All fields are required"; header("Location: member.php"); exit; } // Check to make sure that our file is actually an image // You check the file type instead of the extension because the extension can easily be faked if (!is_valid_type($image)) { $_SESSION['error'] = "You must upload a jpeg, gif, or bmp"; header("Location: member.php"); exit; } // Here we check to see if a file with that name already exists // You could get past filename problems by appending a timestamp to the filename and then continuing if (file_exists($TARGET_PATH)) { $_SESSION['error'] = "A file with that name already exists"; header("Location: member.php"); exit; } // Lets attempt to move the file from its temporary directory to its new home if (move_uploaded_file($image['tmp_name'], $TARGET_PATH)) { // NOTE: This is where a lot of people make mistakes. // We are *not* putting the image into the database; we are putting a reference to the file's location on the server $sql = "insert into images (member_id, image_cartegory, image_date, image) values ('{$_SESSION['id']}', 'main', NOW(), '" . $image['name'] . "')"; $result = mysql_query($sql) or die ("Could not insert data into DB: " . mysql_error()); header("Location: images.php"); echo "File uploaded"; exit; } else { // A common cause of file moving failures is because of bad permissions on the directory attempting to be written to // Make sure you chmod the directory to be writeable $_SESSION['error'] = "Could not upload file. Check read/write persmissions on the directory"; header("Location: member.php"); exit; } } //End of if session variable id is not present. ?> The script seems to work fine because I managed to upload a picture which was successfully inserted into my images folder and into the database. Now the problem is, I can't figure out exactly how to write the script that displays the image on an html page. I used the following script which didn't work. Code: [Select] //authenticate user //Start session session_start(); //Connect to database require ('config.php'); $sql = mysql_query("SELECT* FROM images WHERE member_id = '".$_SESSION['id']."' AND image_cartegory = 'main' "); $row = mysql_fetch_assoc($sql); $imagebytes = $row['image']; header("Content-type: image/jpeg"); print $imagebytes; Seems to me like I need to alter some variables to match the variables used in the insert script, just can't figure out which. Can anyone help?? Hi, I am trying to run two scripts on one page. When I use just one script on the page they work however when I place both scripts on the same page one of them disrupts the other script. This script prevents the other following script from working: Code: [Select] ini_set('display_errors', 1); error_reporting(-1); { $query = "SELECT * FROM answers ORDER BY `aid` DESC LIMIT 0, 11"; } $result = mysql_query($query); while($row = mysql_fetch_assoc($result)) { $answer = $row['answer']; $aid = $row['aid']; echo " <div class='questionboxquestion'> <a href= 'http://www.domain.co.uk/test/easy/answer.php?aid=$aid' class='questionlink'>$answer</a> </div> <div class='questionboxnotes'> </br> </div> <div class='questionboxlinks'> <div class='questionboxcategory'> <div class='questionboxcategorytitle'> Category: </div> <a href= 'http://www.domain.co.uk/test/easy/furniture-category.php' class='questionanswerlink'></a> </div> <div class='questionboxanswerlink'> <a href= 'http://www.domain.co.uk/test/oeasy/index.php' class='questionanswerlink'>Answer</a> </div> </div> "; } Code: [Select] <?php if($error) echo "<span style=\"color:#ff0000;\">".$error."</span><br /><br />"; ?> <label for="username">Username: </label> <input type="text" name="username" value="<?php if($_POST['username']) echo $_POST['username']; ?>" /><br /> <label for="password">Password: </label> <input type="password" name="password" value="<?php if($_POST['password']) echo $_POST['password']; ?>" /><br /> <label for="password2">Retype Password: </label> <input type="password" name="password2" value="<?php if($_POST['password2']) echo $_POST['password2']; ?>" /><br /> <label for="email">Email: </label> <input type="text" name="email" value="<?php if($_POST['email']) echo $_POST['email']; ?>" /><br /><br /> <input type="submit" name="submit" value="Register" /> I have an application which runs on more than one server and need to launch one PHP script from another PHP script. Since this is different than a function call I'm not sure how it's done. I plan to include parameters in the URL I send and use GETs to pick up parameters in the "called" PHP script. Thanks for sugestions How would I go about making it to where,, I can tell the script to use a certain extension of php in the script like curl.. ? Thanks i have the following code... it works well in it's current position... $profile_sql="SELECT * FROM $tbl_12"; $profile_query = mysql_query($profile_sql); while($rs_profile = mysql_fetch_array($profile_query)){ $profile_ph = $rs_profile["ph"]; $profile_pm = $rs_profile["pm"]; } but if i put it in a function it gives me an error... like this... function get_profile() { $profile_sql="SELECT * FROM $tbl_12"; $profile_query = mysql_query($profile_sql); while($rs_profile = mysql_fetch_array($profile_query)){ $profile_ph = $rs_profile["ph"]; $profile_pm = $rs_profile["pm"]; echo $profile_pm; } } Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in... hey everyone, I have a script that allows a user to view content after 5 other people clicked their referral link which is different for everyone based off of their IP address. I have a button that i want it to open the content . i made it work in the sense that it does open the content when clicked, HOWEVER, it ignores the "you need 5 referrals to access this", however, it also shows the user they dont have enough clicks at the top of the page. this is my code for the button: <input name="req" type="submit" id="req" style="background: url(images/index_17.gif); width:141px; height:27px;border:0;" onClick="javascript:window.open('picture.php')" value=" "> the part of the site where it shows the user they dont have enough referrals after the button is clicked: <form name="form1" method="post" action=""> <p><? echo"$message"; ?></p> and the javascript that calls the form i think: <script type="text/javascript"> function clsv(sObj) { if(sObj.value=='Email'){ sObj.value=''; } } </script> There is also this code at the very top: <? include "inc/functions.php"; $r=$_GET['r']; $p=$_GET['p']; $querys2=mysql_query("SELECT * FROM prizes LIMIT 1"); $p2 = mysql_fetch_object($querys2); if (empty($p['p'])){ $p=$p2->id; } $sql_p_checkp = mysql_query("SELECT id FROM prizes WHERE id='$p'"); $ip_checkp = mysql_num_rows($sql_p_checkp); if($ip_checkp > 0){ }else{ $p=$p2->id; } $querys=mysql_query("SELECT * FROM prizes WHERE id='$p' LIMIT 1"); $p = mysql_fetch_object($querys); $sql_ip_check2 = mysql_query("SELECT ip FROM user WHERE ip='$ip'"); $ip_check2 = mysql_num_rows($sql_ip_check2); if($ip_check2 > 0){ }else{ mysql_query("UPDATE user SET hits =hits+1 WHERE id='$r'"); } $sql_ip_check = mysql_query("SELECT ip FROM user WHERE ip='$ip'"); $ip_check = mysql_num_rows($sql_ip_check); if($ip_check > 0){ $message=""; }else{ mysql_query("INSERT INTO user (`id` , `ip` , `hits`) VALUES ('', '$ip', '0')") or die (mysql_error()); echo"<META HTTP-EQUIV=\"REFRESH\" CONTENT=\"0\">"; } $page=$p->id-1; $page2=$p->id+1; if (($_POST['reqp'])){ $email=mysql_real_escape_string(strip_tags($_POST['email'])); mysql_query("INSERT INTO requests (`id` , `ip` , `desc`, `email`) VALUES ('', '$ip', '$p->desc', '$email')") or die (mysql_error()); mysql_query("UPDATE user SET hits =hits-$p->points WHERE ip='$ip'"); $message="Your prize has been requested and will be sent soon!"; } if (($_POST['req'])){ $amm="$p->points"; if ($amm> $u->hits){ $message= "You don't have referral hits!"; }elseif ($amm <= $u->hits){ $message="<input id=\"email\" name=\"email\" value=\"Email\" onClick=\"clsv(this);\" type=\"text\"/> <input type=\"submit\" name=\"reqp\" id=\"reqp\" value=\"Request Prize\"> $s->cpa "; }} ?> Basically all I want is for picture.php to open when request is clicked, ONLY if the user has had 5 other people click/go to their referral link I am not familiar with PHP, i bought this script, maker has not been too helpful, so any help is appreciated please Hi guys, I have an issue. First see the code. 1) index.php <html> <?php include 'header.php';?> <div class = "nav"> <ul> <li> Menu 1 </li> <li> Menu 2 </li> <li> Menu 3 </li> <li> Menu 4 </li> </ul> </div> <div id = "left-panel"> <ul class = "left-menu"> <li>Sub Menu 1 </li> <li>Sub Menu 2 </li> <li>Sub Menu 3 </li> <li>Sub Menu 4 </li> </ul> </div> <div class = "content"> <?php loadContent($config); ?> </div> <?php include 'footer.php' ?> </html> My Function is: function loadContent($config) { if(empty($_GET['action'])) { $_GET['action'] = "start"; } $root = "include/".$_GET['action'].".php"; if(file_exists($root)) { include($root); } } No if I press the Menu 1 in the nav class I will redirect to index.php?action=category&item=Menu1 My question is can I detect the $_GET['item']; in the index page and print it. If so how can I ? I want like : if (empty($_GET['item'])){ echo "No menu item selected"; }else{ $cat = $_GET['item']; echo $cat; } at the top of the page I need PHP script for create a program i have 1 header.html (which is my header file) 2 menu.html(which contain menu on right of the page) 3 footer.html(which is my footer) 4 content.html(which is my content area of the page) 5 multiple around 10 .php form pages now i want to use them into single page which have header,menu,footer as same & my php forms call on content area. so please help me out Hi all, i'm working on a script which will allow staff members or "admins" to move users on a html table. Basically a user clicks on a cell within a table and there username is stored in a mysql database and there username also appears in that cell and its reserved for them and other users cant take there slot. I use this for a seating plan for events. I have made an identical table which pulls the same data from the database but is only availible to staff members but i want it so when a staff member clicks on a cell or "seat" it will ask them if they want to move themselves there or another user. Here is my code i have so far: Code: [Select] <?php require ("./auth.php");?> <?php require ("../secure/connect.php");?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>SouthWest LAN's</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link rel="stylesheet" type="text/css" href="../css/styles.css" /> </head> <body> <!-- Begin Wrapper --> <div id="wrapper"> <!-- Begin Header --> <div id="header"><h1><br />SouthWest LAN's</h1></div> <!-- End Header --> <!-- Begin Navigation --> <div id="navigation"><ul> <li style="margin-right:15px; display:inline;"><a href="../index.php">Home</a></li> <li style="margin-right:15px; display:inline;"><a href="../gallery/">Photo Gallery</a></li> <li style="margin-right:15px; display:inline;"><a href="../events.php">Events</a></li> <li style="margin-right:15px; display:inline;"><a href="../account.php">My Account</a></li> <li style="margin-right:15px; display:inline;"><a href="../forum.php">Forums</a></li> <li style="margin-right:15px; display:inline;"><a href="../faq.php">FAQ</a></li> </ul></div> <!-- End Navigation --> <!-- Begin Content Column --> <div id="content"> <h1>Staff Seating</h1><br /> <p>Below shows where users are currently seated and you can edit where users are sitting and place users that havent yet choosen a seat.</p><br /> <p>Click a seat for options:</p><br /> <?php session_start(); $user_id = array(); $query = "SELECT * from seats_table"; $result = mysql_query($query); while($row = mysql_fetch_array($result)){ $seat_status[] = $row['taken']; } $query5 = "SELECT * from seats_table"; $result5 = mysql_query($query5); while($row5 = mysql_fetch_array($result5)){ $user_id[] = $row5['user_id']; } $get2 = mysql_query("SELECT * FROM users WHERE username='".$_SESSION['username']."'")or die(mysql_error()); ?> <fieldset> <br /> <table width="100%" border="0" align="center"> <tr> <td><b>Seat 01</b></td> <td><b>Seat 02</b></td> <td><b>Seat 03</b></td> <td><b>Seat 04</b></td> <td><b>Seat 05</b></td> <td><b>Seat 06</b></td> <td><b>Seat 07</b></td> <td><b>Seat 08</b></td> <td><b>Seat 09</b></td> <td><b>Seat 10</b></td> <td><b>Seat 11</b></td> <td><b>Seat 12</b></td> </tr> <tr> <td>Servers</td> <td>Servers</td> <td><?php if($seat_status[2]) { echo '<font color="red"><a href="admin_seat.php?seat=3">'.$user_id[2];} else { ?> <a href="admin_seat.php?seat=3"><font color="green">Availible</a></font><?php } ?></td> <td><?php if($seat_status[3]) { echo '<font color="red"><a href="admin_seat.php?seat=4">'.$user_id[3];} else { ?> <a href="admin_seat.php?seat=4"><font color="green">Availible</a></font><?php } ?></td> <td><?php if($seat_status[4]) { echo '<font color="red"><a href="admin_seat.php?seat=5">'.$user_id[4];} else { ?> <a href="admin_seat.php?seat=5"><font color="green">Availible</a></font><?php } ?></td> <td><?php if($seat_status[5]) { echo '<font color="red"><a href="admin_seat.php?seat=6">'.$user_id[5];} else { ?> <a href="admin_seat.php?seat=6"><font color="green">Availible</a></font><?php } ?></td> <td><?php if($seat_status[6]) { echo '<font color="red"><a href="admin_seat.php?seat=7">'.$user_id[6];} else { ?> <a href="admin_seat.php?seat=7"><font color="green">Availible</a></font><?php } ?></td> <td><?php if($seat_status[7]) { echo '<font color="red"><a href="admin_seat.php?seat=8">'.$user_id[7];} else { ?> <a href="admin_seat.php?seat=8"><font color="green">Availible</a></font><?php } ?></td> <td><?php if($seat_status[8]) { echo '<font color="red"><a href="admin_seat.php?seat=9">'.$user_id[8];} else { ?> <a href="admin_seat.php?seat=9"><font color="green">Availible</a></font><?php } ?></td> <td><?php if($seat_status[9]) { echo '<font color="red"><a href="admin_seat.php?seat=10">'.$user_id[9];} else { ?> <a href="admin_seat.php?seat=10"><font color="green">Availible</a></font><?php } ?></td> <td><?php if($seat_status[10]) { echo '<font color="red"><a href="admin_seat.php?seat=11">'.$user_id[10];} else { ?> <a href="admin_seat.php?seat=11"><font color="green">Availible</a></font><?php } ?></td> <td><?php if($seat_status[11]) { echo '<font color="red"><a href="admin_seat.php?seat=12">'.$user_id[11];} else { ?> <a href="admin_seat.php?seat=12"><font color="green">Availible</a></font><?php } ?></td> </tr> </table> <br /> </fieldset> <br /> <SCRIPT LANGUAGE="JavaScript"> if (window.print) { document.write('<form><input type=button name=print value="Print this page" onClick="window.print()"></form>'); } </script> <br /> <hr /><br /> Above has been edited down to just show the first 12 seats. And heres my admin_seat.php so far: Code: [Select] <?php session_start(); /* connect to data base */ require ('../secure/connect.php'); /* get the seat number */ $seat_id = mysql_real_escape_string(trim($_GET['seat'])); ?> I want this script so that when i click on a seat it will ask me if i want to seat myself there, in which case it will place my username into that "seat" and remove anyone currently in that seat and reset them. If i dont want to seat myself there i want the script to give me the option to place a user there, so i would need to list all of my registered users, ideally in a dropdown box (i will only have around 80 users tops) and then submit that and it will move that user to that seat and wipe there current seat if applicable. something like this: Code: [Select] $query = "UPDATE seats_table set taken = FALSE, user_id = '0' WHERE user_id = '$user_id'"; $result = mysql_query($query) or die (mysql_error()); $query = "UPDATE seats_table set taken = TRUE, user_id = '$user_id' WHERE id = '$seat_id'"; $result = mysql_query($query) or die (mysql_error()); the top line resets the seat back to default and availible for a user. the third line is when a user selects a seat, it sets that seats "taken" to equal true stores there user ID and the seat ID. any help with this would be great and also im not sure if its possible to list all of my registered users inside a dropdown box. Lee Hey guys, so I was wanting to sell some source code on my website, but how would I do that. Is there some way to use paypal, when users pay X price they can download the zipped folder, and make sure there is some security to it so somebody just cant share the download link and let people that did not purchase it download it.
This code works:
How can I execute this in one script tag?
<script>
var urlParams;
(window.onpopstate = function () {
var match,
pl = /\+/g, // Regex for replacing addition symbol with a space
search = /([^&=]+)=?([^&]*)/g,
decode = function (s) { return decodeURIComponent(s.replace(pl, " ")); },
query = window.location.search.substring(1);
urlParams = {};
while (match = search.exec(query))
urlParams[decode(match[1])] = decode(match[2]);
})();
var a = urlParams["a"];
var b = urlParams["b"];
// var url = "http://example.com/tracker/"+ a +'/' + b;
var iDiv = document.createElement('img');
iDiv.id = '5050';
iDiv.src = +url;
iDiv.width = '14';
iDiv.height = '14';
document.getElementsByTagName('body')[0].appendChild(iDiv);
iDiv.appendChild(innerDiv);
</script>
<script>
document.getElementById("5050").src ="http://example.com/tracker/"+ a +'/' + b;
</script>
Helo, I need help with mine script. It downloads xml from distant server and all works ok but i need help to change something on that downloaded xml. It contains element (column) that has products names and its called "products". in there i have products code names and i have specific situation where i get products codes in form like this "AA123BB#CCC". I need to somehow strip or delete or atleest ignore in further querry symbol "#" and everything after it. In this case i need to remove "#CCC" so that my column has only first part of data "AA123BB". Help needed!!! Thanx! Hi Guys, I am new to this forum and I need your help. I need a PHP script to post reports, agendas and meeting minutes and when email will be send to all the people who are listed on website. Please can anyone let know about such script.. Thanks & regards, Sunny |
|||||||