Simple php Coding: 2020

Monday, 26 October 2020

Google sitemap submiter

Just ping this url and submit your website sitemap in google :

https://google.com/webmasters/sitemaps/ping?sitemap=https://sakhihosting.in/sitemap.xml

replace sakhihosting.in with your domain name.

first generate and save sitemap.xml file in your public folder .

After ping this url your browes give output like this :

Sitemap Notification Received

Your Sitemap has been successfully added to our list of Sitemaps to crawl. If this is the first time you are notifying Google about this Sitemap, please add it via http://www.google.com/webmasters/tools/ so you can track its status. Please note that we do not add all submitted URLs to our index, and we cannot make any predictions or guarantees about when or if they will appear.

Saturday, 18 July 2020

How to select all duplicates in MySQL

Select all duplicate rows :

first craete table

table name : demotable

column : Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,

Name varchar (100)

demo data :

demodata

+----+--------+
| Id | Name   |
+----+--------+
| 1  | John   |
| 2  | Chris  |
| 3  | John   |
| 4  | David  |
| 5  | Bob    |
| 6  | Chris  |
| 7  | Mike   |
| 8  | Robert |
| 9  | Mike   |
+----+--------+

select *from prersi where open in (select open from prersi group by open having count(*) > 1)

Output

+----+-------+
| Id | Name  |
+----+-------+
| 1  | John  |
| 2  | Chris |
| 3  | John  |
| 6  | Chris |
| 7  | Mike  |
| 9  | Mike  |
+----+-------+

Monday, 13 July 2020

Select Data From a MySQL Database

The SELECT statement is used to select data from one or more tables:

SELECT column_name(s) FROM table_name

or we can use the * character to select ALL columns from a table:

SELECT * FROM table_name

Select Data With MySQLi

The following example selects the id, firstname and lastname columns from the MyGuests table and displays it on the page:

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
  // output data of each row
  while($row = $result->fetch_assoc()) {
    echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
  }
} else {
  echo "0 results";
}
$conn->close();

Code lines to explain from the example above:

First, we set up an SQL query that selects the id, firstname and lastname columns from the MyGuests table. The next line of code runs the query and puts the resulting data into a variable called $result.

Then, the function num_rows() checks if there are more than zero rows returned.

If there are more than zero rows returned, the function fetch_assoc() puts all the results into an associative array that we can loop through. The while() loop loops through the result set and outputs the data from the id, firstname and lastname columns.

Sunday, 21 June 2020

Download file from URL using PHP

Method 1: Using file_get_contents() function: The file_get_contents() function is used to read a file into a string. This function uses memory mapping techniques which are supported by the server and thus enhances the performances making it a preferred way of reading contents of a file.

Syntax:

file_get_contents($path, $include_path, $context, $start, $max_length)

Method - 1:

Method 1 Code Start Here

<?php

// Initialize a file URL to the variable

$url = 'https://cdnassets.com/ui/supersite/themes/EliteGreen/images/banner-cloudhosting.jpg';

// Use basename() function to return the base name of file

$file_name = basename($url);

// Use file_get_contents() function to get the file

// from url and use file_put_contents() function to

// save the file by using base name

if(file_put_contents( $file_name,file_get_contents($url))) {

echo "File downloaded successfully";

}

else {

echo "File downloading failed.";

}

Method 1 Code End Here

Method 2:

Using PHP Curl: The cURL stands for ‘Client for URLs’, originally with URL spelled in uppercase to make it obvious that it deals with URLs. It is pronounced as ‘see URL’. The cURL project has two products libcurl and curl.

Steps to download file:

Initialize a file URL to the variable

Create cURL session

Declare a variable and store the directory name where downloaded file will save.

Use basename() function to return the file base name if the file path is provided as a parameter.

Save the file to the given location.

Open the saved file location in write string mode

Set the option for cURL transfer

Perform cURL session and close cURL session and free all resources

Close the file

Method 2 Code Start Here

<?php

// Initialize a file URL to the variable

$url = 'https://cdnassets.com/ui/supersite/themes/EliteGreen/images/banner-cloudhosting.jpg';

// Initialize the cURL session

$ch = curl_init($url);

// Inintialize directory name where

// file will be save

$dir = './';

// Use basename() function to return

// the base name of file

$file_name = basename($url);

// Save file into file location

$save_file_loc = $dir . $file_name;

// Open file

$fp = fopen($save_file_loc, 'wb');

// It set an option for a cURL transfer

curl_setopt($ch, CURLOPT_FILE, $fp);

curl_setopt($ch, CURLOPT_HEADER, 0);

// Perform a cURL session

curl_exec($ch);

// Closes a cURL session and frees all resources

curl_close($ch);

// Close file

fclose($fp);

Method 2 Code End Here

Thursday, 18 June 2020

How to get the count of each distinct value in a column in MySQL

<?php

include "connect.php"; //here your database connection page

$sql = "SELECT id ,min,max, COUNT(max) tot FROM dogebtccandle group by max having count(max) > 1 order by tot desc";

$result = $connection->query($sql);

if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()){

echo "id: " . $row["id"]. " - Name: " . $row["min"]. " max " . $row["max"]. "count " . $row["tot"]. "<br>";

}}

else {echo "count no";}

my database details

table name dogebtccandle

column : id , min , max

id	min	max
1	0.00000026247	0.00000026268
2	0.00000026247	0.00000026303
3	0.00000026247	0.00000026264
4	0.00000026246	0.00000026310
5	0.00000026211	0.00000026332
6	0.00000026211	0.00000026324
7	0.00000026178	0.00000026310
8	0.00000026180	0.00000026279
9	0.00000026178	0.00000026296
10	0.00000026179	0.00000026289
11	0.00000026179	0.00000026299
12	0.00000026167	0.00000026290
13	0.00000026167	0.00000026278
14	0.00000026152	0.00000026248
15	0.00000026178	0.00000026248
16	0.00000026138	0.00000026348
17	0.00000026255	0.00000026346
18	0.00000026225	0.00000026397
19	0.00000026225	0.00000026349
20	0.00000026250	0.00000026361

Thursday, 4 June 2020

Get client IP address using php

<?php

if (!empty($_SERVER['HTTP_CLIENT_IP']))

{

$ip_address = $_SERVER['HTTP_CLIENT_IP'];

}

//whether ip is from proxy

elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))

{

$ip_address = $_SERVER['HTTP_X_FORWARDED_FOR'];

}

//whether ip is from remote address

else

{

$ip_address = $_SERVER['REMOTE_ADDR'];

}

echo $ip_address;

Friday, 29 May 2020

Perform Email validation using OnKeyPress in JavaScript

The OnKeyPress event does not update the value of the TextBox when accessed using JavaScript and hence OnKeyUp event handler will be used to validate Email Address dynamically when User types in the Email Address in the TextBox.

HTML Markup

The following HTML Markup consists of an HTML TextBox and a SPAN element. The TextBox has been assigned an OnKeyUp event handler which calls the ValidateEmail JavaScript function.

<input type="text" id="txtEmail" onkeyup="ValidateEmail();" />

<span id="lblError" style="color: red"></span>

JavaScript function to perform Email validation OnKeyPress using JavaScript

When User types in the TextBox, the Email Address in the TextBox will be validated using OnKeyUp event handler in JavaScript and if the Email Address is invalid, the error message will be displayed next to the TextBox.

<script type="text/javascript">

    function ValidateEmail() {

        var email = document.getElementById("txtEmail").value;

        var lblError = document.getElementById("lblError");

        lblError.innerHTML = "";

        var expr = /^([\w-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([\w-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$/;

        if (!expr.test(email)) {

            lblError.innerHTML = "Invalid email address.";

        }

    }

</script>

Friday, 6 March 2020

How to fetch and insert hitbtc balance in mysql using curl php

I fetch my trade balance from hitbtc server using api and insert data in my mysql database using curl php.
Create database table :
id = int (3) auto_increment
currencry = varchar(20)
available = varchar(20)
reserved = varchar(20)
date = datetime

Create balance.php file and copy given code and paste in balance.php file.

/// Start coding
<?php
define('TIMEZONE', 'Asia/kolkata');
date_default_timezone_set(TIMEZONE);
?>
<?php
//delete row
include "connect.php";
//$sqldel = "DELETE FROM trade WHERE quantity1 <= 0";

//if ($connection->query($sqldel) === TRUE) {
// echo "Record deleted successfully";
// } else {
// echo "Error deleting record: " . $connection->error;
// }
?>
<?php
$ch = curl_init('https://api.hitbtc.com/api/2/trading/balance');
curl_setopt($ch, CURLOPT_USERPWD, 'API_KEY : SECRET_KEY'); // API AND KEY
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/x-www-form-urlencoded'));
curl_setopt($ch, CURLOPT_HTTPHEADER, array('accept: application/json'));
$return = curl_exec($ch);
curl_close($ch);
//print_r($return);
// $data = json_decode(file_get_contents($ch), true);

?>

<div class="container box">
<h3 align="center">Import JSON File Data into Mysql Database in PHP</h3><br />
<?php
$sql123 = "TRUNCATE TABLE balance ";
if ($connection->query($sql123) === TRUE) {
echo "Ready for New Record updated successfully";
} else {
echo "Error updating record: " . $connection->error;
}
$query = '';
$table_data = '';
$date = Date("Y-m-d H:i:s");
//$filename = "balance.json";
//$data = file_get_contents($filename); //Read the JSON file in PHP
// $array = json_decode($return, true); //Convert JSON String into PHP Array
//start
$data = json_decode($return, true);
$need = array(
1 =>'DOGE',
2=>'BTC'
);
foreach ($data as $key => $value) {
if (in_array($data[$key]['currency'], $need)) {
echo $data[$key]['currency'] . " = " . $data[$key]['available'] . " = " . $data[$key]['reserved'];
echo "<br>";
}
}
////end
foreach ($data as $key => $value) {//Extract the Array Values by using Foreach Loop
if (in_array($data[$key]['currency'], $need)) {
//$query .= "UPDATE top (100) balance SET currency = ('".$row["currency"]."'), available = ('".$row["available"]."'), reserved = ('".$row["reserved"]."'); ";
$query .= "INSERT INTO balance(currency, available,reserved,date) VALUES ('".$data[$key]['currency']."', '".$data[$key]['available']."','".$data[$key]['reserved']."','$date'); "; // Make Multiple Insert Query
$table_data .= '
<tr>
<td>'.$data[$key]["currency"].'</td>
<td>'.$data[$key]["available"].'</td>
<td>'.$data[$key]["reserved"].'</td>
</tr>
'; //Data for display on Web page
} }
if(mysqli_multi_query($connection, $query)) //Run Mutliple Insert Query
{
echo '<h3>Imported JSON Data</h3><br />';
echo '
<table class="table table-bordered">
<tr>
<th width="45%">Name</th>
<th width="10%">Available</th>
<th width="45%">Reserved</th>
</tr>
';
echo $table_data;
echo '</table>';
}

?>

<br />
///// end coding

Saturday, 15 February 2020

श्री राम शलाका प्रश्नावली in hindi using mysql and php

Create index.php and copy code and paste. modify database details .

create database table and upload

< dump data for ram shakala start>

CREATE table `ram` (
`id` int(11) NOT NULL,
`ques` mediumtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ans` mediumtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ram`
--
INSERT INTO `ram` (`id`, `ques`, `ans`) VALUES
(1, 'चौपाई : उघरहिं अंत न होइ निबाहू। कालनेमि जिमि रावन राहू॥', 'अर्थ:यह चौपाई बालकाण्ड के आरम्भ की है। कार्य की सफलता मे संदेह है।\r\n'),
(2, 'चौपाई :गरल सुधा रिपु करहिं मिताई। गोपद सिंधु अनल सितला', 'अर्थ:यह चौपाई सुन्दरकाण्ड मे हनुमान जी के लंका मे प्रवेश करने के समय की है। प्रश्न बहुत श्रेष्ठ है कार्य सिद्ध होगा।\r\n'),
(3, 'चौपाई : प्रबिसि नगर कीजे सब काजा। हृदय राखि कोसलपुर राजा॥\r\n', 'अर्थ: यह चौपाई सुन्दरकाण्ड मे हनुमान जी के लंका मे प्रवेश करने के समय की है। अर्थ यह है कि भगवान के नाम का स्मरण करते हुये कार्य शुरू करें सफलता मिलेगी।\r\n'),
(4, 'चौपाई : बिधि बस सुजन कुसंगत परहीं। फनि मनि सम निज गुन अनुसरहीं॥\r\n', 'अर्थ: यह चौपाई बालकाण्ड के आरम्भ की है। अर्थ यह है कि बुरे लोगों का संग छोड़ दें कार्य की सफलता मे संदेह है।'),
(5, 'चौपाई : मुद मंगलमय संत समाजू। जो जग जंगम तीरथ राजू॥\r\n', 'अर्थ: यह चौपाई बालकाण्ड मे संत समाजरुपी तीर्थ वर्णन मे आती है। अर्थ यह है कि कार्य सिद्ध होगा।\r\n'),
(6, 'चौपाई : बरुन कुबेर सुरेस समीरा। रन सन्मुखधरि काहु न धीरा॥\r\n', 'अर्थ: यह चौपाई रावण वध पर मंदोदरी के विलाप के संदर्भ मे है। कार्य पूरा होने मे संदेह है।\r\n'),
(7, 'चौपाई : सुनु सिय सत्य असीस हमारी। पूजहि मन कामना तुम्हारी॥\r\n', 'अर्थ: यह चौपाई बालकाण्ड मे सीता जी को गौरी जी का आशिर्वाद है। प्रश्न उत्तम है कार्य सिद्ध होगा।\r\n'),
(8, 'चौपाई : सुफल मनोरथ हो हुँ तुम्हारे। रामु लखनु सुनि भए सुखारे॥\r\n', 'अर्थ: यह चौपाई विश्वामित्र का आशिर्वाद है। प्रश्न उत्तम है कार्य सिद्ध होगा।\r\n'),
(9, 'चौपाई : होइहि सोइ जो राम रचि राखा। को करितर्क बढ़ावै साखा॥\r\n', 'अर्थ: यह चौपाई बालकाण्ड शिव पार्वती संवाद मे है। कार्य पूरा होने मे संदेह है। प्रभु पर छोड़ दें।\r\n ');

< dump data for ram shakala end >

<!DOCTYPE html>

<head>

<title>

राम शलाका, Ram Shalaka, Shri Ram Shalaka, Ram prashnavali, shri ram prashnavali in hindi </title>

</head>

<body>

<center> <h2 class="title-style-1">श्री राम शलाका प्रश्नावली <span class="title-under"></span><br></h2>

<td> श्री राम शलाका प्रश्नावली (Shri Ram Prashnavali) गोस्वामी तुलसीदास रचित "श्री राम चरित मानस" पर आधारित है। इस प्रश्नावली का प्रयोग कर आप जीवन के कई प्रश्नों का जवाब पा सकते हैं। इस प्रश्नावली का प्रयोग करना बेहद आसान है। सबसे पहले भगवान श्री राम का स्मरण करते हुए अपने सवाल को मन में अच्छी तरह सोच लें। इसके बाद नीचे दिए गए किसी भी अक्षर पर आंख बंद कर के क्लिक करें। आपके द्वारा क्लिक किए हुए अक्षर से प्रत्येक 9वें नम्बर के अक्षर को जोड़ कर एक चौपाई बनेगी जो की आपके प्रश्न का उत्तर होगी।</div>

</td></tr></table>

<?php

$servername = "localhost";

$username = "dbusername";

$password = "dbpassword";

$dbname = "dbname";

// Create connection

$connection = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($connection->connect_error) {

die("Connection failed: " . $connection->connect_error);

}

$id=$_GET['id'];

include ("connect.php");

//where parent=''

$sql = "SELECT * FROM ram where id='$id' ";

mysqli_set_charset( $connection, 'utf8');

$result = $connection->query($sql);

<?php

$i=0;

while($row = mysqli_fetch_array($result)) {

<?php

$i++;

}

</table>

</tr><tr><td width="15px"><center><a href="?id=2">र </a></center></td>

</tr><tr> <td width="15px"><center> <a href="?id=4">सुज </a></center></td>

</tr><tr> <td width="15px"><center> <a href="?id=7">त्य </a></center></td>

</tr><tr> <td width="15px"><center> <a href="?id=2">पु </a></center></td>

</tr><tr> <td width="15px"><center> <a href="?id=4">त </a></center></td>

</tr><tr> <td width="15px"><center> <a href="?id=7">म </a></center></td>

</tr><tr> <td width="15px"><center> <a href="?id=2">ता </a></center></td>

</tr><tr> <td width="15px"><center> <a href="?id=4">नि </a></center></td>

</tr><tr> <td width="15px"><center> <a href="?id=7">हि </a></center></td>

</tr><tr> <td width="15px"><center> <a href="?id=2">सिं </a></center></td>

</tr><tr> <td width="15px"><center> <a href="?id=4">गु </a></center></td>

</tr><tr> <td width="15px"><center> <a href="?id=7">ना </a></center></td>

</tr><tr> <td width="15px"><center> <a href="?id=2">सि </a></center></td>

</tr><tr> <td width="15px"><center> <a href="?id=4">र </a></center></td>

<td width="15px"><center> <a href="?id=8">रे </a></center></td

</tr></table>

</body>

</html>