Skip to main content

Coding Corner

Learn how to customize the way you work with Adobe apps.

464 Posts
M
mariana03Participant
 Questions
K
kpmiKnown Participant
 Questions
N
ncsunderlandParticipant
 Questions
I'm trying to pull a record set and I'd like to load the data into an array

It loops through and I see it going through all the data correctly, but when I try to assign it to an array using $i - it just keeps replacing it, it doesn't add a new value to the array.Thanks in advance!!$index = "";$service_singular = "";$service_plural= "";$sub_service = "";$description = "";$duration = "";$duration_descript = "";$price = "";$i = 0;if ($fac_id != "" && $fac_id != 0){   if ($stmt = $mysqli->prepare("SELECT `index`,`service_singular`, `service_plural`, `sub_service`, `description`, `duration`, `duration_descript`, `price` FROM `service` WHERE `fac_id`= ?")) {      $stmt->bind_param('s', $fac_id); // Bind "fac_id" to parameter.      $stmt->execute(); // Execute the prepared query.      $stmt->store_result();      // $i = $stmt->num_rows;   $stmt->bind_result($index,$service_singular, $service_plural, $sub_service, $descripti

6912
N
S
suenooscuroParticipant
 Questions
uniquereplete
uniquerepleteParticipant
 Questions
J
jandbjParticipant
 Questions
N
ncsunderlandParticipant
 Questions
Nancy OShea
Community Expert
Nancy OSheaCommunity Expert
 Questions
JS won't run locally

Ever have one of those days?  I just wasted 3 hours tracking this down.I had this document open and the JS Tabbed panels would not fire in any browser.  WAMP is my local testing server.<!doctype html><html><head><meta charset="utf-8"><title>TEST</title><meta name="viewport" content="width=device-width, initial-scale=1"><meta http-equiv="X-UA-Compatible" content="IE=edge"><!--[if lt IE 9]><script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script><![endif]--><!--Bootstrap--><link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css"><link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.4.0/css/font-awesome.min.css"></head><body><div class="container"><div class="row"><div class="col-md-10"><!-- Nav tabs --><ul class="nav nav-tabs">    <li class="active"&g

7191
Nancy OShea
Community Expert
T
tiripsParticipant
 Questions
Rob Hecker2
Rob Hecker2Legend
 Questions
Search algorithm

I am interested in hearing about the self-coded PHP/MySQL site search processes others use.MySQL LIKE simply doesn't cut it.MySQL MATCH AGAINST IN BOOLEAN MODE is an improvement over LIKE, but still disappoints.Lucene-based crawlers/search engines require Java and special applications on the server, and seem most appropriate for huge document collections.PHP Sphider combines a PHP-based crawler/indexer with good search features, but the code is ancient and buggy. The code is easy to understand so I have considered overhauling it, but that would be time consuming and success is not assured.Although my whole CMS database is large, each client site has no more than 500 pages to search, so iterating through all the page content and using PHP to process results seems like a viable option. I can then remove common words like "the, to, a, with" from the search string, create an array of the search terms and iterate through the database content results using functions like similar_text (), ran

10011
R
Max Resnikoff
Max ResnikoffParticipating Frequently
 Questions
PHP query: How to determine if variable time is before or after today

Hi,I have this code which determines whether or not the return date of a book (format: d/m/Y) is before or after today.<?php if($row['return_date'] >= date("d/m/Y")){ ?>        <a href="loaning_remind.php?loan_id=<?php echo $row['id']; ?>" onClick="return confirm('The loaner will receive an email reminding them that their item loaned is due for return')">        <div class="record_button">            <img src="../images/icons/mail_icon_blue.png" width="100%" height="auto" title="Send Email Reminder">            </div>                Future        </a>        <?php } else { ?>       

4311
O
R
revdaveInspiring
 Questions
use if/then inside .each loop

hi all,still a javascript jQuery newbie...I want to add text inside the .each loop using an if/then statement - not sure how to do it...basic.$.each(data, function(key, value) {            console. log ('item', key, value);    output += "<li>" +  value.id + " " + value.name + " " + value.date  + "</li>";  });I tried this IF... : but doesn't work...$.each(data, function(key, value) {              console. log ('item', key, value);      output += "<li>" +  value.id + " " + value.name   if (value.name == "Bob") {  + " nice name "  }  " " + value.date  + "</li>";  });Q: Any idea how to get it to work?

6891
sinious
R
revdaveInspiring
 Questions
php session vars not showing up

php session vars not showing upI have a slightly odd setup (let's pretend we don't want to change this right now)I have a HTML page on site 1- on page1.html I have an iframe that goes to site2 (php)<iframe src="http://mysite2.com/page2.php" ></iframe>page2.php sets some session vars like<?phpif(!session_id()) session_start();$_SESSION["id"] = 123;?>- and then does a page jump to page3.phpecho '<meta http-equiv="refresh" content="2; url=ipage3.php">'---- when I get to page3 the first time the session vars do not show uplike:<?phpif(!session_id()) session_start();echo $_SESSION["id"];?>---> but when I manually refresh the original site 1 page then it recycles everything and then successfully shows the session vars on page 3Q: Curious why the session vars do not show up the 1st time around? Any idea how to fix this?

5291
Rob Hecker2
K
kpmiKnown Participant
 Questions
How do I get rid of extra white space between nav and next div?

How do I get rid of the white space after the nav bar in Dreamweaver CC? The code (without all the nav links) is:<div class="container-fluid" id="wrapper">      <!-- Header -->      <header>  <div class="row"><img src="images/header.jpg" class="center-block image-fill" alt="Kairos Prison Ministry"></div></header><!-- Navigation -->    <nav class="navbar navbar-default dkblue col-lg-8 col-lg-offset-0">    <!-- Brand and toggle get grouped for better mobile display -->    <div class="navbar-header">      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#defaultNavbar1"><span class="sr-only">Toggle navigation</span><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></button&gt

206233
Diego_Maradona
A
Anonymous
 Questions
ColdFusion 8 to 11 CFGrid Method

Hi,I have a CFGrid which was working properly in ColdFusion 8 but after I upgrade my version to ColdFusion 11, the CFGrid does not update/rebind data after it's refresh button is being clicked. I have 4 inputs, a search button and a grid which is for searching module. Below is part of my code:- <script type="text/javascript" >        getID = function(){               if(document.thisform.usrID){                     var usrID = ColdFusion.getElementValue('usrID');              alert(usrID);               return usrID;            }     }     getName = function(){      &nbsp

9351
A
N
ncsunderlandParticipant
 Questions
mysql Update problem

I've tried several variations but I can't get any of them to execute.If someone can tell me what's wrong with this I'd be grateful -~~~~~~~~~~~~~~~~~      if ($stmt = $mysqli->prepare("UPDATE members (password, salt) VALUES (?,?) WHERE email = ?"))      {        $stmt->bind_param('sss', $newpassword,$random_salt,$email);         // Execute the prepared query.        $stmt->execute();        header("Location: ../secure/changepass.php?success=1'");      }      else {      header("Location: ../secure/changepass.php?passwordfailed=1'");      }~~~~~~~~~~~~~~~~~~~~~~~~~~~~Thanks!!

16094
N
Max Resnikoff
Max ResnikoffParticipating Frequently
 Questions
How to get emails from 2 MySQL tables

Hi,I need to use only 1 query to get all emails which are stored in two different tables.This then goes on to create an array and gets imploded for emailing, and another variable explodes it for displaying as a list on the page.Here is the query which gets the emails from 1 table, but is missing the statements to get the emails from the other table (named: clients)<?php//Get users emails//$user_sql = "SELECT * FROM users GROUP BY email";$user_query = $con->query($user_sql);//$user_row = $user_query->fetch_array();//implode//$user_emails = array(); while($user_row = $user_query->fetch_array())  {    $user_emails[]=$user_row["email"]; } //Set variables//$email_recipients = implode(", ", $user_emails);$user_recipients = explode(',', $email_recipients);?>Thanks!

7381
Rob Hecker2
sinious
siniousLegend
 Questions
while (true) {

Perpetual thread on what you either learned today, is haunting you or just what you need to get off your chest.Just let it fly..So today our client, mid HTML5 project, handed us a random PDF to assure our single page application conforms to for their CMS. It is a simple project that is replacing a simple Flash animated page, designed responsive.We gave a nice pencil sharpened estimate for the project to hit it head on the nail. We sharpened so much because they had us remove all SEO costs like direct URLs, etc. Got approved and moved forward. Too good to be true, just replicate their supplied design exactly, mostly solid colors. Woohoo!A month later (it's a 40 page app) we showed results and then received this strange requirements PDF. Our SPA done with AngularJS and jQuery, now had requirements like:- Direct URL for each of the 40 pages (this was formerly removed as a requirement as mentioned)- Must run within a layer over the original site, over a shaded layer to modally pop it forwa

29352
Rob Hecker2
N
ncsunderlandParticipant
 Questions
Update password

I've tried several variations but I can't get any of them to execute.If someone can tell me what's wrong with this I'd be grateful -~~~~~~~~~~~~~~~~~      if ($stmt = $mysqli->prepare("UPDATE members (password, salt) VALUES (?,?) WHERE email = ?"))      {        $stmt->bind_param('sss', $newpassword,$random_salt,$email);         // Execute the prepared query.        $stmt->execute();        header("Location: ../secure/changepass.php?success=1'");      }      else {      header("Location: ../secure/changepass.php?passwordfailed=1'");      }~~~~~~~~~~~~~~~~~~~~~~~~~~~~Thanks!!

4922
O
K
kpmiKnown Participant
 Questions
Navigation won't collapse to "sandwich"

Hi you savers of lost coding souls:I am still coding my site, and the navigation won't collapse into a "sandwich" when I reduce the screen size. It used to, and then just stopped. I fubar'ed something somewhere.You can see the page at Kairos Prison Ministry.The pertinent css is:body {  font-family: Calibri;}#wrapper {  padding-left: 0px;  padding-right: 0px;}#nav {  text-align: center;}header {  width: 100%;  background-color:#fff;}#navbar {  border-radius: 0px;  border: 0px;  margin-bottom: 0px;  background-color: #3458B8;}.dropdown-menu li {  float: left;  width: 100%;  margin: 0;  padding: 0;  border-bottom: 0px;}.bg-primary {  background-color: #3458B8;}.navbar-default {  -webkit-box-shadow: inset 0px 0px;  box-shadow: 0px 0px;  border-width: 0px;  border-color: #3458B8;  background-color: #3458B8;  border-radius: 0px;  border: 0px;}.navbar-nav {  border-radius: 0

6571
Nancy OShea
Community Expert
Nancy OShea
Community Expert
Nancy OSheaCommunity Expert
 Questions
PHP simplexml_load with CDATA

Hi everybody!I'm trying to scrape some data from an XML file that contains content inside CDATA tags and I'm having trouble with it.feed.XML file:<?xml version="1.0" encoding="UTF-8"?><channel>     <item>          <pubDate><![CDATA[Thu, 17 Sep 2015 16:02:53 -0700]]></pubDate>          <title><![CDATA[Hello world!]]></title>          <url><![CDATA[http://example.com/?id=hello_world]]></url>     </item></channel>PHP:<?phpif (file_exists('feed.xml')) {    $xml = simplexml_load_file('feed.xml');     echo $xml->channel->item->pubDate; } else {    exit('Failed to open xml.');}?>Error:Trying to get property of non-object in feed.xmlIf I print_r  $xmlI get an array of no

26201
Nancy OShea
Community Expert
M
mrs46077512Participant
 Questions
T
tasnim999Participant
 Questions
G
George123407Participant
 Questions
File Preview Solution for muse ( How do I add in width and height Restrictions?)

Right so i have this HTML code that I can embed into Muse which is -<input type="file" accept="image/*" onchange="loadFile(event)"><img id="output" /><script>    var loadFile = function(event) {        var reader = new FileReader();        reader.onload = function() {            var output = document.getElementById('output');            output.src = reader.result;        };        reader.readAsDataURL(event.target.files[0]);    };</script>This code allows me to preview files but how do I add what width and height I want the file to be previewed at? Please help, many thanks!

5591
Brad Lawryk
Roy Marshall
Roy MarshallKnown Participant
 Questions
Help needed to target jsxbin file inside HTML extension panel

HiI am making small steps into putting my scripts into a native HTML Panel using Sublime Text, and the Extension Builder plugin for Sublime Text 2.I have no problems running a built in JS file from within the panel, but when I want to target a compiles jsxbin file, I am having issues targeting it. function createFile(){   var parent = (File($.fileName)).parent.parent;   //alert(File($.fileName)); //returns /tmp0000000001   alert(parent); // returns a single slash   alert("Script to run is " + parent + "scripts/helloWorld.jsxbin"); //returns Script to run is /scripts/helloWorld.jsxbin   try{   app.doScript(File(parent + "scripts/helloWorld.jsxbin"));   }   catch(e){   alert(e);   }   } The last catch above throws this message...Can someone tell me if its even possible to target a script in this way?Cheers

4471
Roy Marshall

Resources

Community Guidelines Help Center Learn tutorials
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices