|
| |
|
|
| |
для: odindvatri
(19.07.2012 в 12:59)
| | | помогите! | |
| |
|
|
| |
|
|
| |
для: cheops
(18.07.2012 в 21:36)
| | | <html>
<head>
<title>
key
</title>
</head>
<body>
<?php
function mysqlcon() {
$db = mysql_connect ("localhost","root","");
mysql_select_db ("baza",$db);
}
if ($_POST['submit1'] == 'OK' ) {
$rez = $_POST['resultat'];
$num1 = $_POST['number1'];
$num2 = $_POST['number2'];
$num3 = $_POST['number3'];
$num4 = $_POST['number4'];
$znak = $_POST['znak'];
$znak2 = $_POST['znak2'];
$znak3 = $_POST['znak3'];
if ($znak == 1 && $znak2 == 3 && $znak3 == 5) {
$proverka = $num1 + $num2 + $num3 + $num4;
}
if ( $znak == 2 && $znak2 == 4 && $znak3 == 6) {
$proverka = $num1 - $num2 - $num3 - $num4;
}
if ($znak == 1 && $znak2 == 3 && $znak3 == 6) {
$proverka = $num1 + $num2 + $num3 - $num4;
}
if ($znak == 1 && $znak2 == 4 && $znak3 == 5) {
$proverka = $num1 + $num2 - $num3 + $num4;
}
if ($znak == 1 && $znak2 == 4 && $znak3 == 6) {
$proverka = $num1 + $num2 - $num3 - $num4;
}
if ($znak == 2 && $znak2 == 3 && $znak3 == 5) {
$proverka = $num1 - $num2 + $num3 + $num4;
}
if ($znak == 2 && $znak2 == 3 && $znak3 == 6) {
$proverka = $num1 - $num2 + $num3 - $num4;
}
if ($znak == 2 && $znak2 == 4 && $znak3 == 5) {
$proverka = $num1 - $num2 - $num3 + $num4;
}
if ($proverka == $rez) {
echo 'PRAVILNO';
}
} else {
echo 'NE PRAVILNO';
}
mysqlcon();
$query = "SELECT * FROM mydb";
$num_rows = mysql_num_rows($res);
$res = mysql_query($query);
if(!$db) exit("Ошибка");
if(mysql_num_rows($res)) {
echo '<table>';
while($row = mysql_num_rows($res)){
echo '<tr>';
echo "<td>id</td>";
echo $row['id'];
echo "<td>data</td>";
echo $row['data'];
echo "<td>vopros</td>";
echo $row['vopros'];
echo "<td>otvet</td>";
echo $row['otvet'];
echo "<td>pravilno</td>";
echo $row['pravilno'];
echo "<td>resultat</td>";
echo $row['resultat'];
echo '</tr></table>';
}
} else {
$a=rand(1,20);
$b=rand(1,20);
$x=rand(1,20);
$y=rand(1,20);
$c=rand(1,2);
$q=rand(3,4);
$w=rand(5,6);
if ($c == 1) $znak = '+';
if ($c == 2) $znak = '-';
if ($q == 3) $znak2 = '+';
if ($q == 4) $znak2 = '-';
if ($w == 5) $znak3 = '+';
if ($w == 6) $znak3 = '-';
echo "<h2>$a $znak $b $znak2 $x $znak3 $y= </h2>";
?>
<form action="key.php" method="post"/>
Введите результат:
<input type="text" name="resultat" />
<input type="submit" name="submit1" value="OK"/>
<input type="hidden" name="number1" value="<?php echo $a; ?>"/>
<input type="hidden" name="number2" value="<?php echo $b; ?>"/>
<input type="hidden" name="number3" value="<?php echo $x; ?>"/>
<input type="hidden" name="number4" value="<?php echo $y; ?>"/>
<input type="hidden" name="znak" value="<?php echo $c; ?>"/>
<input type="hidden" name="znak2" value="<?php echo $q; ?>"/>
<input type="hidden" name="znak3" value="<?php echo $w; ?>"/>
</form>
</body>
</html>
<?php
}
?>
вот с помощью table
Notice: Undefined variable: res in C:\xampp\htdocs\test\key.php on line 56
Warning: mysql_num_rows() expects parameter 1 to be resource, null given in C:\xampp\htdocs\test\key.php on line 56
Notice: Undefined variable: db in C:\xampp\htdocs\test\key.php on line 58
Ошибка
ошибка здесь $num_rows = mysql_num_rows($res);
что не так зделано? | |
| |
|
|
| |
|
|
| |
для: odindvatri
(18.07.2012 в 12:27)
| | | Так у вас же вроде есть таблица mybd? Или в выборке еще таблица участвует? | |
| |
|
|
| |
|
|
| |
для: cheops
(18.07.2012 в 05:43)
| | | Mysql | |
| |
|
|
| |
|
|
| |
для: odindvatri
(17.07.2012 в 18:47)
| | | Под таблицей имеется в виду MySQL-таблица или HTML-таблица? | |
| |
|
|
| |
|
|
| |
для: cheops
(16.07.2012 в 18:00)
| | | а как с помощью таблицы? | |
| |
|
|
| |
|
|
| |
для: odindvatri
(16.07.2012 в 14:57)
| | | Вам потребуется совершенно другой код, какой-то такой
<?php
...
$query = "SELECT * FROM mybd";
$mdb = mysql_query($query);
if(!$mdb) exit("Ошибка выполнения запроса");
if(mysql_num_rows($mdb))
{
while($result = mysql_fetch_array($mdb))
{
echo "<pre>";
print_r($result);
echo "</pre>";
}
}
...
?>
|
| |
| |
|
|
| |
|
|
| | как вывести таблицу из БД?
SELECT FROM mybd; куда вставить?
<html>
<head>
<title>
key
</title>
</head>
<body>
<?php
function mysqlcon() {
$db = mysql_connect ("localhost","root","");
mysql_select_db ("baza",$db);
}
if ($_POST['submit1'] == 'OK' ) {
$rez = $_POST['resultat'];
$num1 = $_POST['number1'];
$num2 = $_POST['number2'];
$num3 = $_POST['number3'];
$num4 = $_POST['number4'];
$znak = $_POST['znak'];
$znak2 = $_POST['znak2'];
$znak3 = $_POST['znak3'];
if ($znak == 1 && $znak2 == 3 && $znak3 == 5) {
$proverka = $num1 + $num2 + $num3 + $num4;
$proverka2 = (string) $num1 .'+'. $num2 .'+'. $num3 .'+'. $num4;
}
if ( $znak == 2 && $znak2 == 4 && $znak3 == 6) {
$proverka = $num1 - $num2 - $num3 - $num4;
$proverka2 = (string) $num1 .'-'. $num2 .'-'. $num3 .'-'. $num4;
}
if ($znak == 1 && $znak2 == 3 && $znak3 == 6) {
$proverka = $num1 + $num2 + $num3 - $num4;
$proverka2 = (string) $num1 .'+'. $num2 .'+'. $num3 .'-'. $num4;
}
if ($znak == 1 && $znak2 == 4 && $znak3 == 5) {
$proverka = $num1 + $num2 - $num3 + $num4;
$proverka2 = (string) $num1 .'+'. $num2 .'-'. $num3 .'+'. $num4;
}
if ($znak == 1 && $znak2 == 4 && $znak3 == 6) {
$proverka = $num1 + $num2 - $num3 - $num4;
$proverka2 = (string) $num1 .'+'. $num2 .'-'. $num3 .'-'. $num4;
}
if ($znak == 2 && $znak2 == 3 && $znak3 == 5) {
$proverka = $num1 - $num2 + $num3 + $num4;
$proverka2 = (string) $num1 .'-'. $num2 .'+'. $num3 .'+'. $num4;
}
if ($znak == 2 && $znak2 == 3 && $znak3 == 6) {
$proverka = $num1 - $num2 + $num3 - $num4;
$proverka2 = (string) $num1 .'-'. $num2 .'+'. $num3 .'-'. $num4;
}
if ($znak == 2 && $znak2 == 4 && $znak3 == 5) {
$proverka = $num1 - $num2 - $num3 + $num4;
$proverka2 = (string) $num1 .'-'. $num2 .'-'. $num3 .'+'. $num4;
}
if ($proverka == $rez) {
echo "<div style=\"color:green;\"><h3>$rez - PRAVIL`NO<h3></div>";
$resultatik = 'Y';
} else {
echo "<div style=\"color:red;\"><h3>$rez - NE PRAVIL`NO<h3></div>";
$resultatik = 'N';
}
mysqlcon();
$sql = "INSERT INTO`baza`.`mybd` (`id` , `data` , `vopros` , `otvet` , `pravilno` , `resultat` ) VALUES (
NULL ,NOW(),'".$proverka2."','".$rez."','".$proverka."','".$resultatik."'
);
";
echo '<pre>'.$sql.'</pre>';
if (mysql_query($sql)) {
echo 'SAVED';
} else {
echo 'ERROR';
}
} else {
$a=rand(1,20);
$b=rand(1,20);
$x=rand(1,20);
$y=rand(1,20);
$c=rand(1,2);
$q=rand(3,4);
$w=rand(5,6);
if ($c == 1) $znak = '+';
if ($c == 2) $znak = '-';
if ($q == 3) $znak2 = '+';
if ($q == 4) $znak2 = '-';
if ($w == 5) $znak3 = '+';
if ($w == 6) $znak3 = '-';
echo "<h2>$a $znak $b $znak2 $x $znak3 $y= </h2>";
?>
<form action="key.php" method="post"/>
Введите результат:
<input type="text" name="resultat" />
<input type="submit" name="submit1" value="OK"/>
<input type="hidden" name="number1" value="<?php echo $a; ?>"/>
<input type="hidden" name="number2" value="<?php echo $b; ?>"/>
<input type="hidden" name="number3" value="<?php echo $x; ?>"/>
<input type="hidden" name="number4" value="<?php echo $y; ?>"/>
<input type="hidden" name="znak" value="<?php echo $c; ?>"/>
<input type="hidden" name="znak2" value="<?php echo $q; ?>"/>
<input type="hidden" name="znak3" value="<?php echo $w; ?>"/>
</form>
</body>
</html>
<?php
}
?> | |
| |
|
|
|
