php database basic - please help

simon999

Hi.
I have installed a membership website and Its all functioning correctly.

I have a script that will release content gradually but its not working at the min due to not being ale to get info from the database.

I have very limited php knowledge but have come to the conclusion that I need a script to query the database.

Am I right in thinking i need to create a common.php file and add the query in there?
and then add include common.php to the page/s or header?

How would I write the script for the query?

Am I right in thinking that I need to get the $signupdate? and the $mysqldate? from the database so that the script can check and calculate the link release date?

I know this is prob a really simple task for you guys on here but I have searched google high and low for a database for dummies guide but to no avail.

I hope someone can help.

If you need anymore info from me, please let me know where I might find it in the software/server etc.

Thanks in advance

halojoy

Hello.
What database you have? MySQL?
You have created any database?
You have created any tables inside that $dbname?

First things first.
So if you have a working database
then it is possible to do scripts to talk with database.

simon999

yes, I have a mysql database.

im not sure if any tables have been created. how would i check?

the site functions normally and it checks login details are correct so i presume that a table has been created for that?

sorry my knowledge is limited.

i dont know about $dbname

yes basically it needs a script to check signupdate and current date. I dont know if there is already a table for this and that i just havent found it yet.

some people have mentioned about common.php being placed in the header or page.

I cant find one on my server but have seen a config.inc.php and a common.inc.php if thats any help.

thankyou for helping me. I know its fustrating working with 'noobs'

EDIT-
I have found a .sql file in the server. Is this the table that is needed?

Table structure for table 'members'

CREATE TABLE @DB_MYSQL_PREFIX@members (
member_id int(11) NOT NULL auto_increment,
login varchar(32) NOT NULL,
pass varchar(32) default NULL,
email varchar(64) default NULL,
name_f varchar(32) NOT NULL default '',
name_l varchar(32) NOT NULL default '',
street varchar(255) default NULL,
city varchar(255) default NULL,
state varchar(255) default NULL,
zip varchar(255) default NULL,
country varchar(255) default NULL,
is_male smallint(6) default NULL,
added datetime NOT NULL default '0000-00-00 00:00:00',
remote_addr varchar(15) default NULL,
data text NOT NULL,
PRIMARY KEY (member_id),
UNIQUE KEY login (login)
) ;

halojoy

You have one
TABLE @DB_MYSQL_PREFIX@members
You are using aMember Pro http://www.amember.com/p/

$signupdate
would be the column: added (datetime field)
It is the time user was added to TABLE members.

How to get the member_id of the logged in user
and how to get added value,
you should have in your documentation for aMember Pro.

simon999

I cant find any info with amember. the support is very limited.

could you show me an example of what a table query should look like.

johanafm

Actually the presence of a .sql file doesn't mean that sql code has been run. Connect to the dbms, select the db you are using (using CLI: use dbname) and then issue this command

SHOW TABLES

The basics of SQL rests on SELECT, INSERT, UPDATE and DELETE for modifying data, and CREATE, ALTER and DROP to create, modify and delete tables. Info on each of those statements can be found at http://dev.mysql.com/doc/refman/5.1/en/. Just make sure the 5.1 matches your actual MySQL version.

simon999

I have logged into mysql and there are 25 db tables installed in there.

i have found the right table and its the

variable/field - added
type -datetime
0000-00-00 00:00:00

this is for the signupdate

its using smarty system if that helps

simon999

went onto mysql and asked for php code for added.
it gave me this, is this right?

$sql = 'EXPLAIN SELECT added FROM amember_members';

johanafm

The table name is members, not amember_members.

EXPLAIN means you will get to see mysql's execution plan for the rest of the query. If you actually want to perform a select query, remove EXPLAIN from the query.

yurek

Once you have created a database, there are a few ways you can connect to it.
To connect from a PHP script, just put this in your file:

    <?

    mysql_connect("DBSERVER", "DBUSERNAME", "DBPASSWORD");

    mysql_select_db("DBNAME");

    ?>

Information taken from - PHP Tutorials

bradgrafelman

Since I'm familiar with your content script, I might suggest that you don't need to retrieve their signup date, but rather the number of days they've been a member. In that case, you might want a query like:

SELECT DATEDIFF(NOW(), added) AS days_registered FROM members WHERE member_id = $id

where $id is the user's member id, of course.

You would then use the "days_registered" pseudo-column in your script to determine which links/content to show.

yurek

If you have a question about work MySQL you can see here http://phpforms.net/tutorial/tutorial.html

That's what is written on your question:
Once you have created a database, there are a few ways you can connect to it.
To connect from a PHP script, just put this in your file:

   <?

    mysql_connect("DBSERVER", "DBUSERNAME", "DBPASSWORD");

    mysql_select_db("DBNAME");

    ?>

using the following substitutions for the bold terms as above, plus substituting DBPASSWORD with your own mysql password:

* Replace DBSERVER with the correct database servername for your site.
* Replace DBUSERNAME with your own mysql username.
* Replace DBNAME with your own mysql databasename.

The connection will be closed automatically when the script ends. To close the connection before, use the mysql_close() function:


<?php

$con = mysql_connect("localhost","peter","abc123");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

// some code

mysql_close($con);

?>