Forum PHP.pl

[SQL] pobierz, plaintext 
CURDATE() 
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
WHERE date > CURDATE()
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
RewriteRule ^([a-zA-Z0-9_-]+)/([a-zA-Z0-9_-]+)/?$ index.php?url=$1&zmienna=$2 [QSA]
 
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
class Connection
{
    private static $instance;
    public static function getInstance(){
 
        if(!self::$instance){
            try {
                self::$instance = new PDO("mysql:host=$host;", 'root', 'haslo');
                return self::$instance;
            }catch (Exception $Error){
                echo 'Error has been detected:';
                die('Error has been detected: ' . $Error->getMessage());
            }
        }
    }
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
 
class Server
 
{
 
    private $_db;
 
    public static $instance;
 
    public function __construct(){
 
        $this->_db = Connection::getInstance();
 
    }
 
    public function selectAbleSkills(){
 
        $query = $this->_db->prepare("SELECT * FROM skill_type");
 
        $query->execute();
 
        return $query;
 
    }
 
    public static function getInstance()
 
    {
        if(self::$instance === null)
        {
            self::$instance =  new self();
        }
        return self::$instance;
    }
 
 
 
}
[PHP] pobierz, plaintext 

[HTML] pobierz, plaintext 
<meta name="viewport" content="width=device-width, initial-scale=1">
 
[HTML] pobierz, plaintext 

[PHP] pobierz, plaintext 
 
class AutoLoad
{
    private $path;
 
    public function __construct($path)
    {
        $this->path = $path;
        spl_autoload_register(array($this, 'load'));
    }
 
    function load($file)
    {
        if (is_file($this->path . '/' . $file . '.php')) {
            require_once($this->path . '/' . $file . '.php');
        }
    }
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
new AutoLoader('app/class');
[PHP] pobierz, plaintext 

[HTML] pobierz, plaintext 
<script src="jquery.js"></script>
[HTML] pobierz, plaintext 

[PHP] pobierz, plaintext 
[0].click();
[PHP] pobierz, plaintext 

Cytat(koszyq @ 29.07.2015, 14:26:49 )

[PHP] pobierz, plaintext 
   <form action="" method="post">
First name:<br>
<input type="text" name="firstname" value="Mickey">
<br>
Last name:<br>
<input type="text" name="lastname" value="Mouse">
<br><br>
<input type="submit" value="submit">
</form>
<?
 if (isset($_POST["submit"])){
     echo 'wyslany';
 
 
 
 }
   if (empty($_POST["submit"])){
     echo 'pusty';
 
 
 
 }   ?>
[PHP] pobierz, plaintext 

[HTML] pobierz, plaintext 
<input type="submit" value="submit">
[HTML] pobierz, plaintext 

[HTML] pobierz, plaintext 
<input type="submit" value="submit" name="submit">
[HTML] pobierz, plaintext 

Cytat(Basia555 @ 2.07.2015, 22:27:03 )

[PHP] pobierz, plaintext 
if($_GET['action'] == 'edit' && $_GET['ID'])
{
 if(mysql_query("DELETE FROM cennik_uslug WHERE ID = ".$_GET['ID']))
 {
  echo 'usunieto';
 }
 else
 {
  echo 'blad';
 }
}
else{
 
$wynik = mysql_query('SELECT * FROM cennik_uslug') 
or die('Błąd zapytania'); 
 
echo '<table>
        <tr class = "header">
				   <th>ID</th>
				   <th>Nazwa usługi</th>
					 <th>Cena za metr</th>
					 <th>Cena za pkt/mb</th>
				</tr>';
while($row = mysql_fetch_array($wynik)) {
     echo "<tr>
		          <td>{$row['ID']}</td>
							<td>{$row['Nazwa_uslugi']}</td>
							<td>{$row['Cena_za_metr']}</td>
							<td>{$row['Cena_za_pktmb']}</td>";
 
		echo '<td><a href="?action=edit&ID='.$row['ID'].'">usun</a></td>';	
 
 
 
 
			echo "</tr>";
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
php]if($_GET['action'] == 'edit' && $_GET['ID'])
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
if(isset($_GET['action']) == 'edit' && isset($_GET['ID']))
[PHP] pobierz, plaintext