Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- </head>
- <body>
- <?php
- /* В базе new данных куда устанавливаете скрипт создаем таблицу short вида - CREATE TABLE IF NOT EXISTS short
- ( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
- url TEXT NOT NULL,
- short_key TEXT NOT NULL,
- PRIMARY KEY (id),
- KEY short_key (short_key)
- )
- ENGINE=InnoDB;*/
- $url = htmlspecialchars($_POST['url']);
- if(empty($_POST['url'])){}
- if(empty($_POST['upload'])){}
- else {
- $con= mysql_connect('127.0.0.1','root','') or die ('error');
- if(!($con))
- echo ("Server Not connect");
- $db= mysql_select_db("new", $con)or die ('error');
- if(!($db))
- echo ("Database Not Select");
- @$first = mysql_fetch_assoc(mysql_query("SELECT * FROM short WHERE 'url' = '".$url."' "));
- if($first)
- {
- $second=[
- 'url'=>$first['url'],
- 'key'=>$first['short_key'],
- '$link'=>
- 'http://'.$_SERVER['HTTP_HOST'].'/'.$first['short_key']
- ];
- }
- else{
- /*Генерация адреса*/
- function generate_name($length){
- $code = '';
- $symbols = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';
- for( $i = 0; $i < (int)$length; $i++ )
- {
- $num = rand(1, strlen($symbols));
- $code .= substr( $symbols, $num-1, 1 );
- }
- return $code;
- }
- $rand=rand(5, 25);
- $res=generate_name(6);
- $con= mysql_connect('127.0.0.1','root','') or die ('error');
- if(!($con))
- echo ("Server Not connect");
- $db= mysql_select_db("new", $con)or die ('error');
- if(!($db))
- echo ("Database Not Select");
- mysql_query("INSERT INTO short(id,url,short_key) VALUES (NULL,'".$url."','".$rand.$res."')",$con);
- @$select= mysql_fetch_assoc(mysql_query("SELECT * FROM short WHERE url = '$url' "));
- $third=[
- 'url'=>$select['url'],
- 'key'=>$select['short_key'],
- '$link'=>'http://'.$_SERVER['HTTP_HOST'].'/'.$select['short_key']
- ];
- echo "КОРОТКАЯ ССЫЛКА<br>";
- print_r($third['$link']);
- echo "<br>";
- } //echo $result;
- echo "<br>";
- echo $url;
- }
- ?>
- <form enctype="multipart/form-data" action="" method="post" id="ajax_form" >
- <font style="font-size: 150%;">Введите полный адрес:</font><br>
- <input type="text" name="url"><br>
- <input type="submit" name="upload" id="btn" value="Преобразовать"/>
- </form>
- <br>
- <div id="result_form"></div>
- <!--<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>
- <script type="text/javascript" src="ajax.js" >
- </script>-->
- </body>
- </html>
Add Comment
Please, Sign In to add comment