Session and login phpmysql help -



Session and login phpmysql help -

hello can please tell wrong code.i dont know wrong code showing no error , no result.i have created 2 tables in databas(mysql) 1 database used usersdetails , other used save comments , file of users.

<?php session_start(); $firstname= $_session['sess_first_name']; print $firstname; $tes=$_session['sess_member_id']; print $tes; ?> <?php // default page display // connect database server $dbcnx = @mysql_connect('localhost', 'root', ''); if (!$dbcnx) { die( '<p>unable connect ' . 'database server @ time.</p>' ); } // select jokes database if(! @mysql_select_db('tes') ) { die( '<p>unable locate joke ' . 'database @ time.</p>' ); } // if joke has been submitted, // add together database. if (isset($_post['submit'])) { $name = $_post['name']; $test = $_post['test']; $sql = "insert details set userid='$tes', name='$name', test='$test', date=curdate()"; if (@mysql_query($sql)) { echo('<p>your joke has been added.</p>'); } else { echo('<p>error adding submitted joke: ' . mysql_error() . '</p>'); } } echo('<p> here jokes in our database: </p>'); // request text of jokes $result = @mysql_query('select * details userid="1"'); if (!$result) { die('<p>error performing query: ' .mysql_error() . '</p>'); } // display text of each joke in paragraph while ( $row = mysql_fetch_array($result) ) { echo('<p><big style="color: rgb(204, 0, 0);">' . $row['name'] . '&nbsp;&nbsp;</big> <p>'); echo('<div style="text-align: justify;">' . $row['test'] . '&nbsp;&nbsp;</div>'); echo('<p><span style="font-style: italic;">' . $row['date'] . '&nbsp;&nbsp;</span>'); } // when clicked, link load page // joke submission form displayed. ?>

try removing error command operator, @ sign (@), origin of database-related functions using with. suppresses errors functions. also, have error reporting on?

ini_set('display_errors',1); error_reporting(e_all);

are seeing text on page @ all? such "here jokes in our database:"

i see using mysql_fetch_array() when referring $row['name'], $row['test'] if using mysql_fetch_assoc()

session login

Comments

Popular posts from this blog

iphone - Dismissing a UIAlertView -

intellij idea - Update external libraries with intelij and java -

javascript - send data from a new window to previous window in php -