39,402 Topics
 | |
| | I have a list of customers on a waiting list for services to be rendered today. I want to calculate on average how long it takes from the time the customer was queued to the time that customer record was updated. I'm not really sure of the correct table structure … |
| | i have a link on zoom.php here i have a link where iam send image_id <a href=\"editimage.php?img=$image_id\">Edit</a> now i have a editimage.php where i reciving the image_id. $image_id_g = isset($_GET['img']) ? $_GET['img'] : 0; but i printing always 0's but i want to print the image id here i also … |
| | Hello, can anybody help me here? I am using mysql database and xampp server. Now, I made the database using my laptop computer and I have to distribute the database with its records to another laptop computer. The problem is when I tried to transfer the database file to the …  |
| | Hi, I have a problem in making a query.I have two tables patient and encounter. Patient has one to many relation with the encounter table. The encounter table has a field encounter_date. I want to make a search query in which I enter the date ranges and the query fetches … |
| | Can some one help my butt out that why I only get one check box out of the 4 to show up in my email to myself when a user hits submit? When ever I check box any email I only get the bottom check box to show up in … |
| | Hi, My phpmyadmin is inside the server. I want to connect my database from my remote PC to the database in the server using php. I would greatly appreciate if someone can suggest a way to connect the database remotely in windows platform. Thank you. |
| | Hi all, this is what I've built: A dynamically built form which selects the questions depending on the section of the form it's in. The problem: Each form input is called `answer[]` passing the selected value to an update query $updateSQL = sprintf("UPDATE tblsite SET sitetypeid=%s, pctid=%s, contactname=%s, address=%s, postcode=%s, … |
 | Hi all I have recently watched a tutorial series from PHPACADEMY called the advert rotation script series. I have found a small problem, the problem is that if any of the adverts have expired then the rest will not show. does anyone have any solutions for this issue, that if … |
| | i get erros here: Deprecated: Function ereg() is deprecated in C:\xampp\htdocs\a_upload\zoom.php on line 48 <?php $visitors = 0; $handle = opendir(session_save_path()); while(($file = readdir($handle)) != FALSE) { if($file != "."&&$file !="..") { if(ereg("^sess",$file)) $visitors++; } } echo "there are $visitors online"; ?> here is my full code if you need … |
| | Hi, I want to know how to select data from a database with two drop down menu. I can select a data from mysql database with one drop down menu. But I don't know how to combine two drop down menu to select data from database and show it in … |
| | i am only display 10 images on this page but it takes like 4sec to load. which is alot, i should take like 1 or 2 sec to load. any thoughts? i also tired joining sql <?php include("include/header.php"); //check, if user is loged in or not if(isset($_SESSION['username'])) /*** user is … |
| | Here is a tricky one that im having issues with... I have a page called events.php that has a include to query sql and pull events from the database after todays date and include the artist information from a include file. here is the code. The events page has a …  |
| | <?php mysql_pconnect("localhost","root",""); mysql_select_db("AppDevelopMenu") or die( '1'); $sql1=mysql_query("select Question from questions where QId ='1'"); if(!$sql1) echo '2'; else{ $question=mysql_fetch_assoc($sql1) ; $outputq[]=$question; $sql=mysql_query("select OptionId,OptionContent from options where QId ='1'"); if(!$sql) { echo '3'; } else { while($row=mysql_fetch_assoc($sql)) $outputq[]=$row; print(json_encode($outputq)); } } mysql_close(); ?> i have to modify this code to read json … |
| | so i have a table called image: ->image_id, user_id, img, name and i want to del one row where image_id = 3; $del = mysql_query("DELETE image WHERE image_id = '$image_id_g'"); i want to del whole row not just image_id. iam not sure if this will del whole row  |
 | Hi, I'm a beginner programmer and I'm developing this web app, nothing major; the hardest part was writting to text file (not really hard...) Anyways, my company policy doesn't allow us to install server softwares on computers. So now, I can't run the PHP code I wrote!! **I am wondering … |
| | Hi all. Maybe someone can help me here. I have a pagination document in php to paginate a large mysql table. This pagination document (by Jatinder Singh Thind, www.phpsense.com) "includes_once" another pagination document that has functions to handle the page links. The functions return a link. I'm trying to get … |
| | I have a comparison of 2 variables in a script, and am not getting the desired results, and wondered what the simplest comparison would be to obtain those results... $username='TestName'; $user='testname'; if ($username==$user){ print "This is the result I want." ; }else{ print "This isn't the result I want." ; … |
| | Hello, I am building a blog - just to shapen my skills. Since leaving college I feel like I have been loosing my programming edge. I work in IT and I primarily work on Oracle databases as a developer. Here is what I am building - a blog. I have … |
| | Hi, I'm at a conference that is using a form in a website that I developed, and for some reason the form is not accepting the value of the checkbox when it is selected. It used to work fine, and apparently I did something within the past few days that … |
| | Good evening I'm looking for yet more assistance, and hope someone is able to point me in the right direction. I'm trying to produce a format for our tipping competition, whereby people who fail to complete their entries are shown a) without a result in the profit column, and b) … |
 | Hello Everyone, I am using a Javascript Library called [Turn.js](http://www.turnjs.com/) and basically, I am building an ebook reader, now the problem is that I need to load external pages, these pages have their own animation and css layouts per page, plus the image is made for an iPad so vertically … |
 | I was creating a database for my sister showing which Goalkeepers have the most clean sheets during the Soccer European Championships. I know that if I want to just display the Goalkeepers in order of amount of clean sheets then my SQL code would read: SELECT * FROM gk ORDER … |
| | 1st - this code here prints random image from database. but i need help print random images but no repeating images. 2nd queestion is that how can i use this code to print image name. too. $Q = "SELECT (SELECT image_short_name FROM user WHERE username = '$user') as `image_short_name`" .",`image_id`,`image`" … |
| | Okay, my head is swimming as I've been trying to figure out what I'm doing wrong here. I am certain it's something stupid and I've tried different ways of putting it all in, but still no luck. Basically, I am trying to make it so I can put in our … |
| | Hi, everybody i have problem in fileuplaod.apache error log display the following error mesg File does not exist: C:/wamp/www/uploads/planbooks/0f3d1d9a2ac7fbaf6ed4b4c266901eb579e2e658.jpg, but i creates folder in uploads/planbooks class PlanbookForm extends BasePlanbookForm { public function configure() { parent::configure(); $this->useFields(array('photo','title_name','country_id','zone_id','place','itinerary','occasion','date','description')); $this->widgetSchema['photo'] = new sfWidgetFormInputFileEditable(array('label' =>'photo','file_src' => '/'.sfConfig::get('sf_web_upload_dir').'/uploads/planbooks/' .$this->getObject()->getPhoto(), 'is_image' => true, 'edit_mode' => !$this->isNew(), … |
| | i want to get image_id. which is store in database long blob. iam send a image id from different page to this page. and i am using _GET to revice the image_id on this page. $image_id = $_GET['img']; but it say Undefined index: img is there a different way to … |
| | echo" //i need this echo; <form class='form' action='zoom.php?img=<?php echo intval($_GET['img']);?>' method='post'> //i dont need echo in here "; i also tired action='zoom.php?img= intval($_GET['img'])' action='zoom.php?img=$_GET['img'])' but no luck it give me syntar error every time |
 | Hello Everyone Iam Exporting All My Data From Mysql To Txt File With This Code <?php $sql2 = mysql_query("SELECT * FROM export INTO OUTFILE '/Zero.txt' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'"); ?> I Need To Edit The Code So It Export The New Data I Insert In MySql … |
| | Hi there guys, I seem to be having a silly issue and I cant figure out why, my code is working fine for uploading and storing the image name in the datebase, but my issue come about when the form gets sumitted with no file selected I do want this … |
| | Hi, Currently I am building a html page that has some fields to search items into database. For the moment I am using 2 files index.html and search.php, in the page index.html I can input the word that I want to search in the database and I send the inputs …  |
 | Hi, I want to know how to search the inputs provided by the user in the form of checkboxes in a mysql database. <form> <input type="checkbox" name="interests" value="Food"> <input type="checkbox" name="interests" value="Movie"> <input type="checkbox" name="interests" value="Music"> <input type="checkbox" name="interests" value="Sports"> <input type="checkbox" name="interests" value="Reading"> </form> I have other input elements … |
 | Hi, when a user login, i want yo use his session username to query a secific database. I am trying to use the code below but it is not working. $username=$_SESSION['username']; can someone help me. |
| | Hi, I have a checkbox in my form and want to see the changes to it in next page but the problem is if I un-check a checkbox then the $_POST variable will not include it in next page so I won't be able to the changes. Any idea for … |
| | ... <?php $sql_display_words="SELECT * FROM Data1stWord"; while($row = mysql_fetch_array($sql_display_words)) { $ID = $row['ID']; $Word = $row['Word']; ?> <td><?php echo $ID ?></td> <td><?php echo $Word ?></td> <?php } ?> ... I tried to display data from database (Id and word) in table but it show blank in my table. Did I … |
| | Hi, Does anybody have a tutorial where I can filter the table data with drop down menu? |
| | Im having a issue with comparing dates below is the code. it shows all rows even dates that have passed todays date. The Date field is set as date in sql. <?php $con = mysql_connect("localhost","myusername","mypassword"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("mydatabase", $con); $todays_date = date("Y-m-d"); … |
| | I am trying to retrieve Mysql data, populate a form, user amend/delete fields, UPDATE and return data to database. It is the last stage that does not happen. I press UPDATE RECORD and screen returns to ID input. Where have I gone wrong, please ? <?php // require_once 'dbconnect.php'; if … |
| | Hi I have a question. I don't know where to started. I recently installed **CKEditor** and would like to know how to create a **Archive** page. It's kinda like a blog but for me it's kinda neat using the **CKEditor**. For example: Article: Hi ... page. I want to save … |
| | Hi I'm getting **mysql_fetch_array() expects parameter 1 to be resource, boolean**, I check the white space and maybe some can tell me what I did so I can corrrect the mistake. Thanks <?php session_start(); header("Cache-control: private"); require_once ('../include/init.php'); include_once("../ckeditor/ckeditor.php");?> $page = $_GET['page']; $sqlcats="SELECT * FROM pages WHERE pagename = '".$page."'"; … |
| | I have this drop down menu but I want to select its value and run a SQL-query with php. How do I do that? <select name="SelectMake"> <option value="make">Make</option> <option value="toyota">Toyota</option> <option value="honda">Honda</option> </select>  |
| | **i need help in my code !! ** <?php echo $prev.' '.$next;?> **when open this page need make next and prev in link ? how can i do it ? I need my link Like It to show in body (Div ) ! how can i make it ** <?=$prev.' … |
| | Hi Guys, I have the following code in a massive string... but there all different: ##component5#?1,4,1## They all start with ##component and end with ## but the bit in the middle can be anything... and I need to remove this text completely from the string... What would be the best … |
| | I have tried to connect to ftp server it windows. It works well with. But when I used the same with red hat i was unable to connect to server. ftp service is already running in redhat. $con_id=ftp_connect("192.168.0.8")or die("Couldn't connect to"); ; $login_result = ftp_login($con_id, "newuser", "wampp"); // check connection … |
| | I add a html page to the php website. After added, the webpage can run correctly, but thers is a line said Fatal error: Class 'EquipmentPage' not found in E:\2012\SIM Suite Project\wamp\www\test1\Web\equipment.php on line 7 at the bottom of the page. Can any one help me solve this problem. equipment.php … |
| | I need to select a value on a MYSQL table using PHP. Basically I have PDATE column (which I need to make sure it's today's date) then STKNO column (if the value there is 11, then it's Price Index and if the value there is 10 then it's Weighted Index). … |
 | <?php foreach ($_options as $_option) : ?> <input id="xyys" type="hidden" name="xyys" value="<?php echo($_option['value']);echo ($_option['option_id']);?>" /> <?php if($_option['label'] != 'Corte'): ?> <?php $_formatedOptionValue = $this->getFormatedOptionValue($_option) ?> <dt><?php echo $this->htmlEscape($_option['label']) ?></dt> <dd<?php if (isset($_formatedOptionValue['full_view'])): ?> class="truncated"<?php endif; ?>><?php echo $_formatedOptionValue['value'] ?> <?php if (isset($_formatedOptionValue['full_view'])): ?> <div class="truncated_full_value"> <dl class="item-options"> <dt><?php echo $this->htmlEscape($_option['label']) … |
| | so i got 3 tables. user, image, comment user -> user_id user_name password image->image_id user_id image image_name comment-> comment_id user_id image_id comment and image, comment are store in database i got a gallery.php. here user will click on this image <a href=\"zoom.php?img={$row['image_id']}\"><img src=\"$src\" width='130px' height='130px' class='image_p' /></a> wich will lead … |
| | Hello Everyone Iam Exporting All My Data From Mysql To Txt File With This Code <?php $sql2 = mysql_query("SELECT * FROM export INTO OUTFILE '/Zero.txt' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'"); ?> I Need To Edit The Code So It Export The New Data I Insert In MySql … |
| | I am trying to build a query that will display the Amount of people that signed up in a certain month. I am adding the date_time to the database at the time someone signs up for a course. I want to display the months and total sign-ups for the month. …  |
| | Hi, In mysql kruti 013 font is not working. I set table Collation:utf8_general_ci Need suggestions. attached document has kruti 013 data. |
The End.