39,326 Topics
| |
how to insert data in multi dimension array into mysql database in php. | |
Hello everyone, i need small help since im stuck, and im not that good with php and vB.net connections... So here is the problem, i manage to get connected to db and php script shows me if im connected or not, grab if user/pw is correct everything works fine, but … | |
i tried to display a common menu in php using php code please try to help me i'm blocked . | |
Example of my record : year quanitity name 2012 10 john 2012 20 mark 2013 30 david 2013 40 alex 2014 50 stacy while (!$report->EOF){ if(is_null($year) || $year <> $report->fields['year']) { $year = $report->fields['year']; ?> <tr><td align="center" colspan="2" >Year : </td><td><?=$year ?></td></tr> <? } ?> <tr><td align="center" colspan="2" >Quantity : … | |
Dear Friends, Help me to fix this.. Error Message : **mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in** Code is, <?php $database=$diocese; $table=$category; //capture search term and remove spaces at its both ends if the is any $searchTerm = trim($_GET['query']); //check whether the name parsed is empty if($searchTerm … | |
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 … |
The End.