#how to insert multiple array values into database php | Explore Tumblr posts and blogs

webdevelopmentcompanyindia · 4 years ago

Text

Five Common PHP Problems and Solutions

PHP is a vast subject that needs lots of study to get done. It is a most-used open fount general-purpose scripting language that is particularly satisfied for web development and can be inserted into HTML. Today we are giving answers of top Php related question which will help you to done the process. Here solutions are provided by the top PHP Development Company, AResourcePool.

How to store image in core Php using input type file?

Are you looking for the ways to upload or store an image in core Php using input type file? If yes, so here we are.

Php script is very popular as it is using with a HTML form to let the users to upload files to the different server. At first the files are uploaded into a transitory directory as well as, it moved to a target by a PHP script.

Here are some procedures of uploading a file. So, here you go:

· Open a page which contains a HTML where you can feature an image, text files, and browser button as well as submit button.

· Now, click on the browser button and select the desired file to upload from your computer or laptop.

· You will now see the entire file of the selected path. So, choose where you wanna store it and press submit button.

· The file will send to the directory which is only temporary on the server.

· Php script was particular as the outline handler in the form’s action attribute. Now check is the file exist and then copy to the directory.

· You can make sure your success by using PHP script.

Meanwhile, it is really important to seek permission when writing files for permanent location or for temporary location. Whatever file you are uploading can be the image file or it can be the text file or whatever document you are uploading.

How to create an upload form?

To create an upload form you will need HTM coding because it has certain attribute of post as well as enctype attribute which is set to multipart.

<?php

if(isset($_FILES[‘image’])){

$errors= array();

$file_name = $_FILES['image’]['name’];

$file_size =$_FILES['image’]['size’];

$file_tmp =$_FILES['image’]['tmp_name’];

$file_type=$_FILES['image’]['type’];

$file_ext=strtolower(end(explode(’.’,$_FILES['image’]['name’])));

$extensions= array(“jpeg”,“jpg”,“png”);

if(in_array($file_ext,$extensions)=== false){

$errors[]=“extension not allowed, please choose a JPEG or PNG file.”;

}

if($file_size > 2097152){

$errors[]='File size must be excately 2 MB’;

}

if(empty($errors)==true){

move_uploaded_file($file_tmp,“images/”.$file_name);

echo “Success”;

}else{

print_r($errors);

}

<html>

<body>

</form>

</body>

</html>

How can I test to see if value is 0 or null in PHP?

Php is a vast subject that contains many elements and one of the major elements of Php is to check 0, null or empty and isset status. It has various functions to check whether it is good or not or to test the value of the variables. There are three important functions of Php such as isset(), empty() and is_null(). This factors help to return a Boolean value. Boolean value is the used to determine the value of these functions. The result would be unexpected if it is not used in a right ways. There are two functions which functions opposite isset() and empty(). Well, it is not always true there is certain difference between all. So, here have a look at these functions:

1. isset()From PHP manual – isset():

Isset is used to decide that if a variable is set and is not NULL. If we say in other words then, it is used to determine the return is true only when not null is the variable.

2. empty()From PHP Manual – empty():

Empty is used to decide that if a variable is empty.If we talk in other terms then, it will return true if the variable is empty. It will show false, array(), NULL, “0?, 0, and an unset variable.

3. is_null()From PHP Manual – is_null():

Null is used to find if a variable is Null or not. In other words if we say then the returns true then, only when the variable shows null result. is_null() is opposite of isset(), except for one difference that isset() can be applied to unknown variables, but is_null() only to declared variables.

How to delete row from table using PHP pdo?

You can utilize the assignments table in the example database for the showing. Before going ahead with this instructional exercise, you ought to pursue the PHP MySQL make table instructional exercise to make the errands table and addition test information for rehearsing.

PHP MySQL Delete: Tasks Table:To erase information in a table, you utilize the accompanying advances: Associate with the MySQL database by making another case of the PDO object.

First of all, build a DELETE explanation to erase a column, numerous lines, or all lines in a table. On the off chance that you need to erase all columns in a major table rapidly and all the more proficiently, you utilize the TRUNCATE TABLE proclamation. Execute the DELETE articulation by calling the executive() strategy for the PDO object or the execute() technique for the PDOStatement object.

· PHP MySQL Delete information models

· PHP MySQL: erase a solitary column model

· To erase a solitary column in a table, you utilize the DELETE articulation with a WHERE condition that determines which line to erase.

· The accompanying content erases a column with id 2 in the assignments table.

How it functions?

When we talk about__construct() technique for the DeleteDataDemo class, we interface with the MySQL database by starting a case of the PDO class, and in the __destruct() strategy, we close the database association. The erase() technique acknowledges the id as the contention. In the first place, we call the get ready() technique for the PDO item to set up the DELETE explanation for execution, and after that we pass an exhibit that contains values comparing to the named placeholders in the DELETE proclamation to the execute() strategy for the PDOStatement object.

To erase the undertaking with id 2, we make an example of the DeleteDataDemo class and call the erase() strategy.

PHP MySQL: erase all columns in a table precedents

There are two different ways to erase all columns in a table:

· Issue a DELETE explanation without a WHERE statement.

· Issue a TRUNCATE TABLE explanation.

Getting Data from Multiple Databases:

There can be different issues which can face while fetching data from multiple databases but, issue you will have is consolidating the information. In a solitary database you keep up information honesty by characterizing outside keys. Different tables may have things identified with clients, so they may have a user_id field.

In a solitary database you would characterize a remote key connection between that user_id field and the id field on the client table, which means just existing id esteems from the client table, could be embedded in the othertable::user_id field. You can’t do outside key connections between tables in various databases, so I don’t have the foggiest idea how you’re going to interface the two arrangements of information into a solitary dataset.

Notwithstanding, expect you have a pseudo remote key, as above, however itwon’t be utilized by the databases to look after honesty. At that point need to do some sort of for/for each circle more than one dataset, remove the key which joins it to the next dataset, at that point glance through the second dataset for the coordinating key.

So, there are certain steps which involved in it so, have a look:

· make first association config ($conn1 = mysqli_connect($server1, $username, $password, $dbname)

· make second association config ($conn2 = mysqli_connect($server2, $username, $password, $dbname2);)

· select information with $conn config and store into $result variable (exhibit)

· for each $result, embed it into second database utilizing $conn2

How to display data record in database from vertical to horizontal:

There are many different ways to arrange data in a vertical to the horizontal database in Php. You will get two favourable circumstances and weaknesses to these strategies for social database information association. I completely depend on the requirements of the business as well it also depends on the need for the development.

The traditional way of any data in a table is a horizontal layout. Whatever data is recorded is go in a row and columns format runs horizontally. On the other hand, the second way is vertical. This way is very specific as well as it stores data that only have a column for real data. Here have a look at the example of data record in database from vertical to horizontal.

Table for Horizontal:

First_Name

Last_Name

Dept

Sex

123

Vlad

Kofman

234

Jim

Cramer

Marketing

456

Olimpia

Dukakis

Accounting

Table for Vertical

Key

Value

123

First_Name

Vlad

234

First_Name

Jim

456

First_Name

Olimpia

123

Last_Name

Kofman

234

Last_Name

Cramer

456

Last_Name

Dukakis

123

Dept

234

Dept

Marketing

456

Dept

Accounting

123

Sex

234

Sex

456

Sex

How enable in php long query strings:

Selecting Encrypted Username from DB:

There is very common question always hit the mind of the users that how Selecting Encrypted Username from DB? So, to encrypt the process does the data in the database unreadable from data in word processors. There can be no one decipher of its data when the database is encrypted.

Any database can be encrypted by utilizing the standard access menus. In both, the cases database that you are encrypting cannot be opened.

Follow this step to Encrypted Username from DB:

· Step 1: Select the tool by going to the setting. You will get options like Encrypt/Decrypt Database in the menu options.

· Step 2: You will see the encrypt/decrypt database dialogue from which choose the file which you want to encrypt. Press Okay.

· Step 3: If a user chooses the name which already exists in the files then, access will remove the original file after it concludes the process of encryption is successful. One of the best things that you can do in this situation is to take back up of the original database.

Encrypting with Code:

If you have used runtime version of Access to distribute your application and wants to give all the Php users the capability to encrypt the database you have to enter database course such as ADO. The following code will look like this:

Sub Encrypt(strDBNotEncrypted As String, _

strDBEncrypted As String)

Dim je As Nwe JRO.JetEngine

Je.CompactDatabase SourceConnection:=“Data Source=” _

& strDBNotEncrypted & “;”, _

DestConnection:=“Data Source=” & strDBEncrypted & _

"; Jet OLEDB:Encrypt Database=True"

End Sub

That’s all the folk about Php. If you are looking for such services you can contact Aresourcepool. The company has the best solution for all the above mentioned concept.

#php development company #php development #php development company india

0 notes

skptricks · 8 years ago

Text

PHP MySQL connection using PDO

Today, In this post we will learn how to connect to MySQL using PDO in PHP and just for the information PDO stands for "PHP Data Objects". Here we will see the some useful examples to perform CURD operations in MySQL database using PDO and also it provides you some information about MySQL Prepared Statement. Connections to MySQL database can be established by creating instances of the PDO base class and specify the driver, database name, username, and password.

SYNTAX:

$dbConnection = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);

Connection to MySQL Databse Using PDO

Lets see the simple example to establish the database connection to MySQL using PDO.

OUTPUT: ---------------------- Connected successfully

PHP Insert Data Into MySQL Database Using PDO

Lets see the simple examples to insert data to MySQL database using PDO. Method : 1 Here we are executing the query, while passing an array, which contains the data that should be bound to those placeholders.

OUTPUT: -------------------------- Connected successfully. Record Inserted to table

Method : 2 Lets see the another example to insert the records in database, we are executing the query, by passing the data to corresponding parameters using bindParam() function.

OUTPUT: ------------------------ Connected successfully. Record Inserted to table

Method : 3 Another way to use bindParam() function by providing the data type of corresponding parameters used in database.

<?php $dbhost ="localhost"; // set the hostname $dbname ="skptricksdemo" ; // set the database name $dbuser ="root" ; // set the mysql username $dbpass =""; // set the mysql password try { $dbConnection = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass); $dbConnection->exec("set names utf8"); $dbConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected successfully.<br>"; $stmt = $dbConnection->prepare('INSERT INTO `userdetails`(USERNAME,EMAILID,COUNTRY,AGE) VALUES(:USERNAME,:EMAILID,:COUNTRY,:AGE)'); $username = "Mark000" ; $email = "[email protected]" ; $country = "USA" ; $age = "53" ; $stmt->bindParam(':USERNAME', $username,PDO::PARAM_STR ); $stmt->bindParam(':EMAILID', $email,PDO::PARAM_STR); $stmt->bindParam(':COUNTRY', $country ,PDO::PARAM_STR ); $stmt->bindParam(':AGE', $age, PDO::PARAM_INT); $stmt->execute(); $Count = $stmt->rowCount(); if ($Count > 0) echo "Record Inserted to table" ; } catch (PDOException $e) { echo 'Connection failed: ' . $e->getMessage(); } ?>

OUTPUT: ------------------------- Connected successfully. Record Inserted to table

PHP Update Data Into MySQL Database Using PDO

Lets see the simple example to update the data of existing records in MySQL database using PDO. Before update :

After Update :

OUTPUT: ------------------ Connected successfully. Record Updated to table

PHP Delete Data From MySQL Database Using PDO

Lets see the simple example to delete records from MySQL database using PDO connection. Before Delete :

After Delete :

OUTPUT: ------------------------- Connected successfully. Record deleted to table

PHP Select/Fetech Data From MySQL Using PDO

Database Records :

Method : 1 (Using PDO::FETCH_ASSOC) Retrieving the data from MySQL database using PDO::FETCH_ASSOC Mode.

PDO::FETCH_ASSOC: returns an array indexed by column name as returned in your result set.

OUTPUT: -------------------------- Connected successfully. Total Records Count : 2 . 20 | Rahul | [email protected] | India | 23 22 | Mark | [email protected] | USA | 33 Method : 2 (Using PDO::FETCH_OBJ) Retrieving the data from MySQL database using PDO::FETCH_OBJ Mode. PDO::FETCH_OBJ: returns an anonymous object with property names that correspond to the column names returned in your result set.

Multiple Execution Of Query

The PDO extension is more powerful when executing the same SQL query multiple times. Here in this example we are inserting two rows at time using same query. Similarly you can use for update and delete operation. Also you can get the last inserted record id using lastInsertId() function. Lets see the simple example for more understanding.

<?php $dbhost ="localhost"; // set the hostname $dbname ="skptricksdemo" ; // set the database name $dbuser ="root" ; // set the mysql username $dbpass =""; // set the mysql password try { $dbConnection = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass); $dbConnection->exec("set names utf8"); $dbConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected successfully.<br>"; $stmt = $dbConnection->prepare('INSERT INTO `userdetails`(USERNAME,EMAILID,COUNTRY,AGE) VALUES(:USERNAME,:EMAILID,:COUNTRY,:AGE)'); //first record data... $username = "Mark" ; $email = "[email protected]" ; $country = "USA" ; $age = "33" ; $stmt->bindParam(':USERNAME', $username ); $stmt->bindParam(':EMAILID', $email); $stmt->bindParam(':COUNTRY', $country ); $stmt->bindParam(':AGE', $age); $stmt->execute(); echo "<br> Get the last record id : ".$dbConnection->lastInsertId(); //seconds record data... $username = "Wayplus" ; $email = "[email protected]" ; $country = "US" ; $age = "38" ; $stmt->bindParam(':USERNAME', $username ); $stmt->bindParam(':EMAILID', $email); $stmt->bindParam(':COUNTRY', $country ); $stmt->bindParam(':AGE', $age); $stmt->execute(); echo "<br> Get the last record id : ".$dbConnection->lastInsertId(); $Count = $stmt->rowCount(); if ($Count > 0) echo "<br> Record Inserted to table" ; } catch (PDOException $e) { echo 'Connection failed: ' . $e->getMessage(); } ?>

OUTPUT: ------------------------ Connected successfully. Get the last record id : 24 Get the last record id : 25 Record Inserted to table After running above query :

via Blogger http://ift.tt/2x7KQ0S

#MYSQL #php

2 notes · View notes

nancydsmithus · 6 years ago

Text

Creating A Shopping Cart With HTML5 Web Storage

Matt Zand

2019-08-26T14:30:59+02:002019-08-26T13:06:56+00:00

With the advent of HTML5, many sites were able to replace JavaScript plugin and codes with simple more efficient HTML codes such as audio, video, geolocation, etc. HTML5 tags made the job of developers much easier while enhancing page load time and site performance. In particular, HTML5 web storage was a game changer as they allow users’ browsers to store user data without using a server. So the creation of web storage, allowed front-end developers to accomplish more on their website without knowing or using server-side coding or database.

Online e-commerce websites predominantly use server-side languages such as PHP to store users’ data and pass them from one page to another. Using JavaScript back-end frameworks such as Node.js, we can achieve the same goal. However, in this tutorial, we’ll show you step by step how to build a shopping cart with HTML5 and some minor JavaScript code. Other uses of the techniques in this tutorial would be to store user preferences, the user’s favorite content, wish lists, and user settings like name and password on websites and native mobile apps without using a database.

Many high-traffic websites rely on complex techniques such as server clustering, DNS load balancers, client-side and server-side caching, distributed databases, and microservices to optimize performance and availability. Indeed, the major challenge for dynamic websites is to fetch data from a database and use a server-side language such as PHP to process them. However, remote database storage should be used only for essential website content, such as articles and user credentials. Features such as user preferences can be stored in the user’s browser, similar to cookies. Likewise, when you build a native mobile app, you can use HTML5 web storage in conjunction with a local database to increase the speed of your app. Thus, as front-end developers, we need to explore ways in which we can exploit the power of HTML5 web storage in our applications in the early stages of development.

I have been a part of a team developing a large-scale social website, and we used HTML5 web storage heavily. For instance, when a user logs in, we store the hashed user ID in an HTML5 session and use it to authenticate the user on protected pages. We also use this feature to store all new push notifications — such as new chat messages, website messages, and new feeds — and pass them from one page to another. When a social website gets high traffic, total reliance on the server for load balancing might not work, so you have to identify tasks and data that can be handled by the user’s browser instead of your servers.

Project Background

A shopping cart allows a website’s visitor to view product pages and add items to their basket. The visitor can review all of their items and update their basket (such as to add or remove items). To achieve this, the website needs to store the visitor’s data and pass them from one page to another, until the visitor goes to the checkout page and makes a purchase. Storing data can be done via a server-side language or a client-side one. With a server-side language, the server bears the weight of the data storage, whereas with a client-side language, the visitor’s computer (desktop, tablet or smartphone) stores and processes the data. Each approach has its pros and cons. In this tutorial, we’ll focus on a simple client-side approach, based on HTML5 and JavaScript.

Note: In order to be able to follow this tutorial, basic knowledge of HTML5, CSS and JavaScript is required.

Project Files

Click here to download the project’s source files. You can see a live demo, too.

Overview Of HTML5 Web Storage

HTML5 web storage allows web applications to store values locally in the browser that can survive the browser session, just like cookies. Unlike cookies that need to be sent with every HTTP request, web storage data is never transferred to the server; thus, web storage outperforms cookies in web performance. Furthermore, cookies allow you to store only 4 KB of data per domain, whereas web storage allows at least 5 MB per domain. Web storage works like a simple array, mapping keys to values, and they have two types:

Session storage This stores data in one browser session, where it becomes available until the browser or browser tab is closed. Popup windows opened from the same window can see session storage, and so can iframes inside the same window. However, multiple windows from the same origin (URL) cannot see each other’s session storage.

Local storage This stores data in the web browser with no expiration date. The data is available to all windows with the same origin (domain), even when the browser or browser tabs are reopened or closed.

Both storage types are currently supported in all major web browsers. Keep in mind that you cannot pass storage data from one browser to another, even if both browsers are visiting the same domain.

Build A Basic Shopping Cart

To build our shopping cart, we first create an HTML page with a simple cart to show items, and a simple form to add or edit the basket. Then, we add HTML web storage to it, followed by JavaScript coding. Although we are using HTML5 local storage tags, all steps are identical to those of HTML5 session storage and can be applied to HTML5 session storage tags. Lastly, we’ll go over some jQuery code, as an alternative to JavaScript code, for those interested in using jQuery.

Add HTML5 Local Storage To Shopping Cart

Our HTML page is a basic page, with tags for external JavaScript and CSS referenced in the head.

<!DOCTYPE HTML> <html lang="en-US"> <head> <title>HTML5 Local Storage Project</title> <META charset="UTF-8"> <META name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <META NAME='rating' CONTENT='General' /> <META NAME='expires' CONTENT='never' /> <META NAME='language' CONTENT='English, EN' /> <META name="description" content="shopping cart project with HTML5 and JavaScript"> <META name="keywords" content="HTML5,CSS,JavaScript, html5 session storage, html5 local storage"> <META name="author" content="dcwebmakers.com"> <script src="Storage.js"></script> <link rel="stylesheet" href="StorageStyle.css"> </head>

Below is the HTML content for the page’s body:

<form name=ShoppingList> <div id="main"> <table> <tr> <td><b>Item:</b><input type=text name=name></td> <td><b>Quantity:</b><input type=text name=data></td> </tr> <tr> <td> <input type=button value="Save" onclick="SaveItem()"> <input type=button value="Update" onclick="ModifyItem()"> <input type=button value="Delete" onclick="RemoveItem()"> </td> </tr> </table> </div> <div id="items_table"> <h3>Shopping List</h3> <table id=list></table> <p> <label><input type=button value="Clear" onclick="ClearAll()"> <i>* Delete all items</i></label> </p> </div> </form>

Adding JavaScript To The Shopping Cart

We’ll create and call the JavaScript function doShowAll() in the onload() event to check for browser support and to dynamically create the table that shows the storage name-value pair.

Alternatively, you can use the JavaScript onload event by adding this to the JavaScript code:

window.load=doShowAll();

Or use this for jQuery:

$( window ).load(function() { doShowAll(); });

In the CheckBrowser() function, we would like to check whether the browser supports HTML5 storage. Note that this step might not be required because most modern web browsers support it.

/* =====> Checking browser support. //This step might not be required because most modern browsers do support HTML5. */ //Function below might be redundant. function CheckBrowser() { if ('localStorage' in window && window['localStorage'] !== null) { // We can use localStorage object to store data. return true; } else { return false; } }

Inside the doShowAll(), if the CheckBrowser() function evaluates first for browser support, then it will dynamically create the table for the shopping list during page load. You can iterate the keys (property names) of the key-value pairs stored in local storage inside a JavaScript loop, as shown below. Based on the storage value, this method populates the table dynamically to show the key-value pair stored in local storage.

// Dynamically populate the table with shopping list items. //Step below can be done via PHP and AJAX, too. function doShowAll() { if (CheckBrowser()) { var key = ""; var list = "<tr><th>Item</th><th>Value</th></tr>\n"; var i = 0; //For a more advanced feature, you can set a cap on max items in the cart. for (i = 0; i <= localStorage.length-1; i++) { key = localStorage.key(i); list += "<tr><td>" + key + "</td>\n<td>" + localStorage.getItem(key) + "</td></tr>\n"; } //If no item exists in the cart. if (list == "<tr><th>Item</th><th>Value</th></tr>\n") { list += "<tr><td><i>empty</i></td>\n<td><i>empty</i></td></tr>\n"; } //Bind the data to HTML table. //You can use jQuery, too. document.getElementById('list').innerHTML = list; } else { alert('Cannot save shopping list as your browser does not support HTML 5'); } }

Note: Either you or your framework will have a preferred method of creating new DOM nodes. To keep things clear and focused, our example uses .innerHTML even though we’d normally avoid that in production code.

Tip: If you’d like to use jQuery to bind data, you can just replace document.getElementById('list').innerHTML = list; with $(‘#list’).html()=list;.

Run And Test The Shopping Cart

In the previous two sections, we added code to the HTML head, and we added HTML to the shopping cart form and basket. We also created a JavaScript function to check for browser support and to populate the basket with the items in the cart. In populating the basket items, the JavaScript fetches values from HTML web storage, instead of a database. In this part, we’ll show you how the data are inserted into the HTML5 storage engine. That is, we’ll use HTML5 local storage in conjunction with JavaScript to insert new items to the shopping cart, as well as edit an existing item in the cart.

Note: I’ve added tips sections below to show jQuery code, as an alternative to the JavaScript ones.

We’ll create a separate HTML div element to capture user input and submission. We’ll attach the corresponding JavaScript function in the onClick event for the buttons.

You can set properties on the localStorage object similar to a normal JavaScript object. Here is an example of how we can set the local storage property myProperty to the value myValue:

localStorage.myProperty="myValue";

You can delete local storage property like this:

delete localStorage.myProperty;

Alternately, you can use the following methods to access local storage:

localStorage.setItem('propertyName','value'); localStorage.getItem('propertyName'); localStorage.removeItem('propertyName');

To save the key-value pair, get the value of the corresponding JavaScript object and call the setItem method:

function SaveItem() { var name = document.forms.ShoppingList.name.value; var data = document.forms.ShoppingList.data.value; localStorage.setItem(name, data); doShowAll(); }

Below is the jQuery alternative for the SaveItem function. First, add an ID to the form inputs:

<td><b>Item:</b><input type=text name="name" id="name"></td> <td><b>Quantity:</b><input type=text name="data" id="data"></td>

Then, select the form inputs by ID, and get their values. As you can see below, it is much simpler than JavaScript:

function SaveItem() { var name = $("#name").val(); var data = $("#data").val(); localStorage.setItem(name, data); doShowAll(); }

To update an item in the shopping cart, you have to first check whether that item’s key already exists in local storage, and then update its value, as shown below:

//Change an existing key-value in HTML5 storage. function ModifyItem() { var name1 = document.forms.ShoppingList.name.value; var data1 = document.forms.ShoppingList.data.value; //check if name1 is already exists //Check if key exists. if (localStorage.getItem(name1) !=null) { //update localStorage.setItem(name1,data1); document.forms.ShoppingList.data.value = localStorage.getItem(name1); } doShowAll(); }

Below shows the jQuery alternative.

function ModifyItem() { var name1 = $("#name").val(); var data1 = $("#data").val(); //Check if name already exists. //Check if key exists. if (localStorage.getItem(name1) !=null) { //update localStorage.setItem(name1,data1); var new_info=localStorage.getItem(name1); $("#data").val(new_info); } doShowAll(); }

We will use the removeItem method to delete an item from storage.

function RemoveItem() { var name=document.forms.ShoppingList.name.value; document.forms.ShoppingList.data.value=localStorage.removeItem(name); doShowAll(); }

Tip: Similar to the previous two functions, you can use jQuery selectors in the RemoveItem function.

There is another method for local storage that allows you to clear the entire local storage. We call the ClearAll() function in the onClick event of the “Clear” button:

We use the clear method to clear the local storage, as shown below:

function ClearAll() { localStorage.clear(); doShowAll(); }

Session Storage

The sessionStorage object works in the same way as localStorage. You can replace the above example with the sessionStorage object to expire the data after one session. Once the user closes the browser window, the storage will be cleared. In short, the APIs for localStorage and sessionStorage are identical, allowing you to use the following methods:

setItem(key, value)

getItem(key)

removeItem(key)

clear()

key(index)

length

Shopping Carts With Arrays And Objects

Because HTML5 web storage only supports single name-value storage, you have to use JSON or another method to convert your arrays or objects into a single string. You might need an array or object if you have a category and subcategories of items, or if you have a shopping cart with multiple data, like customer info, item info, etc. You just need to implode your array or object items into a string to store them in web storage, and then explode (or split) them back to an array to show them on another page. Let’s go through a basic example of a shopping cart that has three sets of info: customer info, item info and custom mailing address. First, we use JSON.stringify to convert the object into a string. Then, we use JSON.parse to reverse it back.

Hint: Keep in mind that the key-name should be unique for each domain.

//Customer info //You can use array in addition to object. var obj1 = { firstname: "John", lastname: "thomson" }; var cust = JSON.stringify(obj1); //Mailing info var obj2 = { state: "VA", city: "Arlington" }; var mail = JSON.stringify(obj2); //Item info var obj3 = { item: "milk", quantity: 2 }; var basket = JSON.stringify(obj3); //Next, push three strings into key-value of HTML5 storage. //Use JSON parse function below to convert string back into object or array. var New_cust=JSON.parse(cust);

Summary

In this tutorial, we have learned how to build a shopping cart step by step using HTML5 web storage and JavaScript. We’ve seen how to use jQuery as an alternative to JavaScript. We’ve also discussed JSON functions like stringify and parse to handle arrays and objects in a shopping cart. You can build on this tutorial by adding more features, like adding product categories and subcategories while storing data in a JavaScript multi-dimensional array. Moreover, you can replace the whole JavaScript code with jQuery.

We’ve seen what other things developers can accomplish with HTML5 web storage and what other features they can add to their websites. For example, you can use this tutorial to store user preferences, favorited content, wish lists, and user settings like names and passwords on websites and native mobile apps, without using a database.

To conclude, here are a few issues to consider when implementing HTML5 web storage:

Some users might have privacy settings that prevent the browser from storing data.

Some users might use their browser in incognito mode.

Be aware of a few security issues, like DNS spoofing attacks, cross-directory attacks, and sensitive data compromise.

Related Reading

“Browser Storage Limits And Eviction Criteria,” MDN web docs, Mozilla

“Web Storage,” HTML Living Standard,

“This Week In HTML 5,” The WHATWG Blog

(dm, il)

0 notes

siva3155 · 6 years ago

Text

300+ TOP Zend Framework Interview Questions and Answers

Zend Framework Interview Questions for freshers experienced :-

1. Which version of PHP does Zend Framework require? Zend Framework requires PHP 5.2.4 and up. Some Zend Framework components may work with earlier versions of PHP, but these components are tested and supported only on 5.2.4 and up. 2. Does Zend Framework support PHP 4? No. Zend Framework was built to use all of the sophisticated object oriented features of PHP 5 and take advantage of significant performance and security enhancements. Another consideration was support of the platform ZF would be running on. The PHP community officially discontinued support for PHP 4 as of 2008-01-01, and no critical security updates will be published for PHP 4 after 2008-08-08. These factors, among others, convinced us that PHP 5 was the best platform for Zend Framework and applications built on ZF. 3. Where is the model in ZF's MVC implementation? The model component can vary dramatically in responsibilities and data store from one MVC application to the next. The ZF community has not defined a model interface, class, or other formalism simply because we wanted to avoid introducing limitations without significant added value. 4. Is ZF a component library or a framework? Simple answer: both. Zend Framework provides all the components required for most web applications in a single distribution. But Zend Framework components are also loosely coupled, making it easy to use just a few components in a web application- even alongside other frameworks! Using this use-at-will architecture, we are implementing features commonly found in more monolithic frameworks. In fact, we are currently working on a tooling component for the 1.8 release that will make it simpler to build applications using ZF components, yet will not sacrifice the use-at-will nature of existing ZF components. It's a testament to the use-at-will architecture of Zend Framework that the tooling component itself can be used standalone. 5. Where's the model? Unlike the view and the controller components, the model component can vary dramatically in responsibilities and data storage from one MVC application to the next. It should represent what your application does in the abstract. The Zend Framework community has not defined a model interface, class, or other formalism because we haven't identified enough added value to justify limitations on what constitutes a model. 6. I want to use a SQL function or perform calculations in a statement I'm generating with Zend_Db_Select. How can I do this? Actually, by default, if your expression includes parentheses, Zend_Db_Select will cast the statement appopriately. However, if it does not, or you are having problems, you can useZend_Db_Expr to explicitly create the expression: * Build the SQL: * SELECT p."product_id", p.cost * 1.08 AS cost_plus_tax * FROM "products" AS p */ $select = $db->select() ->from(array('p' => 'products'), array( 'product_id', 'cost_plus_tax' => new Zend_Db_Expr('p.cost * 1.08'), )); 7. Is ZF a component library or a framework? ZF is both. Zend Framework provides all the components required for most web applications in a single distribution. But Zend Framework components are also loosely coupled, making it easy to use just a few components in a web application- even alongside other frameworks! Using this use-at-will architecture, we are implementing features commonly found in more monolithic frameworks. In fact, we are currently working on a tooling component for the 1.8 release that will make it simpler to build applications using ZF components, yet will not sacrifice the use-at-will nature of existing ZF components. It’s a testament to the use-at-will architecture of Zend Framework that the tooling component itself can be used standalone. 8. What is autoloader? Autoloader is function that load all the object on start up. 9. What is use of Zend front controller? Routing and dispatching is managed in the front controller. It collects all the request from the server and handles it. 10. What is the use of Bootstrap? Apart from index if we want to do any extra configuration regarding database and other things that is done within bootstrap. 11. Zend auth? It is used to authenticate user, for example like admin, general etc. 12. Zend Acl? Based on the zend authentication it allows the user to access certain actions. 13. How do u set Module name, Controller name, and Action name in Zend framework? a) $request->setModuleName(‘front’); b) $request->setControllerName(‘address’); c) $request->setActionName(‘addresslist’); 14. Configuration in Zend Framework, application.ini file? Configuration can be done in application.ini file in Zend framework. This file in the path application/configs/application.ini. 15. Checking whether form posted or not in Zend framework? $request = $this->getRequest(); $_GET = $request->getParams(); $_POST = $request->getPost(); 16. Does Zend Framework support PHP 4? No. Zend Framework was built to use all of the sophisticated object oriented features of PHP 5 and take advantage of significant performance and security enhancements. 17. Fetch last inserted id, fetch all record and fetch a single record. $this->_db->lastInsertId(); $this->_db->fetchAll($sql); $this->_db->fetchRow($sql); 18. Difference between Zend_Registry and Zend_Session? The basic difference between these objects is the ‘scope’ in which they are valid: a) Zend_Registry : request scope b) Zend_Session : session scope Zend_Registry is used to store objects/values for the current request. In short, anything that you commit to Registry in index.php can be accessed from other controllers/actions (because EVERY request is first routed to the index.php bootstrapper via the .htaccess file). Config parameters and db parameters are generally prepped for global use using the Zend_Registry object. Zend_Session actually uses PHP sessions. Data stored using Zend_Session can be accessed in different/all pages. So, if you want to create a variable named ‘UserRole’ in the /auth/login script and want it to be accessible in /auth/redirect, you would use Zend_Session. 19. When do we need to disable layout? At the time of calling AJAX to fetch we need to disable layout. $this->_helper->layout()->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); 20. Filters in Zend Framework with Examples? The Zend_Filter component provides a set of commonly needed data filters. It also provides a simple filter chaining mechanism by which multiple filters may be applied to a single datum in a user-defined order. Example: // Add an email element $this->addElement(‘text’, ‘email’, array( ‘label’ => ‘Your email address:’, ‘required’ => true, ‘filters’ => array(‘StringTrim’), ‘validators’ => array( ‘EmailAddress’, ) )); Other Filters: Alnum – Zend_Filter_Alnum is a filter which returns only alphabetic characters and digits. All other characters are supressed. Alpha – Zend_Filter_Alpha is a filter which returns the string $value, removing all but alphabetic characters. This filter includes an option to also allow white space characters. 21. Name some important component in zend framework? Uses of Zend_Controller Gives the request & reponse methods by using its sub-classes. $request = new Zend_Controller_Request_Http() $response = new Zend_Controller_Response_Http() Uses of Zend_Date Date related processing can be done using this component. Uses of Zend_File_Transfer it provides extensive support for file uploads and downloads. Uses of Zend_Db It is used to doing database related purpose in our appication. Uses of Zend_Paginator Doing the pagination in our application. Uses of Zend_Auth It is used to authenticate a user. $auth = Zend_Auth::getInstance(); $results = $auth->authenticate($adapter); if ($results->isValid()){ /* user successfully authenticate into login process */ } Zend_Session_Namespace This is a simple proxy class to use API into the Zend_Session managed $_SESSION Superglobal. 22. Where is the model in ZF’s MVC implementation? The model component can vary dramatically in responsibilities and data store from one MVC application to the next. 23. How to call two different views from same action? Example1: Public function indexAction() { If(condition) $this->render(‘yourview.phtml’); Else Index.phtml; Example2: Public function indexAction() { } Now in your index.phtml you can have this statement to call other view $this->action(‘action name’,’controller name’,’module name’,array(‘parameter name’=>’parameter value’)); 24. Can we call a model in view? Yes, you can call a model in view. Simple create the object and call the method. 25. How can I customize the appearance of forms generated by Zend_Form? You're probably looking for decorators. All forms and form elements in Zend_Form use decorators to render their output. 26. Why can't Zend_Form render my File element without errors? The file element needs a special file decorator, which is added by default. When you set your own decorators for file elements, you delete the default decorators. For example: $element->setDecorators(array( array('ViewHelper'), array('Errors') )); You should use a File decorator instead of the ViewHelper for the file element, like so: $element->setDecorators(array( array('File'), array('Errors') )); 27. How can I detect if an optional file has been uploaded? The receive() method will return true for file elements that are not required. The reason is that you said "the file can be omitted, and that's ok for me". The receive() method will return false only in the event of a failure. Still there are several ways to detect if a file has been uploaded or not: Use isUploaded which returns a boolean Use getFileName which returns null in this case (note that you must use the latest release for this behaviour) Use getFileInfo which will have an empty 'file' key and the flag 'isUploaded' set to false 28. Custom function to Fetch last Insert ID in Zend Framework public function insertData($tableName,$colName) { $this->_name = $tableName; $sql = "INSERT INTO $tableName SET $colName"; $this->_db = $this->getAdapter(); $this->_db->query($sql); return $this->_db->lastInsertId(); } 29. When do we need to disable layout in Zend Framework? In Zend Framework, at the time of calling AJAX to fetch data, we need to disable layout using following steps: $this->_helper->layout()->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); 30. What are the features of Zend framework? Zend framework features are: Pure object oriented web application framework. Advanced MVC implementation. Supports multi databases Simple cloud API. Session management. Data encryption. Flexible URI Routing. Zend Framework Questions and Answers Pdf Download Read the full article

0 notes

xenleaksinc · 6 years ago

Text

XenForo 2.0.12 - Upgrade

XenForo 2.0.12 is now available for all licensed customers to download. We recommend that all customers running previous versions of XenForo 2.0 upgrade to this release to benefit from increased stability. This version makes a number of changes to improve compatibility with PHP 7.3.0. However, at this time, we do not recommend using PHP 7.3.0 in production due to a bug that can cause code to execute incorrectly, potentially leading to data loss. We believe this bug will be resolved in PHP 7.3.1 when it's released. Download XenForo 2.0.12 Some of the changes in XF 2.0.12 include: Improve PHP 7.3 compatibility. If available and different from the server version, grab a more detailed version for the Server environment report. If the $_SERVER['SERVER_SOFTWARE'] value isn't available or valid then just don't display that entry in the report, because it's mostly not essential. Adds some additional phrases for the "Server environment report" Fix an issue which affects building add-on releases on Windows where local paths included a leading slash. Incrementally update the job state of the Sitemap job so that a fatal error shouldn't disrupt the process and introduce corrupted/duplicate items. Adjust error message given when attempting to edit a user's permissions for a content type without a valid user_id. Standardize the locale information used by PHP. Use a different approach to loading icons on the add-ons list in the Admin CP. To avoid issues with multiple database connections, the icon image data is instead converted to a data URI. User upgrades should not check canPurchase() before processing a payment that has been received, as this method is really only for limiting the UI/purchase setup. Add some additional trusted IP ranges for Google. Ensure 'nullable' entity property is reflected in generated code Ensure node navigation entries use their assigned title Ignore custom field errors during admin edit and include custom field title with errors Convert warning notes field to structured text Correctly apply admin user message leave options Prevent new messages being duplicated in Firefox Ensure multi quote quotes are inserted into the correct editor Hide 'Start a new conversation' link if visitor doesn't have permission to start conversations. Allow permanent redirects to be stickied and unstickied. Remove extra save call when ignoring member Remove UTC check from server environment report and link PHP version to phpinfo page Prevent loading of Setup.php if addon.json requirements aren't met Make xf-dev:entity-class-properties CLI command correctly handle subdirectories Return 'complete' response from UserGroupPromotion job if no active promotions are found. Ensure 'From name' and 'From email' fields are applied when batch emailing users Hide editor draft menu from guests Ensure cron entries run at zero valued time units if multiple time values are selected. Check for missing hash in IPSForums3x authentication handler. Add missing hint parameter to discouraged checkbox on user edit page Remove invalid relation from SpamTriggerLog entity Use content type phrase when rebuilding the search index Fix incorrect URL on conversation message likes list Fix broken 'Delay duration' option for floating notices Allow invalid users to be unfollowed Re-add explain text in the user_edit form to clarify non-valid user states behaviour. Include table name in message for any exception occurring in SchemaManager methods. Implement custom stack trace builder to mask passwords in method arguments Add deleted item styling to news feed items When restoring spam cleaned threads, ensure threads which were originally moved are restored back to the correct forum. Return an error phrase upon invalid callback validation when performing spam clean actions. Note that the method name switches to ucfirst(\XF\Util\Php::camelCase($action)) in XF 2.1 but remains as ucfirst($action) in XF 2.0. When handling a Stripe webhook that is missing required metadata, when attempting to find a previous related log, ensure said log actually contains a purchase_request_key. Improve BB code parsing of incomplete tags within plain-child tags. Migrate user field criteria during upgrade from XF 1.x to 2.x By default, do not allow cookies to be retrieved as arrays to prevent unexpected behavior. (Array support can now be opted into explicitly.) Prevent an error when trying to delete a payment profile when there is an invalid purchasable definition. Track when a preview is pending to prevent multiple simultaneous preview loads. Prevent a PHP notice when deleting a poll for a thread started by a guest Include breadcrumb in edit history view and compare templates. Pass unused $ellipsis variable into wholeWordTrim. Prevent long select options from causing overflow on iOS. Enable the HTML to BB code simplification process to handle additional situations Resolve some situations where the new messages indications while composing a reply wouldn't take you to the expected location. Validate advertisement html before saving. Prevent tel/sms links being converted to bbcode Remove the insert icode option when extended text formatting is disabled. Allow end user modification to the "allow this BB code in signatures" option on add-on-defined custom BB codes. Call the canPurchase method instead of can_purchase in UserUpgrade::getFilteredUserUpgradesForList. Correctly combine multiple custom field-related limits to the user and thread searchers. Correctly apply the "not in secondary groups" user search condition (users cannot be in any of the listed groups). When building a release and testing a JSON, only consider an error if decoding the build.json does not return an array. When submitting spammers to StopForumSpam, convert binary IP address to readable string. When saving style templates through the admin UI, force version/last_edit_date to be updated like XF 1.x When merging threads, always redirect to the target thread. Fix currency code for Belarusian Ruble (BYR => BYN) No longer cache the preview container object in the PreviewClick handler. If there are multiple handlers per page, the cached container becomes incorrect if using different handlers. When form filling, if the control is a textarea with a textarea-handler, trigger its update method to ensure the textarea is resized appropriately. Prevent an array-to-string conversion when throwing a bulkInsert exception if a missing column is detected. Ensure that the user following cache cannot include your own user ID. Add missing mod_log.thread_poll_reset phrase. Attempt to exclude dot files/directories from our vendor dependencies. Number boxes are too wide and cause units to overflow their container, fixed with max-width. Add "Please do not reply to this message" text to outgoing conversation emails. Reassign user group changes when merging users Ensure PasswordChange service errors on any UserAuth error. Fetch more threads for new threads widget Ensure exceptions in sub-processes stop execution, and always exit with non-zero error code on error. Make Disabler system compatible with select options. Ensure FieldAdder handles Disabler elements correctly Ensure prefix of destination thread is shown in moved post alert. Trigger change event on select when prefix selected Remove the "mixed" stuff from CodeMirror's PHP mode so that the opening tag is no longer required. Update broken link to Apple support in cookie help page text (and in XF 1.5). Adjust top border radii of blocks within overlays. Allow non-user selectable styles to be used for the email style. Also, add several email-related style properties to allow email colors to be overridden more directly, without creating a new style. Implement a "notice watcher" system for bottom fixed notices. This calculates the total visible notice height in the bottom fix location and adds a footer margin to the same value so that no content can be covered by the notice(s). Adjust how we parse search query modifiers to be more strict. (- and + require whitespace before and none after, | requires whitespace on both sides. Don't parse doubled up modifiers.) Adjust trophies phrase capitalization Include no_date_limit in the rel=canonical link for forums when needed Attempt to reduce cases where conversation reply_count values could potentially get out of sync. Allow the reply count and other parts to be rebuilt via the conversation rebuild tool. By default, reject email addresses as invalid if there are no dots in the domain part. Add a bit of left padding on contentRow-suffix elements. Include the forum a thread is in in the RSS feeds (only for global feeds) Fix add-on development data not being removed as expected when the last entry of a type has been removed. (The metadata JSON file must still exist.) Relax URL validation a tiny bit, notably don't block adjacent path separators in the path section. Ensure phrase is escaped in HTML attribute. Ensure usage of phrase within HTML attribute is escaped. In the AbstractSearcher ensure that the day end value is converted properly to the end of the day. Never allow the XF add-on to appear in add-on lists. Handle avatar deletes via the spam cleaner for gravatars too. Make add-on action finalization more robust when uninstalling legacy add-ons. When importing dev output, ignore any invalid columns. Add some block border radius to the member header block so that it fits within its parent block. Ensure permissions are rebuilt on add-on active change. Update child navigation entries directly when the parent ID changes to ensure dev output is written correctly. Use the correct maxlength value for the public navigation structure. Additionally, bump AdminNavigation ID lengths up to 50 from 25. Add support for partial indexes to schema manager conflict resolution system Fix multiple issues that make it hard to use XF\Import\Data\AbstractEntityData Consistently use code paths which result in the canView method of the report entity (rather than the handler) being used. The following public templates have had changes: account_upgrades core_contentrow.less core_input.less core_overlay.less editor_base.less edit_history_compare edit_history_view forum_view PAGE_CONTAINER quick_reply_macros thread_save_draft warning_info Where necessary, the merge system within the "outdated templates" page should be used to integrate these changes. As always, new releases of XenForo are free to download for all customers with active licenses, who may now grab the new version from the customer area. Note: add-ons, customizations and styles made for XenForo 1.x are not compatible with XenForo 2.x. If your site relies upon these for essential functionality, ensure that a XenForo 2 version exists before you start to upgrade. We strongly recommend you make a backup before attempting an upgrade. Current Requirements Please note that XenForo 2.0.x has higher system requirements than XenForo 1.x. The forthcoming XenForo 2.1.x release will have higher system requirements again (PHP 5.6). The following are minimum requirements: PHP 5.4 or newer (PHP 7.2 recommended) MySQL 5.5 and newer (Also compatible with MariaDB/Percona etc.) All of the official add-ons require XenForo 2.0. Enhanced Search requires at least Elasticsearch 2.0. Installation and Upgrade Instructions for XenForo 2.0 Full details of how to install and upgrade XenForo can be found in the XenForo 2 Manual. Note that when upgrading from XenForo 1.x, all add-ons will be disabled and style customizations will not be maintained. New versions of add-ons will need to be installed and customizations will need to be redone. We strongly recommended that you make a backup before attempting an upgrade. Once upgraded, you will not be able to downgrade without restoring from a backup.

xenforo_2.0.12_upgrade.zip

source https://xenforoleaks.com/topic/308-xenforo-2012-upgrade/

0 notes

programmingbiters-blog · 7 years ago

Photo

New Post has been published on https://programmingbiters.com/codeigniter-restful-web-services-codexworld/

CodeIgniter RESTful Web Services - CodexWorld

youtube

Representational state transfer (REST) or RESTful web services provide a way to exchange data between applications or systems on the Internet. RESTful web service also refers as RESTful API, uses HTTP request to GET, PUT, POST and DELETE data across platforms. In present days, RESTful API is an essential component of the web application.

When the CodeIgniter application requires communicating with another application, RESTful API is needed to integrate into CodeIgniter. Using RESTful API in CodeIgniter, you can exchange data between different applications or platform. This tutorial shows RESTful server implementation for CodeIgniter and you will learn how to create RESTful web services in CodeIgniter.

If you are beginners to CodeIgniter, first see CodeIgniter from Scratch tutorial to setup and configure CodeIgniter application.

To demonstrate CodeIgniter REST API, we will implement CRUD operations in CodeIgniter web service. The following tasks will be performed to create a simple REST API in CodeIgniter.

Setup RESTful library for CodeIgniter.

Create API method to fetch the user information via GET request.

Create API methods to add, edit, and delete user information via POST, PUT, and DELETE request.

Interact with the CodeIgniter Rest API using PHP cURL.

Test HTTP calls with Google Chrome Postman extension.

Before you get started, take a look the files structure of CodeIgniter REST API.

Create Database Tables

To store user’s information, a table needs to be created in the database. The following SQL creates a users table with some basic fields in MySQL database.

CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `last_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `created` datetime NOT NULL, `modified` datetime NOT NULL, `status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

The following SQL creates a keys table to store REST API key for authentication.

CREATE TABLE `keys` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `key` varchar(40) NOT NULL, `level` int(2) NOT NULL, `ignore_limits` tinyint(1) NOT NULL DEFAULT '0', `is_private_key` tinyint(1) NOT NULL DEFAULT '0', `ip_addresses` text, `date_created` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Now insert an API key in keys table, which will be used on API call.

INSERT INTO `keys` (`id`, `user_id`, `key`, `level`, `ignore_limits`, `is_private_key`, `ip_addresses`, `date_created`) VALUES (1, 0, 'CODEX@123', 0, 0, 0, NULL, '2017-10-12 13:34:33');

CodeIgniter REST Controller Setup

We will use CodeIgniter REST_Controller to build RESTful web services in CodeIgniter. Follow the below steps to setup REST Controller Library in your CodeIgniter application.

Download REST config file and place in the application/config/ directory. Open the application/config/rest.php file and setup the following configuration.

Download REST_Controller file and place in the application/libraries/ directory.

Download Format class file and place in the application/libraries/ directory.

Download Language file and place in the application/language/english/ directory.

Note that: All the required library files are included in our example CodeIgniter application, so, you don’t need to download these files separately. Download our source code to get sample CodeIgniter RESTful Web service application.

Create Model

Open the application/models/ directory and create User.php file and add the following code to handle the database related works. The User model has the following methods to fetch, insert, update, and delete user data in the database.

__construct() – Load the database library.

getRows() – Fetch the user data from the users table and returns single row or multiple rows.

insert() – Insert user data in the users table.

user_put() – Update user data in the users table based on the given ID.

user_delete() – Delete user from the users table based on the given ID.

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

class

User extends CI_Model

public function

__construct() parent::__construct(); //load database library $this->load->database();

/* * Fetch user data */ function getRows($id = "") if(!empty($id)) $query = $this->db->get_where('users', array('id' => $id)); return $query->row_array(); else $query = $this->db->get('users'); return $query->result_array(); /* * Insert user data */ public function insert($data = array()) if(!array_key_exists('created', $data)) $data['created'] = date("Y-m-d H:i:s"); if(!array_key_exists('modified', $data)) $data['modified'] = date("Y-m-d H:i:s"); $insert = $this->db->insert('users', $data); if($insert) return $this->db->insert_id(); else return false; /* * Update user data */ public function update($data, $id) if(!empty($data) && !empty($id)) if(!array_key_exists('modified', $data)) $data['modified'] = date("Y-m-d H:i:s"); $update = $this->db->update('users', $data, array('id'=>$id)); return $update?true:false; else return false; /* * Delete user data */ public function delete($id) $delete = $this->db->delete('users',array('id'=>$id)); return $delete?true:false;

Create API Controller

It’s always a good idea to group all API controllers in a separate folder for better usability. So, create an api/ folder in application/controllers/ directory to place the controller which will be used for API call. Open the application/controllers/api/ directory and create Example.php file. At first, include the REST Controller library and add the following code. The Example API controller has the following methods to handle the GET, POST, PUT, and DELETE request.

__construct() – Load the User model.

user_get() – Return the user data from database. If the ID parameter doesn’t exist, it returns all the rows otherwise single row will be returned.

user_post() – Add user data to the database.

user_put() – Update the user data in the database based on the ID.

user_delete() – Delete the user from the database based on the ID.

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');//include Rest Controller library require APPPATH . '/libraries/REST_Controller.php';

class

Example extends REST_Controller

public function

__construct() parent::__construct(); //load user model $this->load->model('user'); public function user_get($id = 0) //returns all rows if the id parameter doesn't exist, //otherwise single row will be returned $users = $this->user->getRows($id); //check if the user data exists if(!empty($users)) //set the response and exit $this->response($users, REST_Controller::HTTP_OK); else //set the response and exit $this->response([ 'status' => FALSE, 'message' => 'No user were found.' ], REST_Controller::HTTP_NOT_FOUND); public function user_post() $userData = array(); $userData['first_name'] = $this->post('first_name'); $userData['last_name'] = $this->post('last_name'); $userData['email'] = $this->post('email'); $userData['phone'] = $this->post('phone'); if(!empty($userData['first_name']) && !empty($userData['last_name']) && !empty($userData['email']) && !empty($userData['phone'])) //insert user data $insert = $this->user->insert($userData); //check if the user data inserted if($insert) //set the response and exit $this->response([ 'status' => TRUE, 'message' => 'User has been added successfully.' ], REST_Controller::HTTP_OK); else //set the response and exit $this->response("Some problems occurred, please try again.", REST_Controller::HTTP_BAD_REQUEST); else //set the response and exit $this->response("Provide complete user information to create.", REST_Controller::HTTP_BAD_REQUEST); public function user_put() $userData = array(); $id = $this->put('id'); $userData['first_name'] = $this->put('first_name'); $userData['last_name'] = $this->put('last_name'); $userData['email'] = $this->put('email'); $userData['phone'] = $this->put('phone'); if(!empty($id) && !empty($userData['first_name']) && !empty($userData['last_name']) && !empty($userData['email']) && !empty($userData['phone'])) //update user data $update = $this->user->update($userData, $id); //check if the user data updated if($update) //set the response and exit $this->response([ 'status' => TRUE, 'message' => 'User has been updated successfully.' ], REST_Controller::HTTP_OK); else //set the response and exit $this->response("Some problems occurred, please try again.", REST_Controller::HTTP_BAD_REQUEST); else //set the response and exit $this->response("Provide complete user information to update.", REST_Controller::HTTP_BAD_REQUEST); public function user_delete($id) //check whether post id is not empty if($id) //delete post $delete = $this->user->delete($id); if($delete) //set the response and exit $this->response([ 'status' => TRUE, 'message' => 'User has been removed successfully.' ], REST_Controller::HTTP_OK); else //set the response and exit $this->response("Some problems occurred, please try again.", REST_Controller::HTTP_BAD_REQUEST); else //set the response and exit $this->response([ 'status' => FALSE, 'message' => 'No user were found.' ], REST_Controller::HTTP_NOT_FOUND); ?>

Interacting with CodeIgniter RESTful Web Services

Now it’s time to interact with the CodeIgniter RESTful Web Services. The cURL is the most flexible and easiest way to interact with a REST API. In the following example code, we will show you how to send GET, POST, PUT and DELETE request to CodeIgniter REST API using PHP cURL. Also, HTTP Basic authentication and API key will be used to connect with RESTful API.

Retrieve User Data via REST API The following code performs a GET request to fetch the user data via RESTful Web Services (Example API).

//API URL $url = 'http://localhost/codeigniter/api/example/user/';//API key $apiKey = 'CODEX@123';//Auth credentials $username = "admin"; $password = "1234";//create a new cURL resource $ch = curl_init($url);curl_setopt($ch, CURLOPT_TIMEOUT, 30); curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_ANY); curl_setopt($ch, CURLOPT_HTTPHEADER, array("X-API-KEY: " . $apiKey)); curl_setopt($ch, CURLOPT_USERPWD, "$username:$password");$result = curl_exec($ch);//close cURL resource curl_close($ch);

Insert User Data via REST API The following code performs a POST request to insert user data via RESTful Web Services (Example API).

//API URL $url = 'http://localhost/codeigniter/api/example/user/';//API key $apiKey = 'CODEX@123';//Auth credentials $username = "admin"; $password = "1234";//user information $userData = array( 'first_name' => 'John', 'last_name' => 'Doe', 'email' => '[email protected]', 'phone' => '123-456-7890' );//create a new cURL resource $ch = curl_init($url);curl_setopt($ch, CURLOPT_TIMEOUT, 30); curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_ANY); curl_setopt($ch, CURLOPT_HTTPHEADER, array("X-API-KEY: " . $apiKey)); curl_setopt($ch, CURLOPT_USERPWD, "$username:$password"); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $userData);$result = curl_exec($ch);//close cURL resource curl_close($ch);

Update User Data via REST API The following code performs a PUT request to update user data via RESTful Web Services (Example API).

//API URL $url = 'http://localhost/codeigniter/api/example/user/';//API key $apiKey = 'CODEX@123';//Auth credentials $username = "admin"; $password = "1234";//user information $userData = array( 'id' => 2, 'first_name' => 'John2', 'last_name' => 'Doe2', 'email' => '[email protected]', 'phone' => '098-765-4321' );//create a new cURL resource $ch = curl_init($url);curl_setopt($ch, CURLOPT_TIMEOUT, 30); curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_ANY); curl_setopt($ch, CURLOPT_HTTPHEADER, array('X-API-KEY: '.$apiKey, 'Content-Type: application/x-www-form-urlencoded')); curl_setopt($ch, CURLOPT_USERPWD, "$username:$password"); curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "PUT"); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($userData));$result = curl_exec($ch);//close cURL resource curl_close($ch);

Delete User Data via REST API The following code performs a DELETE request to delete user data via RESTful Web Services (Example API).

//API URL $url = 'http://localhost/codeigniter/api/example/user/2';//API key $apiKey = 'CODEX@123';//Auth credentials $username = "admin"; $password = "1234";//create a new cURL resource $ch = curl_init($url);curl_setopt($ch, CURLOPT_TIMEOUT, 30); curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_ANY); curl_setopt($ch, CURLOPT_HTTPHEADER, array("X-API-KEY: " . $apiKey)); curl_setopt($ch, CURLOPT_USERPWD, "$username:$password"); curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'DELETE');$result = curl_exec($ch);//close cURL resource curl_close($ch);

Test HTTP calls with Postman Extension

Postman Extension makes API development faster, easier, and better. Install Postman Extension for testing the API call.

Are you want to get implementation help, or modify or extend the functionality of this script? Submit paid service request

0 notes

lewiskdavid90 · 8 years ago

Text

95% off #AJAX connection to MySQL PHP API – $10

Learn how you can create a simple database API which can be accessed from frontend code, updated and more

Beginner Level, – 2 hours, 24 lectures

Average rating 4.8/5 (4.8 (6 ratings) Instead of using a simple lifetime average, Udemy calculates a course’s star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.)

Course requirements:

HTML and JavaScript basics Frontend web development concepts API general understanding of what it is

Course description:

The scope of the course stays focused to building the API interaction. It covers multiple technologies working together, and topics only in relation to the finished project.

Want to access your MySQL database using JavaScript? Let web visitors interact seamlessly with you MySQL database. Add new content, update existing content, and query the database to return results! Databases provide so much power to your web applications, why not use them more.

This unique course takes you through the steps of creating a simple web api to allow web visitors database interaction. Database is key to creating an amazing interactive dynamic experience for web users. It lets you do more!

This course will open the door for you to build our a lot of COOL STUFF! From the lessons of the course, you will be able to produce a wide range of uses for the code. Source code is included so you can practice along side the lessons, try it out for yourself and tweak it for your individual needs.

This course covers a lot of technologies and demonstrates them all working together to achieve the API objective.

JavaScript and an understanding of the Document Object Model is an important foundation before starting this course. We’ve designed the course to be fast paced step by step covering the essentials to build the web API. Please note that the course overviews core technology used only within the course to build the API.

What you will learn

Basic HTML – setting up simple elements to access from JavaScript Basic CSS – creating buttons jQuery – AJAX, Getting element values from a form, updating element inner HTML. JSON – How to send JSON objects and how to retrieve JSON data and use it as objects within JavaScript. PHP – How to get request variables, setup a mySQL database connection, looping of data, arrays, outputting content as JSON formatted. RegEx – Check values as numeric MySQL – Setup a database, connect to a database, phpmyadmin access, write queries to Update, select and insert data. Prevent SQL injection. See it all working together and much more!

By the end of the course you will have the knowledge on how to put it all together and create a simple API to interact with your database. Use this course as a starting point to limitless options with this fully functional and customizable code.

I’m here to help you learn about APIs and ready to answer any questions you may have. What are you waiting for enrol now and see what you can do!

Full details Create a database connection using PHP Use JSON objects within JavaScript INSERT, UPDATE and GET content from a database into javascript web developers anyone looking to connect frontend code to a database web designers JavaScript developers and jQuery Developers

Reviews:

“” ()

About Instructor:

Laurence Svekis

I’m here to help you learn, achieve your dreams, come join me on this amazing adventure today Innovative technology expert with a wide range of real world experience. Providing Smart digital solutions online for both small and enterprise level businesses. “I have a passion for anything digital technology related, enjoy programming and the challenge of developing successful digital experiences. As an experienced developer, I created my first computer applications in 1990, and my first website in 1998. I enjoy sharing my knowledge with others and want to help you share in the wonderful opportunities that the internet provides.” “Learning, understanding with a strong passion for education. The internet has provided us with new opportunities to expand and share knowledge.” Want to learn more about becoming a web developer, do you want to experience the freedom that technology provides for us? Learn how to bring amazing things to life online. Technology connects us all in many ways. It opens up doors to those who embrace it and learn how to make those connections real. “My courses are designed to help you achieve your goals, learn and update skills” Background : An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications. Web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about everything to do with web application development, programming to online marketing with a strong focus on social media and SEO. “Understanding technology provides a means to better connect with users. It also opens so many doors. Knowledge is the key to success and I want to help you experience what technology has to offer. I’m passionate about web technologies, and look forward to sharing my knowledge and experience with you!”

Instructor Other Courses:

Rapid Website Design with Bootstrap Laurence Svekis, Instructor, 18+yrs Web Experience (52) $10 $200 Bootstrap 4 Website Built from scratch in 1 hour Introduction to using Git …………………………………………………………… Laurence Svekis coupons Development course coupon Udemy Development course coupon Databases course coupon Udemy Databases course coupon AJAX connection to MySQL PHP API AJAX connection to MySQL PHP API course coupon AJAX connection to MySQL PHP API coupon coupons

The post 95% off #AJAX connection to MySQL PHP API – $10 appeared first on Udemy Cupón/ Udemy Coupon/.

from Udemy Cupón/ Udemy Coupon/ http://coursetag.com/udemy/coupon/95-off-ajax-connection-to-mysql-php-api-10/ from Course Tag https://coursetagcom.tumblr.com/post/155955961613

0 notes

kodlogs01 · 5 years ago

Text

What Makes PHP Rule the Software Market Till Now

If you want to develop dynamic, interactive and easy-to-use web applications, most developers recommend choosing PHP as your software development platform. PHP used to mean "Personal Homepage", indicating that its roots lie in creating a simple, personalized website. It is now a popular programming language that developers can use to place interactive elements on a page.

PHP is known for its scalability, huge community support, open source, and many other reasons. There is no doubt that this web development language is preferred over other languages for creating dynamic websites. If you want to build a small website or CMS that fits a specific customer need, using PHP is the best solution. However, when the time comes to focus more on security, architecture, speed, and robust functionality, it's a good time to choose a PHP framework for the project.

Why isn't PHP at war on the web platform?

It is true that there are various web development platforms available in the market and each of them has its own characteristics and functions. PHP shouldn't be included in the race, however, as it has become so popular that developers naturally choose the platform without thinking. So if a war breaks out, PHP wins, and here are a few reasons why.

Google knows it very simply: Google is known as a leading search engine company and thousands of robots crawl the web and index website content. PHP makes it easy for Google to crawl websites and determine the language in which they are built. Most websites that have used PHP respond with a header. So, if Google finds that more than 75% of websites are running PHP after crawling the entire network that is very good and accurate proof that PHP has a large online presence. With millions of websites developed on this platform, PHP remains the most attractive language for developers.

PHP provides maximum control: the language provides more control over the site than any other programming language, and it allows the developer to choose the language. Other languages require long and tedious scripts, but PHP helps developers perform the same function with just a few lines of code. Its open source nature also makes it easily accessible to everyone.

Works Well With Other Languages: PHP language works well with other languages and services such as CSS, HTML and various databases. Scripts have labels and this makes it easy to mix and match between HTML tags, which can make web content very dynamic. Therefore, functions and code can be written into the document in any order.

Excellent support access: Because PHP is an open source platform; There is a large community that offers support. There are lots of guides and references on the web that will make learning PHP easier and contribute to the community. Written codes, commands, and functions can be reused without having to reinvent the wheel.

For More Details, Visit Us: online php programs in community development

sharing problems and answers as community development

eol while scanning string literal

net runtime optimization service

mvn is not recognized as an internal or external command

android process acore has stopped

invalid literal for int with base 10

how to insert multiple array values into database php

How to display multiple selected value of dropdownlist in PHP

how to store multiple select values in database using php

#public static void main string args #android process acore has stopped #how to insert multiple array values into database php #How to display multiple selected value of dropdownlist in PHP

0 notes

kodlogs01 · 5 years ago

Text

Using Timers in Java

Threads can be confusing, and multithreading isn't any better either. The use of timers is very simple JAVA milliseconds in a year Programme and allows several to work at the same time, with different hours without interruption.

The first thing you need is an import package:

import javax.swing.Timer;

Then state the timer:

Timer tmrTest = new timer (1, myTimer);

1 is the interval in milliseconds. This means this timer runs once every millisecond, fast.

myTimer is just the name of ActionListener.

Starting a timer is also required. Perhaps it is best to do this with a basic method.

tmrTest.start (); // There is also a tmrTest.stop (). tmrTest.pause () and various other methods such as finding the current beat time and setting the speed.

Next are the action listeners, who are in the core class and are allowed to move around the class.

ActionListener myTimer = new ActionListener () // Notice how the second timer parameter is named, not the name of the timer!

{

public void actionPerformed (ActionEvent evt)

{

// Do what you want every millisecond

}}

};

And there it is. You can add as many as you want. Just change the name AcitonListeners and don't forget to start the timer!

In general, this is a much simpler method than multiple threads. You can set the time manually instead of continuously counting the variables in the thread. Also, the set times work the same way on any system they are running on. Threads run as fast as current processors allow. This means that on a computer with a better processor, threads will run faster than without it. This can cause problems with your application.

For More Details, Visit Us: how to insert multiple array values into database php

c++ read file line by line

#community problems and solution in development #valueerror invalid literal for int with base 10 #sharing problems and answers as community development

0 notes

kodlogs01 · 5 years ago

Text

Why Is the PHP Web Development Best for You?

Increasingly more entrepreneurs are turning towards PHP web improvement since it's by a long shot the best web advancement device. It is additionally one of the most generally utilized since PHP is open source and one can utilize it for nothing for building highlight rich, quick stacking sites.

Dynamic sites can be assembled utilizing PHP improvement. This involves various PHP web advancement highlights. Discussing the different highlights it involves, let us manage them individually.

PHP, an article arranged scripting language, is utilized to make GUI customer side applications. It can likewise be utilized viably for order line scripting. It's likewise effectively perfect with changed database frameworks and workers like Apache, IIS, Windows, Linux and so on. Since it's free, it tends to be utilized helpfully with no authorizing limitations.

As PHP can be effortlessly coordinated with changed unique visual applications, have confidence that the site being created would involve praiseworthy special visualizations. The scripting language can likewise be joined with Flex, Flash and so on. PHP likewise has an extraordinary illustrations improvement and alteration library to bring your site some outwardly alluring graphical touch.

As PHP uses less codes, the site can be constructed rapidly. Likewise, PHO doesn't order the source code at each example so the site made is a quick stacking one with improved execution.

All the more along these lines, PHP web advancement engages easy LDAP correspondence and age of PDFs. Likewise, PHP is an approximately composed scripting language, which makes it adept to be utilized across differed circumstances with upgraded extent of materialness.

Going to the various advantages of web advancement utilizing PHP programming, it has a range of security preferences and outpaces numerous different dialects in this perspective. Utilizing PHP compiler, the content can be advantageously put away in double arrangement.

PHP improvement encourages in the formation of quick stacking, highlight rich unique sites, for example, web based business, online stores and so on. Other than this, it additionally empowers the formation of differed web applications, backend databases, discussions, CMS and so on.

For more details, Visit us: online php programming test questions and answers

how to insert multiple array values into database php

How to display multiple selected value of dropdownlist in PHP

how to store multiple select values in database using php

online php programming test questions and answers

docker invalid reference format

illegal start of expression

How to print multidimensional array in PHP using for loop

#eol while scanning string literal #online php programs in community development

0 notes

xenleaksinc · 6 years ago

Text

XenForo 2.0.12 With Branding Removal

This version makes a number of changes to improve compatibility with PHP 7.3.0. However, at this time, we do not recommend using PHP 7.3.0 in production due to a bug that can cause code to execute incorrectly, potentially leading to data loss. We believe this bug will be resolved in PHP 7.3.1 when it's released. Some of the changes in XF 2.0.12 include:

Improve PHP 7.3 compatibility.

If available and different from the server version, grab a more detailed version for the Server environment report.

If the $_SERVER['SERVER_SOFTWARE'] value isn't available or valid then just don't display that entry in the report, because it's mostly not essential.

Adds some additional phrases for the "Server environment report"

Fix an issue which affects building add-on releases on Windows where local paths included a leading slash.

Incrementally update the job state of the Sitemap job so that a fatal error shouldn't disrupt the process and introduce corrupted/duplicate items.

Adjust error message given when attempting to edit a user's permissions for a content type without a valid user_id.

Standardize the locale information used by PHP.

Use a different approach to loading icons on the add-ons list in the Admin CP. To avoid issues with multiple database connections, the icon image data is instead converted to a data URI.

User upgrades should not check canPurchase() before processing a payment that has been received, as this method is really only for limiting the UI/purchase setup.

Add some additional trusted IP ranges for Google.

Ensure 'nullable' entity property is reflected in generated code

Ensure node navigation entries use their assigned title

Ignore custom field errors during admin edit and include custom field title with errors

Convert warning notes field to structured text

Correctly apply admin user message leave options

Prevent new messages being duplicated in Firefox

Ensure multi quote quotes are inserted into the correct editor

Hide 'Start a new conversation' link if visitor doesn't have permission to start conversations.

Allow permanent redirects to be stickied and unstickied.

Ensure xfagenav tags use correct router.

Remove extra save call when ignoring member

Remove UTC check from server environment report and link PHP version to phpinfo page

Prevent loading of Setup.php if addon.json requirements aren't met

Make xf-dev:entity-class-properties CLI command correctly handle subdirectories

Return 'complete' response from UserGroupPromotion job if no active promotions are found.

Ensure 'From name' and 'From email' fields are applied when batch emailing users

Hide editor draft menu from guests

Ensure cron entries run at zero valued time units if multiple time values are selected.

Check for missing hash in IPSForums3x authentication handler.

Add missing hint parameter to discouraged checkbox on user edit page

Remove invalid relation from SpamTriggerLog entity

Use content type phrase when rebuilding the search index

Fix incorrect URL on conversation message likes list

Fix broken 'Delay duration' option for floating notices

Allow invalid users to be unfollowed

Re-add explain text in the user_edit form to clarify non-valid user states behaviour.

Include table name in message for any exception occurring in SchemaManager methods.

Implement custom stack trace builder to mask passwords in method arguments

Add deleted item styling to news feed items

When restoring spam cleaned threads, ensure threads which were originally moved are restored back to the correct forum.

Return an error phrase upon invalid callback validation when performing spam clean actions. Note that the method name switches to ucfirst(\XF\Util\Php::camelCase($action)) in XF 2.1 but remains as ucfirst($action) in XF 2.0.

When handling a Stripe webhook that is missing required metadata, when attempting to find a previous related log, ensure said log actually contains a purchase_request_key.

Improve BB code parsing of incomplete tags within plain-child tags.

Migrate user field criteria during upgrade from XF 1.x to 2.x

By default, do not allow cookies to be retrieved as arrays to prevent unexpected behavior. (Array support can now be opted into explicitly.)

Prevent an error when trying to delete a payment profile when there is an invalid purchasable definition.

Track when a preview is pending to prevent multiple simultaneous preview loads.

Prevent a PHP notice when deleting a poll for a thread started by a guest

Include breadcrumb in edit history view and compare templates.

Pass unused $ellipsis variable into wholeWordTrim.

Prevent long select options from causing overflow on iOS.

Enable the HTML to BB code simplification process to handle additional situations

Resolve some situations where the new messages indications while composing a reply wouldn't take you to the expected location.

Validate advertisement html before saving.

Prevent tel/sms links being converted to bbcode

Remove the insert icode option when extended text formatting is disabled. Allow end user modification to the "allow this BB code in signatures" option on add-on-defined custom BB codes.

Call the canPurchase method instead of can_purchase in UserUpgrade::getFilteredUserUpgradesForList.

Correctly combine multiple custom field-related limits to the user and thread searchers.

Correctly apply the "not in secondary groups" user search condition (users cannot be in any of the listed groups).

When building a release and testing a JSON, only consider an error if decoding the build.json does not return an array.

When submitting spammers to StopForumSpam, convert binary IP address to readable string.

When saving style templates through the admin UI, force version/last_edit_date to be updated like XF 1.x

When merging threads, always redirect to the target thread.

Fix currency code for Belarusian Ruble (BYR => BYN)

No longer cache the preview container object in the PreviewClick handler. If there are multiple handlers per page, the cached container becomes incorrect if using different handlers.

When form filling, if the control is a textarea with a textarea-handler, trigger its update method to ensure the textarea is resized appropriately.

Prevent an array-to-string conversion when throwing a bulkInsert exception if a missing column is detected.

Ensure that the user following cache cannot include your own user ID.

Add missing mod_log.thread_poll_reset phrase.

Attempt to exclude dot files/directories from our vendor dependencies.

Number boxes are too wide and cause units to overflow their container, fixed with max-width.

Add "Please do not reply to this message" text to outgoing conversation emails.

Reassign user group changes when merging users

Ensure PasswordChange service errors on any UserAuth error.

Fetch more threads for new threads widget

Ensure exceptions in sub-processes stop execution, and always exit with non-zero error code on error.

Make Disabler system compatible with select options.

Ensure FieldAdder handles Disabler elements correctly

Ensure prefix of destination thread is shown in moved post alert.

Trigger change event on select when prefix selected

Remove the "mixed" stuff from CodeMirror's PHP mode so that the opening tag is no longer required.

Update broken link to Apple support in cookie help page text (and in XF 1.5).

Adjust top border radii of blocks within overlays.

Allow non-user selectable styles to be used for the email style. Also, add several email-related style properties to allow email colors to be overridden more directly, without creating a new style.

Implement a "notice watcher" system for bottom fixed notices. This calculates the total visible notice height in the bottom fix location and adds a footer margin to the same value so that no content can be covered by the notice(s).

Adjust how we parse search query modifiers to be more strict. (- and + require whitespace before and none after, | requires whitespace on both sides. Don't parse doubled up modifiers.)

Adjust trophies phrase capitalization

Include no_date_limit in the rel=canonical link for forums when needed

Attempt to reduce cases where conversation reply_count values could potentially get out of sync. Allow the reply count and other parts to be rebuilt via the conversation rebuild tool.

By default, reject email addresses as invalid if there are no dots in the domain part.

Add a bit of left padding on contentRow-suffix elements.

Include the forum a thread is in in the RSS feeds (only for global feeds)

Fix add-on development data not being removed as expected when the last entry of a type has been removed. (The metadata JSON file must still exist.)

Relax URL validation a tiny bit, notably don't block adjacent path separators in the path section.

Ensure phrase is escaped in HTML attribute.

Ensure usage of phrase within HTML attribute is escaped.

In the AbstractSearcher ensure that the day end value is converted properly to the end of the day.

Never allow the XF add-on to appear in add-on lists.

Handle avatar deletes via the spam cleaner for gravatars too.

Make add-on action finalization more robust when uninstalling legacy add-ons.

When importing dev output, ignore any invalid columns.

Add some block border radius to the member header block so that it fits within its parent block.

Ensure permissions are rebuilt on add-on active change.

Update child navigation entries directly when the parent ID changes to ensure dev output is written correctly.

Use the correct maxlength value for the public navigation structure. Additionally, bump AdminNavigation ID lengths up to 50 from 25.

Add support for partial indexes to schema manager conflict resolution system

Fix multiple issues that make it hard to use XF\Import\Data\AbstractEntityData

Consistently use code paths which result in the canView method of the report entity (rather than the handler) being used.

The following public templates have had changes:

account_upgrades

core_contentrow.less

core_input.less

core_overlay.less

editor_base.less

edit_history_compare

edit_history_view

forum_view

PAGE_CONTAINER

quick_reply_macros

thread_save_draft

warning_info

XenForo 2.0.12 Branding Removal Nulled.zip

source https://xenforoleaks.com/topic/309-xenforo-2012-with-branding-removal/

0 notes

xenleaksinc · 6 years ago

Text

XenForo 2.0.12 - Full Install

xenforo_2.0.12_full.zip

source https://xenforoleaks.com/topic/307-xenforo-2012-full-install/

0 notes