Jump to content

JankaZ

Members
 View Profile  See their activity

  • Posts

    30

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by JankaZ

    Plzz help with vote script

    in PHP Coding Help

    Posted

    Can someone please help with vote script. I pres button and vote for song and its count to thats song id!

     

    <table border=1>
  <tr>
   <th>Nr</th>
   <th>Albums</th>
   <th>Izpilditajs</th>
   <th>Dziesma</th>
  </tr>

<?php
$con = mysql_connect("localhost","root","1991jz9969470");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("top", $con);
//Izveido query
$query = mysql_query("select * from top");

//dabu visus datus no db 
while ($row = mysql_fetch_array($query)){

$id = $row['id'];
$albums = $row['albums'];
$izpilditajs = $row['izpilditajs'];
$dziesma = $row['dziesma'];

?>

  <tr>
   <th><?php echo $id;?></th>
   <th><?php echo $albums;?></th>
   <th><?php echo $izpilditajs;?></th>
   <th><?php echo $dziesma;?></th>
  </tr>

<?php } //If beigu zime ?>

    check if its not in db

    in PHP Coding Help

    Posted

    How ken i make to script chect a song if its nat in db if its is than drop error song alredy exist!

    Albums=album

    dziesma=song

    izpilditajs=artis

    And i nide to check if posted song nat in db else post error song alredy posted.

    PLZZZ help.

    <?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("top", $con);

$sql="INSERT INTO top (albums, izpilditajs, dziesma)
VALUES
('$_POST[albums]','$_POST[izpilditajs]','$_POST[dziesma]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Paldies tava dziesma ir pievienota.";

mysql_close($con)
?>

    Get line from php

    in PHP Coding Help

    Posted

    Jes its like I nide! But how ken i put to echo only 10 lines!

     

    <?php
// Get a file into an array.  In this example we'll go through HTTP to get
// the HTML source of a URL.
$lines = file('http://www.example.com/');

// Loop through our array, show HTML source as HTML source; and line numbers too.
foreach ($lines as $line_num => $line) {
    echo "Line #<b>{$line_num}</b> : " . htmlspecialchars($line) . "<br />\n";
}

// Another example, let's get a web page into a string.  See also file_get_contents().
$html = implode('', file('http://localhost/bot/'));

// Using the optional flags parameter since PHP 5
$trimmed = file('atbildes.php', FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
?>

    Get line from php

    in PHP Coding Help

    Posted

    Plzz somebody show code how to get for example 10 lines from php file.

    Read line from php file is same like text file.

     

    I how chat bot and it save all talk and i vana echo last 10 lines

    For example:

     

    Me: Hello<br/>

    Bot: Hi<br/>

    Me: how ar you?<br/>

    Bot: Nice!<br/>

    Me: Version<br/>

    Bot: V.1<br/>

    Me: Nice day!<br/>

    Bot: Jes.<br/>

    Me: By.<br/>

    Bot: By!<br/>

     

    And all time show now lines ad i whana echo 10 lines to user ken see!

    Plzz somebody show code or help! :(

    error mysql_fetch_assoc

    in PHP Coding Help

    Posted

    Tnxx Cookie for you! +1 But I am beginer and finde your whine smal mistake

    echo $atbilde['atbilde']
    Behaind you nide to put synatx ; But tnx alot.

    Ken you tel me how to make this

     

    Me: Versija

    Bot: V.1

    Me: Hello

    Bot: Hi

     

    To save a histori and show for example 5~10 posts!

    error mysql_fetch_assoc

    in PHP Coding Help

    Posted

    I corectli place that code?

     

    <form method="post"> 
Jautajums: <input name="jautajums" type="text" /> <input type="submit" value="Jautat" />

<?php
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("db") or die(mysql_error());
$Q = mysql_query("SELECT * FROM bot") or die(mysql_error());  
if($_POST['jautajums']) // vai formas name
{
$Q = mysql_real_escape_string($_POST['jautajums']); // drosiba pirmajaa vietaa
$result= mysql_query("SELECT count(atbilde) AS c, atbilde FROM bot WHERE jautajums = '".$Q."' GROUP BY atbilde");

if($result && mysql_num_rows($result) > 0) { // if the query did not fail, and there was at least 1 row returned
$atbilde = mysql_fetch_assoc($result);
{
echo "Nesapratu jautajumu";
}
{
echo $atbilde['atbilde'];
}
?>

     

    I hawe error with unspected $end! In thats line is only ?>

    error mysql_fetch_assoc

    in PHP Coding Help

    Posted

    Error

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\web\www\bot\bot.php on line 11

     

    Script

    <form method="post"> 
Jautajums: <input name="jautajums" type="text" /> <input type="submit" value="Jautat" />

<?php
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("db") or die(mysql_error());
$Q = mysql_query("SELECT * FROM bot") or die(mysql_error());  
if($_POST['jautajums']) // vai formas name
{
$Q = mysql_real_escape_string($_POST['jautajums']); // drosiba pirmajaa vietaa
$atbilde = mysql_fetch_assoc("SELECT count(atbilde) AS c, atbilde FROM bot WHERE jautajums = '".$Q."' GROUP BY atbilde");
if($atbilde['c'] < 1)
{
echo "Nesapratu jautājumu";
}
else
{
echo $atbilde['atbilde'];
}
}
?>

    Wrong parameter count for mysql_result()

    in PHP Coding Help

    Posted 

    <form method="post"> 
Jautajums: <input name="jautajums" type="text" /> <input type="submit" value="Jautat" />

<?php
$conectdb = mysql_connect("localhost","root","1991jz9969470");
if (!$conectdb)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("db", $conectdb);
$atbilde = mysql_result(mysql_query("SELECT atbilde FROM bot WHERE jautajums='".$_POST['jautajums']."'"));
echo $atbilde;
?>

<br />
<? echo("Tu: $jautajums"); ?>
<br />
<? echo("Bots: $atbilde"); ?>

     

    Plzz help with this error

    jautajums = question

    atbilde      = answer

     

    bot answer

    in PHP Coding Help

    Posted

    I make db bot id | message | return

     

    Conect to db!

     

    And how ken i get answer from db and ask message.

     

    <form method="post">

    message: <input name="message" type="text" /> <input type="submit" value="ask" />

     

    And i write hello he conect to db and serch for answer and if answer is than hello else in db not that answer.

    Plzz somebody giv som example of that script! :(

     

    post limit

    in PHP Coding Help

    Posted

    How ken i show post histori to 10 posts for example!

     

    You: Hello

    Bot: Hi

    You: Nice day

    Bot: Jes

     

    <form method="post"> 
Message: <input name="message" type="text" /> 
<br />

<input type="submit" value="Send Message" />

<?php 
$name =$_POST['name'];
$message =$_POST['message'];
if ( $message == "hello") {
$return = "how are you?";
}
if ($message == "good you?") {
$return = "i am good";
}
if ($message == "good") {
$return = "thats cool";
}
if ($message == "sad") {
$return = "well why are u sad";
}
if ($message == "sad you?") {
$return = "im good, and why so sad?";
}
if ($message == "fine") {
$return = "fine, usually that measn your bored!";
}
if ($message == "fine you?") {
$return = "im good";
} 
?>
<br />
<? echo("$return"); ?>

     

    And ken i store questions and answers in txt file? if ken then how?

     

    Ansver bot

    in Applications

    Posted

    Ken sombodi give script for ansver bot!

     

    I: Hello!

    Bot: Hi!

    I: Where i em?

    Bot: phpfreaks.com!

    I: By

    Bot: Tnx for wisite phpfreaks.com

     

    Pzzzz transfer this topic to php help!

     

    Form example questions and ansvers ken store in ansvers.txt or someor else!

    And if not ansver! He seys I dont got so meny ansvers! :)

    Ansver bot

    in Applications

    Posted

    Ken sombodi give script for ansver bot!

     

    I: Hello!

    Bot: Hi!

    I: Where i em?

    Bot: phpfreaks.com!

    I: By

    Bot: Tnx for wisite phpfreaks.com

     

    Form example questions and ansvers ken store in ansvers.txt or someor else!

    And if not ansver! He seys I dont got so meny ansvers! :)

    Get image form db

    in PHP Coding Help

    Posted

    1.Table Users

    Rows 65kzf2095d984x5koaov.jpg

     

    2.And ken you upgrade my loigin page plzzz

    <?php
if(!empty($_SESSION['LoggedIn']) && !empty($_SESSION['Username']))
{
 ?>
    
    <?php
}
elseif(!empty($_POST['username']) && !empty($_POST['password']))
{
 $username = mysql_real_escape_string($_POST['username']);
    $password = md5(mysql_real_escape_string($_POST['password']));
    
 $checklogin = mysql_query("SELECT * FROM users WHERE Username = '".$username."' AND Password = '".$password."'");
    
    if(mysql_num_rows($checklogin) == 1)
    {
    	 $row = mysql_fetch_array($checklogin);
        $email = $row['EmailAddress'];
        
        $_SESSION['Username'] = $username;
        $_SESSION['EmailAddress'] = $email;
        $_SESSION['LoggedIn'] = 1;
        
    	 echo "<h1>Veiksmīgi</h1>";
        echo "<p>Mēs tevi pārsūtam uz profila lapu.</p>";
        echo "<meta http-equiv='refresh' content='=2;index.php' />";
    }
    else
    {
    	 echo "<h1>Kļūda</h1>";
        echo "<p>Atvaino tavs profils netika atrasts <a href=\"login.php\">Mēģini vēlreiz</a>.</p>";
    }
}
else
{
?>
<form method="post" action="login.php" name="loginform" id="loginform">
<fieldset>
	<label for="username">Tavs lietotajvards</label><br />
        <input type="text" name="username" id="username" /><br />
	<label for="password">Tava parole</label><br />
    <input name="password" type="password" id="password" /><br />
	<input type="submit" name="login" id="login" value="Ienākt" />   <INPUT TYPE="BUTTON" VALUE="Reģistrēties" ONCLICK="window.location.href='register.php'"> 
</fieldset>
</form>
    
   <?php
}
?>

     

    If someone not loged in show login else redirect to home.php

    3.And what i nide to place in home.php if someone not logen in then dont show page but redirect to login.php

    Get image form db

    in PHP Coding Help

    Posted

    Seim error

     

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/lockerz/public_html/projekts/index.php on line 15

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/lockerz/public_html/projekts/index.php on line 16

     

    <?php include "base.php"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">  
<head>  
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />  
<title>Profils</title>
</head>  
<body>
<php
$username=$_SESSION['username'];
// also remember to escape $vars that go into SQL:
$username = mysql_real_escape_string($username);
$sql="SELECT * FROM USERS WHERE username='$username'";
   $result=mysql_query($sql, $db);
while $row=mysql_fetch_array($result))
     {
echo "<img src=".$imgurl."/>";
      }
?>
<p>Sveiks<b> <?=$_SESSION['Username']?><b>. <a href="logout.php">Iziet.</a></p>

    Get image form db

    in PHP Coding Help

    Posted

    Agen ERROR

     

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/lockerz/public_html/projekts/index.php on line 12

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/lockerz/public_html/projekts/index.php on line 13

     

    $sql="SELECT * FROM USERS WHERE username=$username";
   $result=mysql_query($sql, $db);

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.