PHP - Pulling A Set Of Information From A Database

Below are two pages...Post.php. and Posted.php the posted page checks and makes sure everything is filled out and makes sure that the link has not been already added. The problem I am having is that it is not pulling over the link information. Every time you hit submit it drops down and goes to saying that you forgot to fill something in and I have it showing everything right now so when that happens I can see what is not going through and the $link never comes through. Any ideas? if anyone needs a better explanation please post and I will try to explain better....basically I am trying to post and everything posts but the link.

POST.PHP
Code: [Select]
<h1>Post</h1>
<div class="descr"></div><form method="post" action="posted.php">
          <table align="center">
<tr>
            <td>
                    Youtube Embed Link
                    </td>
                    <td>
                    <input name="link" type="text" id="link"/>
                    </td>
                </tr>   
                <tr>
                <td>
                  Title Of Song
                    </td>
                    <td>
                    <input name="title" type="text" id="title" />
                    </td>
                </tr>
                <tr>
                <td>
                    Author
                    </td>
                    <td>
                    <input name="author" type="text" id="author" />
                    </td>
                </tr>
                <tr>
            <td>
                    Text:
                    </td>
                    <td>
                    <input name="information" type="text" id="information" />
                        <br />
                    </td>
                </tr>
                <tr>
                <td colspan="2" align="center">
                    <br>
                    <input name="submit" type="submit" value="Post" />
                    </td>
                </tr>               
            </table>
            </form>
POSTED.PHP
Code: [Select]
<?php
//msut be logged in page
session_start();

if  ($_SESSION['username'])
{
echo"";
}
else
die("You must log in first!");

//form information
$submit = $_POST['submit'];
$row4 = $_SESSION['username'];

// form data
$link = strip_tags($_POST['link']);
$information = strip_tags($_POST['information']);
$title = strip_tags($_POST['title']);
$author = strip_tags($_POST['author']);
$date = date('Y-m-d');


 //Connect To Database
$hostname='';
$username2='';
$password2='';
$dbname='';

  mysql_connect($hostname,$username2, $password2) OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db($dbname);
$querycheck = "SELECT * FROM videos WHERE username='$row4'";
$result = mysql_query($querycheck);
while($rowz = mysql_fetch_array($result))

$linkcheck = $rowz['link'];


if ($submit)
{
if ($link&&$information&&$title&&$author)
{
if ($link == $linkcheck)
{
die ("This link has already been posted.");
}
else

{


 //Connect To Database
$hostname='';
$username2='';
$password2='';
$dbname='';

 mysql_connect($hostname,$username2, $password2) OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db($dbname);
$queryreg = mysql_query("INSERT INTO videos Values ('','$row4','$link','$title','$author','$information','$date')");




}
}

else
{
die ("You forgot to put something in the link/title/author/text box.  $information $title $link $author");
     }

}


   


?>

Hey all!. I was wondering if there was a way to process information from major websites using php? It seems I am running into issues.

Here is what I am trying to do:

I need to pull the full list of companies from pinksheets.com that are listed on the exchanges. I can download the list via XLS format, but I need to do this for all the exchange websites such as nasdaq etc.

Is there a way to do this where I can comb for the information such as CEO name, ticker , company name and any companies that get taken off or added to the list? The lists I am already talking about are on the sites I mentioned and you can look them up but I am adding 40,000+ companies to my site it manually entering them would be a huge issue,.

Do any of you have any fixes? Sorry if this is in the wrong section.

Thanks!.

Smash.

Hiya peeps,

I have been sent this today;

select company_map.*, map.*,addresses.address,addresses.nomitative,addresses.number, c.postcode from company_map join map on map.id=company_map.map_id join company c on c.company_id=company_map.company_id join addresses on addresses.address_id=c.address_id where company_map.company_id='79' and company_map.ui_shell_id <> 0 and language_id='en'

when I print all the results from this I get a postcode, I was wondering if anyone could read this code and simplify it for me, I really need to know what table this query is pulling the postcode from.

Many many thanks,

James.

So I'm having issue with trying to pull the ID from my database out correctly.
This is the ideal way I want the ID to be pulled.

http://a7.sphotos.ak.fbcdn.net/hphotos-ak-snc6/226659_219275201434540_100000561868489_827151_3402533_n.jpg

But then it always pulls the ID like this and stacks the number ID ontop of each other and I want it to have separate DIVS.

http://photos-e.ak.fbcdn.net/hphotos-ak-snc6/226659_219275204767873_100000561868489_827152_3422285_n.jpg

This is the code that I'm using. Tell me what I'm doing wrong.

Code: [Select]
<?
mysql_connect("localhost", "mysql_user", "mysql_password") or
    die("Could not connect: " . mysql_error());
mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

echo "<div class=\"body_resize\"><div class=\"left\"><br /><span class='date'>$timedate</span><br /><br />";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    printf("<h2>#%s</h2>", $row["id"], $row["name"]);
}

mysql_free_result($result);

echo "<br /><div class=\"comment_gravatar left\"><img alt=\"\" src=\"http://photos-b.ak.fbcdn.net/hphotos-ak-snc6/229186_219276548101072_100000561868489_827154_8135363_n.jpg\" height=\"32\" width=\"32\" /></div><p>Posted By $name<br><br /><p>$message</p><br></div><div class=\"clr\"></div></div>";
if ($ip==$userip && $delcom==1) {
?>

Good evening,

This has been bugging me for 24 hours now. I have created 2 web applications. The first one is the dummy, and the second one is the final. Basically, this two web applications does the same, just a few modifications made on the final one. I have a process of pulling out of information from the database should the user would want to modify a field. I have a problem though, the dummy one works perfectly, but the new one don't. In fact, if I use the dummy php file together with the new files, the dummy won't be working. But if I use it together with the old files, it works perfectly fine.

This is the error I am getting:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\invent-asia\edit_client.php on line 46

<?php
include("dbconnection.php");

if(isset($_POST["btnSubmit"]))
{
$id = $_POST["id"];
$territory = $_POST["territory"];
$job_title = $_POST["job_title"];
$area_of_work = $_POST["area_of_work"];
$employer = $_POST["employer"];
$location = $_POST["location"];
$job_title = $_POST["job_title"];
$date_posted = $_POST["date_posted"];
$closing_date = $_POST["closing_date"];
$department = $_POST["department"];
$gender = $_POST["gender"];
$first_name = $_POST["first_name"];
$last_name = $_POST["last_name"];
$title = $_POST["title"];
$telephone = $_POST["telephone"];
$address_1 = $_POST["address_1"];
$address_2 = $_POST["address_2"];
$address_3 = $_POST["address_3"];
$country = $_POST["country"];
$city = $_POST["city"];
$postal_code = $_POST["postal_code"];
$website = $_POST["website"];
$email_address = $_POST["email_address"];
$comment_by_cg = $_POST["comment_by_cg"];
$date_emailed = $_POST["date_emailed"];
$mailing_comments = $_POST["mailing_comments"];
$telesales_comments = $_POST["telesales_comments"];

$query = "UPDATE contacts SET territory= '".$territory."', job_title = '".$job_title."', area_of_work = '".$area_of_work."', employer = '".$employer."', location = '".$location."', job_title = '".$job_title."', employer = '".$employer."', date_posted = '".$date_posted."', department = '".$department."', closing_date = '".$closing_date."', gender = '".$gender."', first_name = '".$first_name."', last_name = '".$last_name."', title = '".$title."', telephone = '".$telephone."', address_1 = '".$address_1."', address_2 = '".$address_2."', address_3 = '".$address_3."', country = '".$country."', city = '".$city."', postal_code = '".$postal_code."', website = '".$website."', email_address = '".$email_address."', comment_by_cg = '".$comment_by_cg."', date_emailed = '".$date_emailed."', mailing_comments = '".$mailing_comments."', telesales_comments = '".$telesales_comments."' WHERE id = '".$id."'";
mysql_query($query) or die(mysql_error());

echo "<script>
alert('You have successfully updated a record');
window.location = 'view.php';
</script>";
}

$query = "SELECT * FROM contacts WHERE id = '".$_GET["id"]."'";
$result = mysql_query($query, $connection);

if(mysql_num_rows($result) > 0) - THIS IS THE 46th LINE IN THE CODE
{
$territory = mysql_result($result,0, "territory");
$job_title = mysql_result($result, 0, "job_title");
$area_of_work = mysql_result($result, 0, "area_of_work");
$employer = mysql_result($result, 0, "employer");
$status = mysql_result($result, 0, "status");
$location = mysql_result($result,0, "location");
$department = mysql_result($result,0, "department");
$date_posted = mysql_result($result,0, "date_posted");
$closing_date = mysql_result($result,0, "closing_date");
$gender = mysql_result($result,0, "gender");
$first_name = mysql_result($result,0, "first_name");
$last_name = mysql_result($result,0, "last_name");
$title = mysql_result($result,0, "title");
$telephone = mysql_result($result,0, "telephone");
$address_1 = mysql_result($result,0, "address_1");
$address_2 = mysql_result($result,0, "address_2");
$address_3 = mysql_result($result,0, "address_3");
$city = mysql_result($result,0, "city");
$country = mysql_result($result,0, "country");
$postal_code = mysql_result($result,0, "postal_code");
$website = mysql_result($result,0, "website");
$email_address = mysql_result($result,0, "email_address");
$comment_by_cg = mysql_result($result,0, "comment_by_cg");
$date_emailed = mysql_result($result,0, "date_emailed");
$mailing_comments = mysql_result($result,0, "mailing_comments");
$telesales_comments = mysql_result($result,0, "telesales_comments");
}
?>

Can anyone help me solve this issue? This is the only feature in my project that is left bugged

Your quick response is well appreciated. Thank you very much

Code: [Select]
<?php
ob_start();
session_start();
$pagerank=2; 
if ($rank < $pagerank){
header('Location:main.php?id=lowrank.php');
}
else{
$name1 = $_GET["name"];
$type2 = $_GET['type'];

Echo "Your seach for ".$name1." gave the following results: ";

$records_per_page = 15;
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM systems WHERE '$type2' LIKE '%$name1%'"), 0) or die(mysql_error());
$page_count = ceil($total / $records_per_page);
Echo $total." Records Found";
echo "<table border=0>";


$page = 1;
if (isset($_GET['page']) && $_GET['page'] >= 1 && $_GET['page'] <= $page_count) {
    $page = (int)$_GET['page'];
}
$skip = ($page - 1) * $records_per_page;

$result = mysql_query("SELECT * FROM systems WHERE $type2 LIKE '%$name1%' ORDER BY Security DESC LIMIT $skip, $records_per_page") or die(mysql_error()); 

echo "<table border=1>";
echo "<td>System Name</td><td>Security</td><td>Class</td>";
while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td valign =top>".$row['System Name']."</td>";
echo "<td valign =top>".round($row['Security'],1)."</td>";
echo "<td valign =top>".$row['System Type']."</td>";
echo "</tr>";
}
echo "</table>";
echo "<br>";
for ($i = 1; $i <= $page_count; ++$i) {
    echo '<a href="main.php?id=' . $_GET['id'] .'&name='.$name1.'&type='.$type1. '&page=' . $i . '">'
        . $i . '</a> ';
}
}
?>
The above code takes data entered in a form and is suppose to show the matching results, but no records are showing, it works when I replace the $name1 and $type2 with the actual values, any ideas?

Right now I am using code such as this:

$query = "SELECT somevalue FROM sometable WHERE id=1"
$result = mysql_query($update) or die ('Error in query: ' . mysql_error());

$somevalue = '';

if (mysql_num_rows($result) == 1)
  {
  while($row = mysql_fetch_assoc($userstatsresult))
    {
    $somevalue = $row['somevalue'];
    }
  }

echo $somevalue;

Is there a short-hand method to get that single value without the IF/WHILE stuff?

Unfortunately I have no code for this yet cuz I don;t even know if its possible...

I am programming an application that is used by a couple of stores, which could end up being a lot of stores.

Anyways, the basis is that the stores would, though a separate application (and therefore separate database) create a username and password, I now want to use this username and password to do the following

1. Allow them to login to my application using the same username and password
2. I want the store the username in a session to pull tables based on the username from my database

For instance, a user has the login store123, after loggin in it now pulls the information from the tables store123_items, store123_prices, store123_settings, etc. Now my database will have quite a lot of store###_tables

I am, sadly, a noobie to PHP and I do recall seeing an article (somewhere on the net, and I stupidly forgot to bookmark it, knowing I would need it eventually) on how to access multiple databases easily.  Now because they are both under my account I can use the same username and password for both, its accessing the MySQL username/password database and storing the info I know I am lacking on how to do it.

Any ideas?

Hi,

I have a table that contains posts and each post has a datetime field.

Im trying to work out how I can show entries from today, this week and this month so I can have a link that shows all posts from today or this month etc.

Any one know how I can do this ? My current piece of code that pulls the data from the db looks like this :

Code: [Select]
$texts= mysql_query("SELECT * FROM submittedtexts Order by id DESC LIMIT " . (($page - 1) * 6) . ", 6");
I want to add a bit that acts like : WHERE date = today


Hope that makes sense, Im a bit of a newbie

Thanks in advance,

Scott

Hi there I would be most grateful is someone could tell me why my data is not being entered into my database and not responding with an email confirmation link. Thanks in advance.



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?
include('config.php');

// table name 
$tbl_name="temp_members_db";

// Random confirmation code 
$confirm_code=md5(uniqid(rand())); 

// values sent from form 
$name=$_POST['name'];
$email=$_POST['email'];
$country=$_POST['country'];

// Insert data into database 
$sql="INSERT INTO $tbl_name(confirm_code,name,email,password,country) VALUES('$confirm_code','$name','$email','$password','$country')";
$result=mysql_query($sql);

// if suceesfully inserted data into database, send confirmation link to email 
if($result){

// ---------------- SEND MAIL FORM ----------------

// send e-mail to ...
$to=$email;

// Your subject
$subject="Your confirmation link here";

// From
$header="from: your name <your email>";

// Your message
$message="Your Comfirmation link \r\n";
$message.="Click on this link to activate your account \r\n";
$message.="http://www.yourweb.com/confirmation.php?passkey=$confirm_code";

// send email
$sentmail = mail($to,$subject,$message,$header);

}

// if not found 
else {
echo "Not found your email in our database";
}

// if your email succesfully sent
if($sentmail){
echo "Your Confirmation link Has Been Sent To Your Email Address.";
}
else {
echo "Cannot send Confirmation link to your e-mail address";
}

?>
</body>
</html>

I have these two files and I need to solve the problem that I need the user data in the role column to be taken when logging in. I have written it so that the data can be extracted from the database, but it does not work for me that it is “forwarded” from process.php to admin.php . Please don’t know what the error is that the admin.php file doesn’t want to load $ _SESSION['Role'] from process.php ? Thanks to everyone for helping and here is the code:

process.php

<?php 
require_once('connect.php');
session_start();
    if(isset($_POST['Login']))
    {
       if(empty($_POST['Username']) || empty($_POST['Password']))
       {
            header("location:index.php?Empty= Please Fill in the Blanks");
       }
       else
       {
            $query="select * from role_test where Username='".$_POST['Username']."' and Password='".md5($_POST['Password'])."'";
            $result=mysqli_query($con,$query);

            if(mysqli_fetch_assoc($result))
            {
                $_SESSION['User']=$_POST['Username'];

                while($row = mysqli_fetch_array($result) ){
                $_SESSION['Role']=$row['role'];
                }

                header("location:admin.php");
            }
            else
            {
                header("location:index.php?Invalid= Please Enter Correct User Name and Password ");
            }
       }
    }
    else
    {
        echo 'Not Working Now Guys';
    }

?>

 

admin.php

<?php
    session_start();

    if(!(isset($_SESSION['User'])))
    {
        header("Location: index.php");
        exit(0);
    }	  

?>
<!DOCTYPE html>
<html>
<head>
<title>Role</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<body>
<?php
$_SESSION['Role']=$role;

echo $role;

?>

</body>
</html>

 

 

 

Hello,
I recently came upon this website and I want to implement something similar. The 'remove' box is what I would like to do with PHP. I have no idea where to start. I would like to be able to search through my database, select one of its components and add it to that window. Within that window I would also like to be able to remove it. Does anyone know where I should go from there?


here is the site:
http://www.sealandserpent.org/schedgen/schedulegenerator.php

information not posting into the database the code below is the check code/insert code. Please if anyone knows why let me know.

Code: [Select]
[color=red]<?php
//msut be logged in page
session_start();

if  ($_SESSION['username'])
{
echo"";
}
else
die("You must log in first!");

//form information
$submit = $_POST['submit'];
$row4 = $_SESSION['username'];

// form data
$link = strip_tags($_POST['link']);
$message = strip_tags($_POST['message']);
$title = strip_tags($_POST['title']);
$author = strip_tags($_POST['author']);
$date = date('Y-m-d');


$connect = mysql_connect("db","username","password") or die("Not connected");
mysql_select_db("username") or die("could not log in");
$querycheck = "SELECT * FROM boox WHERE username='$row4'";
$result = mysql_query($querycheck);
while($rowz = mysql_fetch_array($result))

$linkcheck = $rowz['link'];


if ($submit)
{
if($link&$title&$author)
{
// check username and subject lentgh
if ($linkcheck == $link)
{
die ("This link has already been posted.");
}
else

{
//open database
$connect = mysql_connect("db","username","password") or die("Not connected");
mysql_select_db("username") or die("could not log in");
$queryreg = mysql_query("INSERT INTO boox Values ('','$row4','$link','$title','$author','$message','$date')");
echo "You have just officialy posted on the Catalina Beat Mixers. ";

}

}

}
   
else
{
die ("You forgot to put something in the link/title/author box.");
    }


?>[/color]
[code]

Hi all,

Does anyone know if it's possible to generate a dropdown list filled with database information.
I use the following to get the information from the database:
$query                      = "SELECT Name
                               FROM city
                               WHERE member_ID = '$member_ID'";
$result                     = mysql_query($query)
                              or die(mysql_error());
while($row = mysql_fetch_assoc($result))
{
     echo $row['Name'] . '<br>';
}

Thnx Ryflex