Jump to content

IChaps

Members
  • Content count

    21
  • Joined

  • Last visited

Community Reputation

1 Neutral

About IChaps

  • Rank
    Newbie

Profile Information

  1. Mysqli query $result into a $_SESSION. Can I?

    Hello Jomla. I'm a newbie teaching myself php and MySQL. I've been looking at session since I started in June 2016. The way I got to read a database MySQL was:- $db_host = "localhost"; // $db_host $db_user = "<database username>"; // $db_user $db_pass = "<database password>"; // $db_pass $db_databasename = "<database name>"; // $db_databasename $conn = new mysqli($db_host, $db_user, $db_pass, $db_databasename); if(! $conn) { die('Connection Failed'.mysql_error()); } $sql = "SELECT Member_id, Fullname, Username, Email, Password, Location, Country, DOB, Gender, Relationship, Photo, Tzone, WebsiteURL, MembershipType, AccountStatus, BusinessAddress, SignupDate, LastVisitDate, is_online, AccountPrivacy, UserContactPrivacy, AutoRenewPass, AutoRenewDate, IP_Address, AccountClosedDate, AccountDeleteDate, Remarks FROM phpbear_registration"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { if ( $row["Email"] == $user_email) { if ( $row["Password"] == $user_password) { switch ($row["AccountStatus"] ) { case "Suspended": echo "This account is Suspended."; header("Refresh:5; url=/index.php"); $conn->close(); exit(); case "Closed": echo "This account was closed on:- ". $row["AccountClosedDate"]; header("Refresh:5; url=/index.php"); $conn->close(); exit(); } if ( $row["AccountStatus"] == "Active" or $row["AccountStatus"] == "New") { // echo "id: " . $row["Member_id"]. " - Name: " . $row["Fullname"]. " " . $row["Email"]. "<br>"; // Get member's data from database $_SESSION['member_Member_id'] = $row["Member_id"]; $_SESSION['member_Accountname'] = $row["Fullname"]; $_SESSION['member_Username'] = $row["Username"]; $_SESSION['member_Email'] = $row["Email"]; $_SESSION['member_Password'] = $row["Password"]; $_SESSION['member_Location'] = $row["Location"]; $_SESSION['member_Country'] = $row["Country"]; $_SESSION['member_DOB'] = $row["DOB"]; $_SESSION['member_Gender'] = $row["Gender"]; $_SESSION['member_Relationship'] = $row["Relationship"]; $_SESSION['member_Photo'] = $row["Photo"]; $_SESSION['member_Tzone'] = $row["Tzone"]; $_SESSION['member_WebsiteURL'] = $row["WebsiteURL"]; $_SESSION['member_MembershipType'] = $row["MembershipType"]; $_SESSION['member_AccountStatus'] = $row["AccountStatus"]; $_SESSION['member_BusinessAddress'] = $row["BusinessAddress"]; $_SESSION['member_SignupDate'] = $row["SignupDate"]; $_SESSION['member_LastVisitDate'] = $row["LastVisitDate"]; $_SESSION['member_isonline'] = $row["is_online"]; $_SESSION['member_Privacy'] = $row["AccountPrivacy"]; $_SESSION['member_Contact_Privacy'] = $row["UserContactPrivacy"]; $_SESSION['member_AutoRenewPassword'] = $row["AutoRenewPass"]; $_SESSION['member_AutoRenewPasswordDate'] = $row["AutoRenewDate"]; //$_SESSION['member_IPAddress'] = $row["IPAddress"]; /* $_SESSION['member_AccountClosedDate'] = $row["AccountClosedDate"]; $_SESSION['member_AccountDeleteDate'] = $row["AccountDeleteDate"]; $_SESSION['member_Remarks'] = $row["Remarks"]; */ /* $sql = "UPDATE phpbear_registration SET IPAddress='' WHERE Member_id='$userID'"; mysqli_query($conn,$sql); */ /* ------------------------------------------------------------ if ($row["AccountStatus"] = "New") { $sql = "UPDATE phpbear_registration SET AccountStatus='Active' WHERE Member_id='$_SESSION['member_Member_id']'"; $sql = "UPDATE phpbear_registration SET AccountDeleteDate='--/--/----' WHERE Member_id='$_SESSION['member_Member_id']'"; mysqli_query($conn,$sql); } ---------------------------------------------------------------------------------------- */ $conn->close(); require($_SERVER['DOCUMENT_ROOT'].'/Core/user/user.php'); exit(); } } } } } $conn->close(); I know it's a long winded but at that time I didn't know how else to store the results. Good Luck.
  2. Hello. I've created a small form with 6 text boxes and 2 select boxes/fields. The problem I'm facing is that I'm unable to post from the form to another php file. In the html form, I've written:- <form action="newmember.php" method="POST"> <table> <tr> <td>Full Name / Business Name:</td> <td><input name="txtAccountName" size="20" maxlength="50"></td> <td></td> </tr> <tr> <td>Username:</td> <td><input name="txtUsername" size="20" maxlength="50"></td> <td></td> </tr> <tr> <td>EMail:</td> <td><input name="txtEmail" size="20" maxlength="100"></td> <td></td> </tr> <tr> <td>Password:</td> <td><input name="txtPassword" type="password" size="20" maxlength="20"></td> <td></td> </tr> <tr> <td>Confirm Password:</td> <td><input name="txtConfirm_Password" type="password" size="20"></td> <td></td> </tr> <tr> <td>DOB:</td> <td><input name="txtdob" size="12" value="dd/mm/yyyy" maxlength="12"></td> <td></td> </tr> <tr> <td>Membership Type:</td> <td><select name="comMembership" size="1"> <option selected="selected">Individual</option> <option>Business</option> </select> </td> <td></td> </tr> <tr><td></td></tr> <tr> <td>You Agree to our<br> Terms and Conditions,<br> and Privacy/Cookies Notice.</td> <td><select name="txtAgree" size="1"> <option selected="selected">N</option> <option>Y</option> </select> </td> </tr> </table> <input name="submit" type="image" src="/mainimages/submit.jpg" style="border: 0" alt=""> </form> And in the newmember.php file I've so far written:- <?php // Check Entries $New_Agree = $_POST["txtAgree"]; $New_Fullname = $_POST["txtAccountName"]; $New_Username = $_POST["txtUsername"]; $New_EMail = $_POST["txtEmail"]; $New_Password = $_POST["txtPassword"]; $New_Confirm_Password = $_POST["txtConfirm_Password"]; $New_Dob = $_POST["txtdob"]; $New_Membership = $_POST["comMembership"]; ?> I'd just like to ask:- 1. Dose my coding look correct, as I've not been faced with posting problem before? 2. Should I place the $_POST in html instead of php? 3. Oh yes, I've found that the DOB is posted ok, however I've placed value="dd/mm/yyyy" as a temporary measure only. I'd be grateful for any ideas or guidance/help. Thank You very much.
  3. Session Query

    Hello. I'd just like to enquire about using session S_session please. I've created 4 sessions to hold the log in data for the access to a database (host, username, password, database name) At present I've got it to load this data from a file and insert it into a session. Then for my use I've got it to display this data, to ensure it's reading from the file - which it is doing correctly. The problem I've got is in another php file. In the other php file the sessions are all blank and I don't know why this is. ---- In my index.php file the code reads [this works]:- //ReadFile $fp = fopen( dirname(__FILE__).'/Core/sys/dbinfo.txt', 'r' ) or die("Couldn't open file:- 1"); $db_host = fgets($fp); $db_user = fgets($fp); $db_pass = fgets($fp); $db_databasename = fgets($fp); fclose( $fp ); $_SESSION['dbf_host'] = $db_host; $_SESSION['dbf_user'] = $db_user; $_SESSION['dbf_pass'] = $db_pass; $_SESSION['dbf_databasename'] = $db_databasename; and in the other php file, the code reads:- session_start(); echo "new php file\n"; echo $_SESSION['dbf_host']; echo $_SESSION['dbf_user']; echo $_SESSION['dbf_pass']; echo $_SESSION['dbf_databasename']; The above code produces a blank screen. Could anyone please advise me? Thank You.
  4. Hi, Could I please briefly enquire about reading and writing to a file using php? I'm looking for a way of storing a database's, Name, Username and Password. Then reading it back again. Writing to a file, I've written:- // Write to file. $fp = fopen( dirname(__FILE__).'/sys/dbinfo.txt', 'w' ) or die("Couldn't open file:- "); fwrite($fp, $hostname); fwrite($fp, $database); fwrite($fp, $username); fwrite($fp, $password); fclose( $fp ); and to read back, I've written:- $fp = fopen( dirname(__FILE__).'/sys/dbinfo.txt', 'r' ) or die("Couldn't open file:- "); $db_host = fread($fp, $hostname); // $db_host $db_user = fread($fp, $username); // $db_user $db_pass = fread($fp, $password); // $db_pass $db_databasename = fread($fp, $database); fclose( $fp ); However, I'm finding the data is been written in one long string (ie localhostusernamepassworddatabasename). I'd just like to ask if it is possible read the file so that $db_host would hold just hostname, $db_user would hold just the database username and so on? Also (out of interest) is there another way of reading and writing. I've thought about keeping each piece of data in a separate file. Thank You.
  5. Hello. I'd like to request a little guidance with regards forms and updating a database table please. I've created a form which has a dropdown list. I'd just like to enquire:- 1. How do I pass the selected result from the dropdown list to a variable? (at present I've written:- $user_gender = $_POST["profile_gender"] 2. I'm unable to update the database table. The database opens and there's no errors reported. I'd just like to ask the following looks ok? $sql = "UPDATE registration_table SET Gender='$user_gender' WHERE Member_id='$userID'"; Thank You.
  6. How do I read and write to file?

    Hello. I'd just like to enquire how I would read and write to a file using php please? I'm looking to write a database's, Host, Username, Password, and database Name to a file name on the server, then at a later date. When I load the site, read this information back. At present I'm using the following to write to the file:- // Write to file. $fp = fopen( dirname(__FILE__).'/dbinfo.txt', 'w' ) or die("Couldn't open file:- "); fwrite($fp, $hostname); fwrite($fp, $database); fwrite($fp, $username); fwrite($fp, $password); fclose( $fp ); and to read back:- $fp = fopen( dirname(__FILE__).'/dbinfo.txt', 'r' ) or die("Couldn't open file:- "); $db_host = fread($fp, $hostname); // $db_host $db_user = fread($fp, $username); // $db_user $db_pass = fread($fp, $password); // $db_pass $db_databasename = fread($fp, $database); fclose( $fp ); However, it reads it all in one long string, instead of it been on separate lines. Would anyone know the correct way of writing this code, please? Thank You.
  7. How do I search a database?

    Hello. Could anyone familiar with mysqli advise me with regards reading and searching a database please? After connecting to the database, and opening it. So far, I've written the following:- $sql = "SELECT Member_id, Fullname, Username, Email, Password, Location, Country, DOB, Gender, Photo, Tzone, WebsiteURL, MembershipType, AccountStatus, ShortURL, BusinessAddress, SignupDate, LastVisitDate, AccountClosedDate, AccountDeleteDate FROM registration"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_row()) { if ( $row[3] == $user_email & $row[4] == $user_password) { echo "Found Entry"; } } } mysqli_close($conn); I'm finding that the above, will only read the first record/entry in the database, and will not read/search the rest of the database. I'd like to ask/request how do I go about searching the rest of the database? As I don't know how to proceed with it. Thank You.
  8. Hello again. I've tried the suggestion above, however I can't get it to work, as I'm getting a blank field. I have also written the code below, and I'm still getting a blank field next to the Account Name. Could I please request if anyone could write the correct coding for me? Thank You. <div id="editform"> <form name="edit_account" action="EDITING" method="POST"> <table style="border-size: 0px"> <tr> <td width="25%">Account Name:</td> <td width="11%"></td> <td> <input name="profile_fullname" value= "<?php echo $_SESSION['$member_Fullname']; ?>" maxlength="20"></td> </tr> <tr> <td width="25%">Username:</td> <td width="11%"></td> <td><input name="profile_username" value=$username maxlength="20"></td> </tr> <tr> <td width="25%">EMail:</td> <td width="11%"></td> <td><input name="profile_email" type="text" value="mememail"></td> </tr> <tr> <td width="25%">Password:</td> <td width="11%"></td> <td>*****</td> </tr> <tr> <td width="25%">Location:</td> <td width="11%"></td> <td><input name="profile_location" type="text" value="location" maxlength="20"></td> </tr> <tr> <td width="25%">Country:</td> <td width="11%"></td> <td><select name="country" size="1"> <option selected="selected">United Kingdom</option> </select> ></td> </tr> <tr> <td width="25%">DOB:</td> <td width="11%"></td> <td> <?php $_SESSION['$member_DOB']; ?> </td> </tr> <tr> <td width="25%">Gendar:</td> <td width="11%"></td> <td><select name="gender" size="1"> <option>Male</option> <option>Female</option> </select></td> </tr> <!-- <tr> <td width="25%">Profile Photo:</td> memphoto <td width="11%"></td> <td>Form Basic 9</td> </tr> --> <tr> <td width="25%">Time Zone:</td> <td width="11%"></td> <td><select name="timezone" size="1"> <option>GMT</option> </select></td> </tr> <tr> <td width="25%">Website URL:</td> <td width="11%"></td> <td><textarea name="profile_websiteurl" value="website"> </textarea> </td> </tr> <!-- <tr> <td width="25%">Membership Type:</td> memtype <td width="11%"></td> <td> <?php $_SESSION['$member_MembershipType']; ?></td> </tr> <tr> <td width="25%">Account Status:</td> memstatus <td width="11%"></td> <td><?php $_SESSION['$member_AccountStatus']; ?></td> </tr> --> <tr> <td width="25%">Short URL:</td> <td width="11%"></td> <td><input name="profile_shorturl" value="$shorturl"></td> </tr> <tr> <td width="25%">Business Address:</td> <td width="11%"></td> <td> <textarea name="profile_businessaddress"> </textarea> </td> </tr> <tr> <td width="25%">Date Joined:</td> <td width="11%"></td> <td> <?php $_SESSION['$member_SignupDate']; ?> </td> </tr> <tr> <td width="25%">Last Visited:</td> <td width="11%"></td> <td><?php $_SESSION['$member_LastVisitDate']; ?></td> </tr> </table> </form> </div>
  9. Hello. Could I please request some guidance with editing data? I'm looking to build a form, which will pull data from a database and display it in the form, so it can be edited. However I don't know the correct way to enter the data into the form. or, I'll ask the question another way How do I edit a record held in a database please? Thank you.
  10. How would include a html file

    Hello Ingolme, Thank you for you reply. It's been about 8-10 years since I built a web site, so things may have changed some-what. The line I specified above, was used when I used FrontPage 2000/2002. Now, all attempts to use include in html has failed. I've used the guide on w3schools's site and I can't get to this to work for some reason. I just don't know what else to try. I'd welcome any help. Thank You.
  11. How would include a html file

    Hello. I'd just like to enquire, how would I include one html file in another? I'm using a bootstrap theme. I've created a menu, which I would like to include on a few more pages I'll be creating. I have used the old method - <!-- webbot bot="Include" U-Include="mainmenu.html" TAG="BODY" --> but I can't get this to work. I've also used iframe but all I get is a blank square. Could anyone please help? Thank You.
  12. Hello.. I'd like to enquire if I can show 2 php files side by side? for example:- in a index.php, can I include a menu.php on the left-hand side, and another php file next to it? I'm not sure how to do this, however I've tried to achieve it in html, and failed. Can anyone help please? Thank You.
  13. Request help with css and widths

    Hello. I'm just starting out with css, and I would like to enquire about setting widths, and inserting php. I've created a 3 column page in css/html using my css editor's template. I would like to insert a menu on the left hand side, which I've created in php, and set the width. However I can't figure out how to do this. Also, using iframe, there is a box created with stretches over 2 columns, I would like to ask how do I set the width of this. I've attached a screen print of my template Thank You.
  14. Hello. I'm looking to build a menu for my project. I'm just enquiring:- 1. Once I've retrieved the entry from the database, How do I create an array? 2. Once the array is created, how do I show a small picture, basic text (ie Home Page), and a hyperlink please? Thank You.
×