function addPart($pdo, $descr, $ext) { // function addPart($pdo, $descr, $typeid, $ext){ // $pdo = dbConnect(); // echo '<br><span>Hit function addPart().</span><br>'; try { $sql = 'SELECT MAX(id) AS "NEXT_ID" FROM tbPart FOR UPDATE'; $stmt = $pdo->query($sql); $row = $stmt->fetch(); $next_id = $row['NEXT_ID'] + 1; } catch (PDOException $e) { $error = 'Failed to count parts' . $e->getMessage(); echo $error; } // echo $next_id; try { // $sql = 'INSERT INTO tbPart (descr, typeid, image) VALUES ( :descr, :typeid, :image )'; $sql = 'INSERT INTO tbPart (descr, image) VALUES ( :descr, :image )'; $s = $pdo->prepare($sql); $s->bindValue(':descr', $descr, PDO::PARAM_STR); // $s -> bindValue(':typeid', $typeid, PDO::PARAM_INT); // $filename = ($pdo -> lastInsertId()).$ext; $filename = $next_id . $ext; $s->bindValue(':image', $filename, PDO::PARAM_STR); $s->execute(); $last_id = $pdo->lastInsertId(); append_log('#' . $last_id . ' added to part number table'); } catch (PDOException $e) { $error = 'Insert part failed with following error:<br>' . $e->getMessage(); echo $error; } return $last_id; }
$sections = array("author", "changed", "diff", "log"); foreach ($sections as $section) { ${$section} = trim(`{$svnlook} {$section} {$repos}`); } if ($author == "") { $author = "[unknown author]"; } $body = <<<END {$log} # Changed {$changed} # Diff {$diff} END; $subject = "svn commit by {$author} (rev {$rev})"; $success = mail("*****@*****.**", $subject, $body, "From: svn@phpcompiler.org\r\n"); // Log the commit if ($success) { append_log("mail delivery ok"); } else { append_log("mail delivery failed"); } function append_log($string) { $file = fopen("/misc/svn/post-commit.log", "a"); fwrite($file, date("D M j G:i:s Y")); fwrite($file, ": {$string}\n"); fclose($file); }
<?php // include_once './php/db_const.php'; include_once './include/php/log.php'; const DB_HOST = 'mysql:host=localhost;'; const DB_USER = '******'; const DB_PASS = '******'; const DB_NAME = 'dbname=dbPart'; try { $pdo = new PDO(DB_HOST . DB_NAME, DB_USER, DB_PASS); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->exec('SET NAMES "utf8"'); } catch (PDOException $e) { $error = 'Unable to connect to the database server.<br>' . $e->getMessage(); echo $error; } echo 'database connected'; append_log('Database connection successful');
<?php include './include/php/connect.php'; include_once './include/php/log.php'; echo '<script type="text/javascript">console.log("' . $_POST['action'] . ';"</script> -->'; // Insert new part if (!isset($_POST['action'])) { try { $sql = 'INSERT INTO tbPart (descr, image) VALUES ( :descr, :image )'; $s = $pdo->prepare($sql); $s->bindValue(':descr', $_POST['descr'], PDO::PARAM_STR); // $s -> bindValue(':typeid', $typeid, PDO::PARAM_INT); // $filename = './img/'.($pdo -> lastInsertId()).'.jpg'; $s->bindValue(':image', $_POST['image'], PDO::PARAM_STR); $s->execute(); $last_id = $pdo->lastInsertId(); append_log('#' . $last_id . ' added to part number table'); } catch (PDOException $e) { $error = 'Insert part failed with following error:<br>' . $e->getMessage(); echo $error; } }
if ($res[0] == 1) { $_SESSION['id'] = session_id(); // Initialize $_SESSION variable $sql = 'SELECT fname FROM tbUser WHERE username = :username AND password = MD5(CONCAT(:password,"mickey mouse"))'; $s = $pdo->prepare($sql); $s->bindParam(':password', $password, PDO::PARAM_STR); $s->bindParam(':username', $username); $s->execute(); $row = $s->fetch(PDO::FETCH_BOTH); // fetch the first row of results (there should be only one) $_SESSION['username'] = $username; // Initialize $_SESSION variable $_SESSION['name'] = $row['fname']; append_log($username . ' logged in successfully'); echo json_encode(array('action' => 'login', 'authorized' => true, 'message' => 'login successful', 'session' => $_SESSION['id'], 'name' => $_SESSION['name'])); } else { $login_error = "Username or Password is invalid"; header('Content-Type: application/json'); echo json_encode(array('action' => 'login', 'authorized' => false, 'message' => $login_error)); } } catch (PDOException $e) { header('Content-Type: application/json'); echo json_encode(array('action' => 'login', 'authorized' => false, 'message' => $e->getMessage())); } } } } /* * action = logout