Search Posts

Category: mysql

Polish characters in database with AngularJS, PHP, mySQL

So i have made an website using AngularJS, PHP, mySQL. I have an registration form where I try to use polish characters. This is my html parts where i set everything to UTF-8 <meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″ /> My HTML form : <div class=”modal fade” id=”registerModal”> <div class=”modal-dialog”> <div class=”modal-content” ng-controller=”registerController”> <div class=”modal-header”><h4 class=”modal-title”>Sign Up</h4></br><button type=”button” class=”close” data-dismiss=”modal”>&times;</button></div> <div class=”modal-body”><form name=”registerForm”> <div class=”row”> <div class=”col-lg-6″> <label style=”float: left;”><b>Firstname:</b></label> <input type=”text” ng-model=”registerData.firstname” class=”form-control”></br> <label style=”float: left;”><b>Lastname:</b></label> […]

Fetching Data from MySQL using AngularJS $http

i know this question has been asked quite often but i can’t seem to find answer that solve my problem. I’m just trying to fetch data unsing AngularJS from a PHP mySQL database (WAMP) I’ve managed to get data with raw PHP/html from it, but i can’t manage to do it with AngularJS.I Follow this tutorial : (first code from each category. Here is customer_mysql.php <?php header(“Access-Control-Allow-Origin: *”); header(“Content-Type: application/json; charset=UTF-8”); try { $bdd […]

employee registration form including file upload [on hold]

I have a problem regarding “employee form registration” in AngularJS. I have done successful to send the values for name, address,phone,email..etc into MySQL by using PHP and AngularJS. But now coming to the point including the FILE type field (img.jpeg)was not inserting to the MySQL (database) I need a brief code for regarding Question: how to send the file upload field using AngualrJS along with all fields?(using PHP, JS, MySQL) Source: AngularJS

alphanumeric auto increment id using angularjs php and mysql

interface I have an interface implemented using angularjs, php and database is mysql and there I have a field call hop reference Ex:- 7G/0001 the 1st part is the frequency and a slash and the frequency should be the selected one from the combo box and the other part should be auto increment in the database for an example the next one could be 8G/0002. How do I implement this using angularjs, php and mysql. […]

Sometimes I get an empty response and sometimes response works perfectly in angularjs

Im working with mysql and php with angular this is the code for the posting data app.controller(‘buscar’, function ($scope, $http) { $scope.postData = function () { var request = $http({ method: “POST”, url: ‘busqueda.php’, data: { cedula:$scope.cedula }, headers: { ‘Content-Type’: ‘application/x-www-form-urlencoded;charset=utf-8’ } }).then(function successCallback(response) { $scope.datos =; console.log($scope.datos); },function(response) { $scope.error= response.statusText; console.log($scope.error); }); } }); and my php is: $sql1 = “(SELECT * FROM `presentadas` LEFT JOIN `desembolsos` ON presentadas.`CLI_IDENTIFICACION` = desembolsos.`IDENTIFICACION` […]

laravel does not recognize ISO8601 formatted date time

Suppose we have a 2015-02-05T14:50:55+01:00 formatted date time that comes from an angularJs client side app. Now I want to save it as DATETIME MySQL in a table. I know that is a iso 8601 formatted date time. because of this I added below code to my model: protected $dateFormat = ‘DATE_ISO8601’; But when I want to update my model with this new field I got this error : A textual day could not be […]

ng-options returning undefined label and value despite valid JSON from MySQL table

OK, trying this a second time, and for some reason I just cannot seem to get my head around ng-options or ng-repeat within a SELECT drop-down. Here’s my first Plunk. Note, however, that instead of users.json, I’m actually pulling from a MySQL table. So I’m not 100% sure what I put into users.json is entirely accurate. But that’s irrelevant, because I want the JSON coming from the DB table directly, not a JSON file I […]

Linq Query Return Duplicate Record From Sql Database

I am trying to join three linq queries into single query and display the records into an angular js application. But the problem is when I enter the account number and click the submit button, it also displays the duplicate record. Here is the Linq Query: public string TranscationDetails(string Account_Number) { var accountNumber = int.Parse(Account_Number);//It could be better to use TryParse using (HalifaxDatabaseEntities context = new HalifaxDatabaseEntities()) { var CombinedQuery = (from x in context.Current_Account_Deposit […]

Next Page »