update command is denied for user

For everyone who have tried answering this question here is my sincere thanks. I have found the problem and solution. my sql query is like this UPDATE `dblayer`.`test` SET `title` = ‘hello a’ WHERE `test`.`id` =1; which I got from phpmyadmin and it works perfectly on my system. But when I work on the servers … Read more

How to access site through IP address when website is on a shared host?

According with the HTTP/1.1 standard, the shared IP hosted site can be accessed by a GET request with the IP as URL and a header of the host. Here there are two examples(wget and curl): $ wget –header ‘Host:somerandomservice.com’ http://67.225.235.59 $ curl –header ‘Host:somerandomservice.com’ http://67.225.235.59 Resources: https://en.wikipedia.org/wiki/Shared_web_hosting_service http://www.w3.org/Protocols/rfc2616/rfc2616-sec14.html#sec14.23

What is the equivalent to cron jobs in ASP.NET?

Try Quartz.NET. It’s a decent .NET scheduler which supports CRON expressions, CRON triggers and various other means and methods to schedule tasks to be performed at certain times / intervals. It even includes a basic Quartz.NET server (Windows Application) that might fit your needs. Edit: If you can’t run applications or windows services within your … Read more

How can I use Prettify with Blogger/BlogSpot?

When you make a new entry in Blogger, you get the option to use HTML in your entry and to edit your blog entries. So type http://blogger.com, log in, and navigate to Posting → Edit Posts → Edit. In there put this at the top: <script type=”text/javascript” language=”javascript” src=”https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/prettify.min.js”></script> <script type=”text/javascript” language=”javascript” src=”https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-css.min.js”></script> <script type=”text/javascript”> … Read more

Change primary key column in SQL Server

Assuming that your current primary key constraint is called pk_history, you can replace the following lines: ALTER TABLE history ADD PRIMARY KEY (id) ALTER TABLE history DROP CONSTRAINT userId DROP CONSTRAINT name with these: ALTER TABLE history DROP CONSTRAINT pk_history ALTER TABLE history ADD CONSTRAINT pk_history PRIMARY KEY (id) If you don’t know what the … Read more

PHP session lost after redirect

First, carry out these usual checks: Make sure session_start(); is called before any sessions are being called. So a safe bet would be to put it at the beginning of your page, immediately after the opening <?php declaration before anything else. Also ensure there are no whitespaces/tabs before the opening <?php declaration. After the header … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)