PHP. Изучение языков и web-технологий PHP. Изучение языков и web-технологий

Просто рабочий конспект

 
setcookie(name[, value[, expiryTime[, path[, domain[, secure[,httpOnly]]]]]])
 

 
session_start();

$_SESSION['password'] = 'mypassword';

unset($_SESSION['password']);

$_SESSION = array();

session_destroy();
 

$html = file_get_contents($srcurl);

$result=file_put_contents($tempfilename, $html);

file_exists($tempfilename);

unlink($tempfilename);

copy($tempfilename, $targetfilename);

 
<form action="index.php" method="post" enctype="multipart/form-data">
   <div><label id="my_files">Select file to upload:
               <input type="file" id="upload" name="upload"/></label>

   </div>
   <div><input type="hidden" name="action" value="upload"/>

            <input type="submit" value="Submit"/>
   </div>
</form>
 

 
$filename = 'C:/uploads/' . time() . $_SERVER['REMOTE_ADDR'] . $ext;
 

 
if (!is_uploaded_file($_FILES['upload']['tmp_name']) or
  !copy($_FILES['upload']['tmp_name'], $filename))

{ обработка ошибки ...}
 

 
header("Content-type: $mimetype");
 

 
header("Content-disposition: inline; filename=$filename");
 

 
$sql = "SELECT filename, mimetype, filedata FROM filestore WHERE id = '$id'";

...

$file = mysqli_fetch_array($result);

$filename = $file['filename'];
$mimetype = $file['mimetype'];
$filedata = $file['filedata'];
$disposition = 'inline';    // просмотр на месте

if ($_GET['action'] == 'download')
{
$mimetype = 'application/x-download';
$disposition = 'attachment';
}

header("Content-type: $mimetype");
header("Content-disposition: $disposition; filename=$filename");
header('Content-length: ' . strlen($filedata));

echo $filedata;

Просто рабочий конспект

 
putenv("NLS_LNAG=AMERICAN_CIS.CL8MSWIN1251");
$link = oci_connect( "user" , "password" , "//192.168.1.10:1521/orcl" );
if (!$link)
{
    $err = oci_error ();
    $error = 'Ошибка подключения: ' . $err ['message'];
    include 'error.html.php';
    exit();
}
 

 
$link = oci_connect( "user" , "password" , "testdb" );
 

 
$sql = 'select TO_CHAR(to_oradate(start_date),' . "'MM.DD.YYYY'" .') as dt,t1.dbsessionid as id,novellname as name
   from sys#locks t1,x$activeusers t2 where t1.dbsessionid =t2.dbsessionid order by novellname';

$stid = oci_parse($link, $sql); // не проверяем результат - опция не работает
$result = oci_execute($stid, OCI_DEFAULT);
 

 
while ($row = oci_fetch_assoc($stid))
{
    $users[] = array('dt' => $row['DT'], 'id' => $row['ID'], 'name' => $row['NAME']);
}
 

 
  if (!$result)   {
    $e = oci_error($stid);
    $error = 'Error : ' . htmlentities($e['message']) . ' : ' . htmlentities($e['sqltext']);
    include 'error.html.php';
   exit();
  }
 

Просто рабочий конспект

 
<ul>

      <li><a href="jokes/">Manage Jokes</a></li>
      <li><a href="authors/">Manage Authors</a></li>
      <li><a href="categories/">Manage Joke Categories</a></li>
</ul>
 

 
header('Location: .');

exit();
 

 
<ul>
   <?php foreach ($authors as $author): ?>
     <li>
     <form action="" method="post">
     <div>
        <?php htmlout($author['name']); ?>
        <input type="hidden" name="id" value="<?php echo $author['id']; ?>"/>
        <input type="submit" name="action" value="Edit"/>
        <input type="submit" name="action" value="Delete"/>
     </div>
     </form>
     </li>
  <?php endforeach; ?>
</ul>

 
 <?php if (isset($users)): ?>
     <table>
       <tr><th>Отметить</th><th>Юзер</th><th>DBSESSIONID</th><th>Дата входа</th></tr>
       <form action="?" method="post">
            <?php foreach ($users as $user): ?>
                <tr valign="top">
                 <td><input type="checkbox" name="kill[]" id="dbsession<?php $user['id']?>" value="<?php htmlout($user['id']); ?>" /> </td>
                  <td><?php htmlout($user['name']); ?></td>
                  <td><input type="text" name="id[]" value="<?php htmlout($user['id']); ?>" disabled /></td>
                  <td><?php htmlout($user['dt']); ?></td>
                </tr>
                <?php endforeach; ?>
            </table>
       <input type="submit" name="askme" value="Подтвердить удаление"/>
       <input type="hidden" name="action" value="delete"/>
    </form>
 <?php endif; ?>

 
if (isset($_POST['action']) and $_POST['action'] == 'delete' and isset($_POST['kill']) )
{
  $list = "'" . join("','", $_POST['kill']) . "'";
  $sql = 'delete from sys#locks where dbsessionid in ( ' . $list . ')' ;
  $stid = oci_parse($link, $sql);
  $result = oci_execute($stid, OCI_DEFAULT);
  include 'ctrl_sql_err.php';
  oci_commit($link);
  header('Location: .');
  exit();
}
 

 
<?php foreach ($authors as $author): ?>
     <option value="<?php htmlout($author['id']); ?>" 

                 <?php if ($author['id'] == $authorid) echo ' selected="selected"';?>>

                 <?php htmlout($author['name']); ?>

     </option>
<?php endforeach; ?>
 

 
<?php foreach ($categories as $category): ?>
    <div><label for="category<?php htmlout($category['id']);?>">

             <input type="checkbox" name="categories[]" id="category<?php htmlout($category['id']); ?>"
                       value="<?php htmlout($category['id']); ?>"

                        <?php if ($category['selected']) echo ' checked="checked"'; ?>/>

            <?php htmlout($category['name']); ?></label></div>
<?php endforeach; ?>
 

Просто рабочий конспект

 
<?php include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php'; ?>
 

 
<h1><?php htmlout($pagetitle); ?></h1>