Hits : 3451

Contents


MySQL


Παρακάτω θα προχωρήσουμε με την δημιουργία μίας απλής βάσης δεδομένων,
η οποία θα χρησιμοποιηθεί ως μία agenda, ο πίνακας στον οποίο θα αποθηκεύσουμε
τις πληροφορίες μας είναι ο users και η δομή του είναι η εξής:

CREATE TABLE IF NOT EXISTS `friends` (

  `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,

  `name` varchar(25) NOT NULL,

  `lsname` varchar(50) NOT NULL,

  `tel` char(10) NOT NULL,

  PRIMARY KEY  (`id`)

) ;

 

INSERT INTO `agenda`.`friends` VALUES (NULL , 'vag', 'balaskas', '6930000000');

INSERT INTO `agenda`.`friends` VALUES (NULL , 'bal', 'vaggelis', '6970000000');


top

SELECT


select.php

<?php
$host = 'localhost' ;
$port = 3306; 
$user = 'root' ;
$pass = '';
$db   = 'agenda';
$tb   = 'friends';

$link = mysql_connect( $host.":".$port, $user, $pass);
if ( $link != 0 ) {

mysql_select_db($db) or die('Could not select database');

// Performing SQL query
$query = 'SELECT * FROM '.$tb;
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Printing results in HTML
print("<p align='center'>Results : </p>");
echo "<p align='center'><table cellpadding='5' cellpadding='0' border='1'>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    echo "\t<tr>\n";
    foreach ($line as $col_value) {
        echo "\t\t<td>$col_value</td>\n";
    }
    echo "\t</tr>\n";
}
echo "</table></p>\n";

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
}else{
 echo "failed";
}
?>


top

INSERT


insert.php

<FORM method="POST">
<table>
<TR>
 <TD>Give Name</TD>
 <TD><INPUT type="text" name="name"></TD>
</TR>
<TR>
 <TD>Give Last Name</TD>
 <TD><INPUT type="text" name="sname"></TD>
</TR>
<TR>
 <TD>Give Tel</TD>
 <TD><INPUT type="text" name="tel"></TD>
</TR>
<tr><TD colspan="2"><INPUT type="reset" value="Clear">&nbsp;&nbsp;<input type="submit" value="Insert"></TD></tr>
</table>
</FORM>

<?php
$host = 'localhost' ;
$port = 3306; 
$user = 'root' ;
$pass = '';
$db   = 'agenda';
$tb   = 'friends';

$link = mysql_connect( $host.":".$port, $user, $pass);
if ( $link != 0 ) {

mysql_select_db($db) or die('Could not select database');

// Performing SQL query
if ( ( !empty ( $_POST['name'] ) ) && ( !empty ( $_POST['sname'] ) ) && ( !empty ( $_POST['tel'] ) ) ) {
  $query = "INSERT INTO ".$tb." VALUES (NULL, '".$_POST['name']."', '".$_POST['sname']."', '".$_POST['tel']."');";
  mysql_query($query) or die('Query failed: ' . mysql_error());
}

$query = 'SELECT * FROM '.$tb;
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Printing results in HTML
echo "<table border=1>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    echo "\t<tr>\n";
    foreach ($line as $col_value) {
  echo "\t\t<td>$col_value</td>\n";
    }
    echo "\t</tr>\n";
}
echo "</table>\n";

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
}else{
 echo "failed";
}
?>


top

SEARCH 


<FORM method="POST">
<table>
<TR>
 <TD>Give Name</TD>
 <TD><INPUT type="text" name="name"></TD>
</TR>
<tr><TD colspan="2"><INPUT type="reset" value="Clear">&nbsp;&nbsp;<input type="submit" value="search"></TD></tr>
</table>
</FORM>

<?php
$host = 'localhost' ;
$port = 3306; 
$user = 'root' ;
$pass = '';
$db   = 'agenda';
$tb   = 'friends';

$link = mysql_connect( $host.":".$port, $user, $pass);
if ( $link != 0 ) {

mysql_select_db($db) or die('Could not select database');

// Performing SQL query
if ( ( !empty ( $_POST['name'] ) ) )
  $query = "SELECT * FROM ".$tb . " WHERE name LIKE '%" . $_POST['name'] . "%'; ";
else
  $query = 'SELECT * FROM '.$tb;

$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Printing results in HTML
echo "<table border=1>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    echo "\t<tr>\n";
    foreach ($line as $col_value) {
  echo "\t\t<td>$col_value</td>\n";
    }
    echo "\t</tr>\n";
}
echo "</table>\n";

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
}else{
 echo "failed";
}
?>


top