39,323 Topics
| |
i have a table with the following structure CREATE TABLE IF NOT EXISTS `test_check` ( `id` int(4) NOT NULL AUTO_INCREMENT, `name` varchar(65) NOT NULL DEFAULT '', `lastname` varchar(65) NOT NULL DEFAULT '', `email` varchar(65) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; i have a … | |
i want to compare dates stored in database in the format yyyy-mm-dd by changing it in unixtimestamp in the mysql query.for this my query is $bquery="SELECT * FROM rt_booking WHERE rt_unit_id='".$_POST['unit_id']."' AND (SELECT UNIX_TIMESTAMP(str_to_date(rt_start_date,'%Y-%m-%d'))>=".$my11." OR SELECT UNIX_TIMESTAMP(str_to_date(rt_end_date,'%Y-%m-%d'))<=".$my22.")"; but it is giving syntax error. | |
Hi there, Hope someone can help me on this. I really need help. I have a javascript for a rotating image, whereby a total of 10 images will change automatically in every 3 seconds. It works well in a .html page, however it doesn't work in a .php page. In … | |
Hi everyone What I am trying to do: I am trying to rewrite my urls in seo frendly url. For that purpose I create the following table in my database: CREATE TABLE `seourls` ( `path` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, PRIMARY KEY (`path`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- … | |
I have the following Code: I also tried also to use foreach Loop but it doesn't work. Any one can help me please: [CODE] ############### Code <?php include("config.php"); $sql="SELECT * FROM news"; $result=mysql_query($sql); $count=mysql_num_rows($result); ?> <table width="400" border="0" cellspacing="1" cellpadding="0"> <tr> <td><form name="form1" method="post" action=""> <table width="400" border="0" cellpadding="3" cellspacing="1" … | |
Hello Everyone, I am trying to display a graph, but it is not working. I see that the variables is getting the correct value, so maybe the addSeries is not recognizing the variables. Can anyone help me? See the code below: <!DOCTYPE html> <html > <head> <?php //connect to database … | |
I am new to php, just made a simple calculator. when I don't select the radio buttons; a notice come up. Notice: Undefined index: r in E:\MY LOCAL SERVER\htdocs\php practise\calculator-form-advanced.php on line 59 Also I want show results in this input section <p> <label for="result">Result</label> <input type="text" value="" /> </p> … | |
Good Day Guys, I am working on a web application and I am not that really good in JQUERY/JAVASCRIPT but I am really interested to learn on that part of web development. Here is the scenario, I have menus that corresponds on records statuses Example this is the menus I … | |
i want laravel tutorial or projects for reference, i did not find laravel tutorial for geting api data through js and php, how to get data on view. please help ....i am new to laravel | |
i am trying to get the value of radio button which is generated by jquery. I think there is some problem in call events. Here is my code. HTML `<div id="divOption1"></div>` Jquery radio button generate `document.getElementById('divOption1').innerHTML = '<input id="option1" type="radio" value="1"/> '+ questions[currentQuestion]['option1'];` here i call jquery function to get … | |
i have a php associate array and i want to convert it to a javascript array. how best do i do this | |
trying to search by the file name keep getting a "expects parameter 1 to be resource, boolean" error what am i missing? $pagename = basename($_SERVER['PHP_SELF'], ".php"); mysql_select_db("tagpoint", $con); $sql="SELECT * FROM tagpoint WHERE title = '".$pagename."'"; $result=@mysql_query($sql); $row = mysql_fetch_array($result); | |
Hi all,... i've created hyperlink from database to pdf file, my goals when i click the hyperlink then display the pdf file, but the problem is there is a transition page with broken image on the upper left corner and if i place the cursor around the icon the cursor … | |
is it possible to use a string array in mysql using the set data type and add a valuse to it, like a list of names? | |
Dear Members/Guests, First of all, I'd like to tell you, the following website I am going to talk about is not created by me, so that's why I am having some problems editing or developing it. The problem is, that I have duplicate content on my website's subpage, have a … | |
my url keys are coming from database , say if my url is abc.com ,i have used a rewrite rule RewriteRule (.*)/(.*)/mcqs/(.*)/(.*)/(.*)\.html mcq.php?mcq_id=$4&page=$5 in this rewrite rule , first four (.*) are coming as url keys from db, but problem is that in address bar am able to add any … | |
Hello, how do i add an hour to time with DATE_ADD in DATE_FORMAT? Here is my code : <?php session_start(); include('includes/main_funcs.php'); $db = db(); $reponse = $db->query('SELECT name, message, DATE_FORMAT(time, '%H:%i') AS forTime FROM chat ORDER BY ID DESC LIMIT 0, 10'); while ($donnees = $reponse->fetch()) { echo'['.$donnees['forTime'].'] <strong>'.htmlspecialchars($donnees['name']).'</strong> : … | |
I have been having problems with this code and i cant find out why I am trying to add a new element to an array. it says it goes throu butwhen i check its empty: $sql="UPDATE $title SET arole = CONCAT_WS(',', arole, '$name') WHERE op = '$name'"; if (!mysql_query($sql,$con)) { … | |
I have an associative array that is many levels deep. I want to convert it to an indexed array (i.e. remove the key names). I don't want to flatten it; I want it to remain a nested array with all of the values intact. What's the best way to accomplish … | |
Hello everyone, I'm new to php and i'm developing a website for a school project. I need to implement a combobox with some options, for exemple, if I choose "Alimentation" it appears a table with the specific fields for this option and If I choose other option it appears a … | |
Strange question i am afraid, i have a friend who is after information on a database called "Profile". Does anyone have any links to this, as I have been unable to find anything | |
Hi, Below simple code is not working.. Please suggest?? <?php $userinput=24;?> <a href="s.php?id=<?php echo urlencode($userinput); ?>">test</a> | |
this is example of my data name month abc Jan xyz Jan efg feb ijk apr mno apr question is, how to group, using while loop, so the result like this **Jan** abc xyz **feb** efg **apr** ijk mno | |
I have been looking for an answer to this question since so long.. pleaase help.. We developed a website for which a ticket has been raised to make the links case sensitive Server : Linux with Apache CMS used : Joomla 2.5 Framework : Zend framework We are using SEF … | |
Hi All, Am pretty newbie to php and am battling with a piece of code and just dont know what I am doing wrong. I have a set of tabs along the top of my page with differnet user levels. If a user is an admin then they get to … | |
Hi, it's me again.. I have this codes wherein I can export the data from the databse to Excel.. I get a **Notice: Undefined variable: aData** on one of the php files.. well two of them actually.. The weird thing is... The other page which I have modified - i … | |
Hi, I am trying to read the content of url. when manually i put url in browser link : [url]http://www.mvnforum.com/mvnforum/viewmember?member=pbmissions[/url] it opens. but using code [code=php] $homepage = file_get_contents('http://www.mvnforum.com/mvnforum/viewmember?member=pbmissions'); echo $homepage; [/code] Warning: file_get_contents([url]http://www.mvnforum.com/mvnforum/viewmember?member=pbmissions[/url]) [function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.1 503 Service Unavailable in C:\xampp\htdocs\test.php on line … | |
Hi, I want to select all records from a table where the DateAdded field's date and time (Default value Timestamp field) is more than say 3 hrs ago. eg: something like SELECT tbldata.* FROM tbldata WHERE (tbldata.DateAdded <= now()-3); I can get it working with days difference but do not … | |
I have a business directory website that users can create listings in. I already have the listing functionality mostly working. An example of the code i use is this: <div id="companyName"> <?php echo $row_getListing['company_name']; ?></div> What I want is a code like this to get an image from the logo … | |
I really don't know where to ask something like this, so sorry for this. I have an issue and I really don't know how to solve it. I have php "file upload script", which users uploading files all the times, now the server is nearly full an I want to … |
The End.