<?php
/*
| File: url_checker.php
| Info: Take CSV as inpu and check url status.
| Usage: php url_checker.php
|
| CSV file contain URLS
|
| ex:
| www.site.com/url1
| www.site.com/url2
| www.site.com/url3
| www.site.com/url4
| www.site.com/url5
| www.site.com/url6
| www.site.com/url7
|
*/
$file = fopen("urls.csv","r");
while(! feof($file))
{
$row = fgetcsv($file);
$handle = curl_init($row[0]);
curl_setopt($handle, CURLOPT_RETURNTRANSFER, TRUE);
$response = curl_exec($handle);
$httpCode = curl_getinfo($handle, CURLINFO_HTTP_CODE);
if($httpCode!=200)
{
//Following will use teminal colors to
echo "\033[01;31m{$httpCode} \033[0m {$row[0]} \n";
}
else
{
echo $httpCode."\n";
}
}
echo "Finished fetching...";
fclose($file);
?>
Do you ever want to execute slq statements at once. I mean SQL Script file. Normally we are using like following commands to Execute Single SQL statement. SqlCommand cmd = new SqlCommand(sSQL, conn); cmd.ExecuteNonQuery(); cmd.Dispose(); but this way you can execute one command at a time. We cannot execute SQL script using above command. Normal SQL Script Like this. if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__titleauth__au_id__0519C6AF]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[titleauthor] DROP CONSTRAINT FK__titleauth__au_id__0519C6AF GO CREATE TABLE [dbo].[authors] ( [au_id] [id] NOT NULL , [au_lname] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [au_fname] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [phone] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [address] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [city] [varchar] (20) COLL...
Comments
Post a Comment