Posts by extjac

extjac 0 Newbie Poster

11 Years Ago

Re: Storing PHP serialize/json_econde data

Hi Bob,
I actually have several tables with relatioships. The thing is that i wanted to know if it was a bad idea/practice to store the data as json/serialized. (It seems so simple to code it)
thanks for your answer.

Databases json mysql php

extjac 0 Newbie Poster

11 Years Ago

Re: Saving multiple values in a Colum as as json_encode

thanks diafol. that is how is have it....User, Events, Events_countries and Countries tables. But after saying someone storing json i kind of wanted to go the same way...It will save me so much coding..

Web Development json php

extjac 0 Newbie Poster

11 Years Ago

Storing PHP serialize/json_econde data

I have a table that will have several fields, such as counties, age_groups, gender, sports, etc..
on countries I will be storing data with this format["US","CA","DK","FI","RU","SE"]
on age groups I will be storing data with this format["2000","1999","1998"]
on age groups I will be storing data with this format["M","F"]
on age groups I will be storing data with this format["soccer","hockey", "tennis"]

Is it a bad idea/practice so store serialized/json_encoded data on mysql?

Databases json mysql php

extjac 0 Newbie Poster

11 Years Ago

Saving multiple values in a Colum as as json_encode

Hello!
I have a table called Events and one of the colums is called "country". I want to be able to query events based on the user country. So eventID #1 might have "country" = US, CA, MX (multiple values), so if a user is from the US logs-in will see the eventID 1 , but also if a user from CA logs-in will see the same event.

I created a <select name=country[] multiple> with a list of countries. I would like to be able to select several countries and save them in a colum. I tested json_encode and serialize and it like better json_encode but I was wonderig what's your view?

so on my form i have someeting like this....

<select name="country[]" size="10" multiple>
<?php foreach ($countries as $key => $val) { ?>
<option value="<?=$key?>" <?php if (in_array($key, json_decode($event->country))) { echo 'selected'; } ?>><?=$val?></option>
<?php } ?>
</select>

my controller looks like this:

function save($id)
{
$event = Event::find($id);
$event->country = json_encode($input['country']);
$event->save();
}

my query looks like this

function getEvents() {
return 'Select * From events where country IN ($user->country) ';
}

Web Development json php

extjac 0 Newbie Poster

11 Years Ago

Laravel Cors API for multiple clients (domains)

Hello. I am trying to implement a Laravel API that will be consumed by different clients (domains). The API basically, sends json response to the clients. For instance, when the client app.anyclient.com sends a AJAX/post request to api.myapi.com/login …the API is able to validate and login the user; however, the session will not persist. So if I want to check if the session still active I always get a false response, as if the session was never imitated. The interesting thing is that if I send the same request from the same domain, I am able to get the true response.
I was wondering how you guys do it. I am not sure if this is a Laravel issue or just me not understanding how CORS works…any recommendations?

Web Development api php

extjac 0 Newbie Poster

11 Years Ago

Ajax/JSON and IE8 issues

Hello,

I am trying to populate the state drop-down based on the country selection. I creates this jQuery scrip that WORKS in firefox, chrome and mobile but for some reason does not work in IE8 (dont have IE7 or IE9 to test).
What am i missing?

    //update states/province drwon down
    $( "#country" ).change(function() 
    {
        var id = $(this).val();
        var request = $.ajax({ 
           type     : "GET",
           dataType : "json",
           url      : "/api/v1/country/"+id+"/states",
           cache    : true,

          beforeSend : function ()  
                      {
                        $("#state").html('<select name="state" id="state" class="form-control input-sm " required ><option value="">Loading...</option></select>').show();                        
                      }                            
        });
        request.done(function( response ) 
        {
              cuntries = '<select name="state" id="state" class="form-control input-sm " required >';
              $.each(response.data, function(i,data) {
                 cuntries +='<option value="'+data.code+'">'+data.name+'</option>';
              });
              cuntries += '</select>';

              $("#state").html(cuntries);

        });
        request.fail(function( jqXHR, textStatus ) 
        {
            alert( "Request failed: " + textStatus );
        });
        return false;     
    });//close change

Web Development javascript json

extjac 0 Newbie Poster

11 Years Ago

Re: MVC Design Question

thanks for your quick response.

Web Development php software-architecture

extjac 0 Newbie Poster

11 Years Ago

MVC Design Question

Hello, I would like to move an web application to MVC Laravel 4 (not sure yet). The challenge is that the application is used by many customers and each customer have its own website/front-end but they all use the same backend/admin.

The strucutre is something like this...
backend.domain.com (all customers go to here to update their site)
www.cliente1.com (a folder on the server with customized hml, css, etc that access the share PHP code)
www.cliente2.com (a folder on the server with customized hml, css, etc that access the share PHP code)
www.cliente3.com (a folder on the server with customized hml, css, etc that access the share PHP code)

So basically the question is: can i use MVC for this type of solution? if so, what would be your recomendation from a design stand point

Thanks!

Web Development php software-architecture

extjac 0 Newbie Poster

12 Years Ago

PHP MVC frameworks vs no MVC(PDO)

What's your recommendation for PHP MVC frameworks?? i tested Codeigniter and it seem easy to use....

I am not a full time developer, but I do have some customers with backends, etc…My intention is to migrate some of old php code to PDO but I am now wondering if I should move the code to MVC....any recommendation?

Web Development php php-codeigniter software-architecture

extjac 0 Newbie Poster

12 Years Ago

Re: PDO MySql insert not working

BY THE WAY....i think you forgot to bindValue() on our code..

Web Development mysql php

extjac 0 Newbie Poster

12 Years Ago

Re: PDO MySql insert not working

this is how i do it, based on great feedback from the forum:

DB CONNECTION CLASS:

class db {

/*** Declare instance ***/
private static $instance = NULL;

/**
*
* the constructor is set to private so
* so nobody can create a new instance using new
*
*/
private function __construct() {
  /*** maybe set the db name here later ***/
}

/**
*
* Return DB instance or create intitial connection
*
* @return object (PDO)
*
* @access public
*
*/
    public static function getInstance() 
    {
        if (!self::$instance)
            {
            self::$instance = new PDO("mysql:host=ip_Addred_or_hostname;dbname=your_bd_name", 'your_db_username', 'your_db_password');;
            self::$instance-> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            }
    return self::$instance;
    }

/**
*
* Like the constructor, we make __clone private
* so nobody can clone the instance
*
*/
private function __clone(){
}

} /*** end of class ***/

PAYMENT CLASS

class payment
{

    function __construct()
    {
        $this->table = 'YOUR_TABLE_NAME';
    }


    /**
    * @param string $this->table Table name
    * @param array $data Array with columns and values
    * @return mixed Last inserted ID if insert succeeded, false otherwise
    */
    public function insert($data) 
    {
        $result  = false;
        $columns = array ();
        $values  = array ();

        foreach ($data as $column => $value) 
        {
            $columns[]  = $column;
            $values[]   = ":$column";
        }
        $columns = implode(',', $columns);
        $values = implode(',', $values);

        $query = " INSERT INTO $this->table ($columns) VALUES ($values)";
        $statement = db::getInstance()->prepare($query);

        foreach ($data as $column => $value) 
        {
            $statement->bindValue(":$column", $value );
        }

        if ($statement->execute() ) 
        {
            $result = db::getInstance()->lastInsertId();
        }
    return $result;
    }




    /**
    * @param …

Web Development mysql php

extjac 0 Newbie Poster

12 Years Ago

Re: jQuery + PHP: ajax: post()

thank u sir!

Web Development javascript-jquery php php-codeigniter

extjac 0 Newbie Poster

12 Years Ago

Creating Thumbnails with PHP

Hello, do you guys recomend any CLASS or script to create Thumbnails? what are you using these days?