Returning multiple models to view

See also questions close to this topic

• console.log looping json data but display not

  I'm trying to display json data on the page, however when sending the output to html it only displays the last id.

  When using console.log it loops through each id available but not on the page output itself

  var username = $("#usernameinfo").text();
  
  $.ajax({
      type: "GET",
      dataType: 'json',
      url: "<?= base_url()?>"+"account/listings/more_user_ads",
      data: {
          "username": username,
          "pid": "<?=$this->input->get('pid')?>"
      },
      success: function(res){
          for (var i = 0; i < res.length; i++){
              var output = "";
              var object = res[i];
  
              output = "<p>" + object.id + "</p>";
              $("#tg-authoradsslider").html(output);
              // outputs only the id of 3 which is the last id in the loop
  
              console.log(output);
              /* consoles.logs 
              <p>1</p>
              <p>2</p>
              <p>3</p>*/
          }
      }
  });
  
• PHP Multi Query issues

  I am attempting to reference 2 tables using PHP mysqli, the issue I have is that one table has multiple rows I need and the first table only has single row.

  $sql = "SELECT * FROM `randomdbtable_recipes`,`randomdbtable_ingredients` 
  WHERE 
  randomdbtable_ingredients.Recipe_ID='$recipeID' AND 
  randomdbtable_recipes.ID='$recipeID'";
  $result = mysqli_query($conn, $sql);
  $resultcheck = mysqli_num_rows($result);
  
  if($resultcheck < 1){
    echo 'Unable to find recipe!';
  }else{
  
    $Ingredient = array();
    while($row = mysqli_fetch_assoc($result)){
      $RecipieName = $row['Recipe_Name'];
  
      $Ingredient_Name  = $row['Name'];
      $Ingredient_Quantity  = $row['Quantity'];
  
      echo'Recipie Name : '.$RecipieName.'<br>';
      echo'Recipie Description : '.$RecipieDescription.'<br>';
      echo'Recipie Image : '.$RecipieImage.'<br><br>';
  
      $Ingredient[] = array('Name'=>'$Ingredient_Name', 
      'Quantity'=>'$Ingredient_Quantity');
  
      foreach($Ingredientas $key => $value) {
        echo "Key=" . $key . ", Value=" . $value;
          echo "<br>";
        }
      }
      }
  

  The issue I am having is that I need add each ingredent so I can add them to a table, however with the above code, i just get

  Recipie Name : Hunters Chicken
  Key=0, Value=Array
  Key=1, Value=Array
  Key=2, Value=Array
  

  as an output.

  any help is very welcomed and much apricated
• php $sql INSERT INTO not posting new MySQL row with struct Encodable String VALUES

  Objective is to INSERT INTO FUBARtable the LoginName and LoginEmail variables from ios app LoginPage -> into new row of mysql database. Question is how to modify code, which now can insert new row with VALUES ("statictext", ...), so that it will insert new row with the variable USERvalues VALUES (LoginName, ...):

  // This $sql WILL insert new row with static text USERvalues
  $sql = "INSERT INTO `FUBARtable`(`userName`, `userEmail`) VALUES ('statictext', 'statictext')";
  
  // This $sql will NOT insert new row with variable USERvalues
  $sql = "INSERT INTO `FUBARtable`(`userName`, `userEmail`) VALUES (LoginName, LoginEmail)";
  
  // per GIJOW comment String? changed to String 
  struct USERvalues: Encodable {
    let LoginName: String
    let LoginEmail: String
  }
  
  // userInfo[username, email] passed from LoginPage
    var userInfo = ["Anonymous", "unknown"]
  
  let url = URL(string: "http://mysqlDatabase.com/insert.php")!
  var request = URLRequest(url: url)
  request.httpMethod = "POST"
  request.addValue("application/json", forHTTPHeaderField: "Content-Type")
  
  let Post = USERvalues(LoginName: self.userInfo[0], LoginEmail: self.userInfo[1])
  do {
    let encodedPost = try JSONEncoder().encode(Post)
    request.httpBody = encodedPost
  } catch {}
  let session = URLSession.shared
  let task = session.dataTask(with: request) { (data, _, _) in
  guard let data = data else { return }
  do {
    print(Post)
    let json = try JSONSerialization.jsonObject(with: data, options: [])
      print(json)
    } catch {}
  }
  task.resume()
  

  (applying GIJOW comment to remove ?) print(Post) prints out the correct userInfo values from the LoginPage:

  USERvalues(LoginName: "Arthur Dent", LoginEmail: "improbabilitydrive@gmail.com")
  
• Can <span> receive data from a database or only <input> can? #BootStrap

  Quick question

  Can span receive data from a database or only input #BootStrap

  I'm working on a FrontEnd school Project and I would like to know if is the only that can receive data from a database?

  FYI

  The BackEnd are using Laravel

  Thank you for your time
• Laravel mysql migrate error

  I recently format my mac book pro, after cloning the proyect from github and install the things I need like MySql and Sequel Pro I tried to migrate the database information but I get this error:

     Illuminate\Database\QueryException  : SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' (SQL: select * from information_schema.tables where table_schema = fisica and table_name = migrations)
  
    Exception trace:
  
    1   PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'")
  

  Versions:

  Mysql 8.0.11

  Laravel 5.6.12

  PHP 7.1.14 (cli)

  DB_CONNECTION=mysql
  DB_HOST=127.0.0.1
  DB_PORT=3306
  DB_DATABASE=fisica
  DB_USERNAME=xxx
  DB_PASSWORD=xxx
  

  I created the database from Sequel PRO GUI
• Carbon Between Returning False When It Should Be Positive

  I use Carbon to manage my open and close times of various venues.

  Currently it's returning false (using a test date) for a venue that's obviously still open and the code I've echoed is the same, code for reference

  public function getHours() {
        $date = Carbon::parse('12:01 AM', $this->timezone);
        Carbon::setTestNow($date);
        $now = Carbon::now()->setTimezone($this->timezone);
        //Carbon does a funky thing where Sunday is the first of the week
        //ISO standards has it as Monday, as do Yelp and Google
        $day = Carbon::now()->setTimezone($this->timezone)->dayOfWeek-1;
        if($day < 0) {
          $day = 6;
        }
        $yesterday = $day-1;
        //If yesterday < 0 then we set it to 6 (Sunday), as only Monday would reflect negatives
        if($yesterday < 0) {
          $yesterday = 6;
        }
        //Need to determine if yesterday's closing time is still here, meaning they're open until early hours
        $barDay = barDays::where('bar_id', $this->id)->where('day_id', $day)->first();
        $yestBarDay = barDays::where('bar_id', $this->id)->where('day_id', $yesterday)->first();
        if($yestBarDay === NULL) {
          $yestBarDay = barDays::create([
            'bar_id' => $this->id,
            'day_id' => $yesterday,
            'musicType' => $this->musicType,
            'type' => $this->type,
            'hours' => '8:00 PM - 2:00 AM'
          ]);
          $yestBarDay->save();
        }
        $yestBarDay->fixHours();
        //If yesterday it was closed, we don't care
        if($yestBarDay->hours !== 'Closed') {
          //Otherwise we get yesterdays hours and determine if they're still here
          if($yestBarDay->hasMultipleHours()) {
            $yestHours = $yestBarDay->getMultipleHours();
          } else {
            $yestHours = explode(' - ', $yestBarDay->hours);
          }
          if(!is_array($yestHours)) {
            $yestHours = explode(' - ', $yestHours);
          }
          $yestOpen = Carbon::parse($yestHours[0], $this->timezone);
          $yestClose = Carbon::parse($yestHours[1], $this->timezone);
          if($yestClose < $yestOpen) $yestClose = $yestClose->addDay();
          echo("The current time is $now, yesterday's open time was $yestOpen, yesterdays close is $yestClose, it is between these dates equal to ");
          if($now->between($yestOpen, $yestClose)) {
            echo('true');
            //Set $hours = $yestHours
            $hours = $yestHours;
            return [$yestHours[0], $yestHours[1], $yestBarDay];
          } else {
            echo('false');
          }
        }
        //Otherwise if barDay is NULL
        if($barDay === NULL) {
          //We create a new one to fill the void
          $barDay = barDays::create([
            'bar_id' => $this->id,
            'day_id' => $yesterday,
            'musicType' => $this->musicType,
            'type' => $this->type,
            'hours' => '8:00 PM - 2:00 AM'
          ]);
          $barDay->save();
        }
        $barDay->fixHours();
        if($barDay->hours !== 'Closed') {
          //If the hours aren't set to yesterday (The NOW is not between the open and close of yesterday)
          //We also check if it's closed, as if yesterday is closed it won't be set, so we need to check today
          if(!isset($hours)) {
            $hours = $barDay->hours;
          }
          if($barDay->hasMultipleHours()) {
            $hours = $barDay->getMultipleHours();
          }
          if(!is_array($hours)) {
            $hours = explode(' - ', $hours);
          }
          $open = Carbon::parse($hours[0], $this->timezone);
          $close = Carbon::parse($hours[1], $this->timezone);
          if($close < $open) $close = $close->addDay();
          if($now->between($open, $close)) {
            return [$open, $close, $barDay];
          } else {
            return ['Closed', $barDay];
          }
        } else {
          return ['Closed', $barDay];
        }
      }
  

  $barDay/$yestBarDay are both instances of barDays that have attached hours, the hours all follow the same format 8:00 PM - 2:00 AM (or the same with different hours), and I'm trying to check if the venue is still open.

  It echos this The current time is 2018-04-20 00:01:00, yesterday's open time was 2018-04-20 17:00:00, yesterdays close is 2018-04-21 02:00:00, it is between these dates equal to false

  EDIT: I found the error but I don't know how to fix it - Can I possibly SET the dayOfWeek in Carbon?

  Thanks

  • Zach
• PHP 7.0 Segmentation fault when reading memcached

  I use Laravel 5.5 with memcached 1.4.21. In front : nginx server (1.10.1) and a fpm process PHP 7.0.

  Cron task use the same model than web controller. But when cron accede to memcached, the process crash with a Segmentation fault. The same code work like a charme from a HTTP request. The only difference it's that cron use PHP CLI and web controller use fpm process.

  Sometimes I have also this error message :

  production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mybase.onefield' doesn't exist

  Yes "mybase.onefield", Eloquent try to use one table field in place of my table name.

  I have problem only on production server. Do you have any clues ?
• Homestead on Laravel 5: any code changes I make are not detected by browser

  I just set up default Windows 10/Homestead/Vagrant/Virtualbox/Nginx. Didn't change anything out of the box. I'm hyper new to this.
  
  

  I set up a custom site in Homestead.yaml and the welcome page works.
  
  

  I'm changing this:

  Route::get('/', function () {
      return view('welcome');
  });
  

  to this:

  Route::get('/test', function () {
      return view('welcome');
  });
  

  A simple 404 is served. I'm adding test controllers with artisan but everything throws a 404. My settings seem fine, I checked the yaml file and Nginx config (quite new to Nginx though). Vagrant reload --provision (or vagrant halt/up) don't help.

  (If this is a dupe I will delete, I've looked though).
• Warning: include_once(/public/../RequirementsChecker.php): failed to open stream: No such file or directory in /public/check.php on line 12

  So, I've searched the whole internet for this error, yet, i'm the only one who have this error, when i upload the script to http://exampe.com/folderand view check.php , i get no errors at all and it runs perfectly
  but the customer doesn't want it in a sub-folder , And here comes the problem, when i upload the script to /public and run check.php i get

  Warning: include_once(/srv/users//apps/quizyask/public/../RequirementsChecker.php): failed to open stream: No such file or directory in /srv/users//apps/example/public/check.php on line 12

  Warning: include_once(): Failed opening '/srv/users//apps/example/public/../RequirementsChecker.php' for inclusion (include_path='.:/opt/sp/php7.2/lib/php') in /srv/users//apps/example/public/check.php on line 12

  any help ?