Jump to content

convert to mysqli


Recommended Posts

I wrote a website years ago and when i finally upgraded the system its was running on all my mysql commands are depreciated.  So i started working on the small files to fix all the errors and now that i no longer have errors the code seams to not fetch the data from the db.  its been years since i coded and now i have to re educate my self.  Any help would be nice, thanks

<?php
ini_set("display_errors", "1");
error_reporting(E_ALL);
include("dbinfo.php");
$con = mysqli_connect($host,$username,$password);

// Connect to server and select database.
mysqli_select_db($con, "databasename")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name3 ORDER BY date DESC LIMIT 3";
$result=mysqli_query($con, $sql);

?>
<br />

<?php
while($rows=mysqli_fetch_array($result)){
?>
<table width="85%">
  <tr>
    <td width="50%" align="left"><p><a href="events/viewevent3.php?sid=<? echo $rows['sid']; ?>" class="link">&nbsp;<? echo $rows['stitle']; ?></a></p>
            <p class="clr-1"><? echo $rows['datepicker']; ?></p>
            <p class="p3">Click event name for more Details!</p></td>
    <td width="50%" align="right"><img src="<? echo $rows['pic']; ?>"  width="171" height="137" />&nbsp;&nbsp;</td>

  </tr>
</table>
<?php
}
?>
<?php
mysqli_close($con);
?>

 

Link to post
Share on other sites
8 minutes ago, Birdmansplace said:

the code seams to not fetch the data from the db

what result or symptom are you getting that leads you to believe that? 

btw - the short opening php tags <? my not be enabled on your server. you should ALWAYS use full opening <?php tags. You can also use a combined opening/echo tag  <?=

Link to post
Share on other sites

most of my site is now switched to mysqli but i am having issues with a page. its not giving me any errors  and its fetching the info from the db. i have an edit function per entree that loads this page.  when i click on it the edit and the page loads there is no info from db to edit and when i submit nothing changes.  some one mind taking a look, thanks.

 

<?
ini_set("display_errors", "10");
error_reporting(E_ALL);
include("../dbinfo.php");
$con = mysqli_connect($host,$username,$password);
mysqli_select_db($con, "database") or die( "Unable to select database");

// get value of id that sent from address bar
$sid=$_GET['sid'];

// Retrieve data from database
$sql="SELECT * FROM simple_search WHERE sid='$sid'";
$result=mysqli_query($con, $sql);

$rows=mysqli_fetch_array($result);

?>
<body bgcolor="#666666">
<br />
<table width="95%" border="0" cellspacing="1" cellpadding="0" align="center">
<tr>
<form name="form1" method="post" action="crew_update_ac.php">
<td>
<table width="100%" border="0" cellspacing="1" cellpadding="0" align="center">
<tr>
<td height="64">&nbsp;</td>
<td colspan="3" align="center"><strong>Update Upcoming Event</strong> </td>
</tr>

<tr>
<td align="center" width="9%"><strong>Event Name</strong></td>
<td width="85%"><input name="stitle" type="text" id="stitle" value="<?php echo $rows['stitle']; ?>" size="50"></td>
</tr>

<tr>
<td width="9%" height="54" align="center"><strong>Event Date</strong></td>
<td width="85%"><input name="datepicker" type="text" id="datepicker" value="<?php echo $rows['datepicker']; ?>" size="50"></td>
</tr>

<tr>
<td align="center" width="9%"><strong>Event Info</strong></td>

<td width="85%"><textarea name="sbody" id="sbody" cols="150" rows="50"><?php echo $rows['sbody']; ?></textarea></td>
</tr>

<tr>
<td align="center" width="9%"><strong>Picture</strong></td>
<td width="85%"><input name="pic" id="pic" size="50" value="<?php echo $rows['pic']; ?>"></td>
<td>Current Picture <br><img src="<?php echo $rows['pic']; ?>" width="173" height="137"/></td>
</tr>
<tr>
<td align="center" width="9%"><strong>Flyer</strong></td>
<td width="85%"><input name="file" id="file" size="50" value="<?php echo $rows['file']; ?>"></td>
<td></td>
</tr>
<tr>
<td>&nbsp;</td> 
<td align="center"><input name="id" type="hidden" id="id" value="<?php echo $rows['sid']; ?>">
  <input type="submit" name="Submit" value="Submit" /></td>
<td width="5%" align="center">&nbsp;</td>

<td width="1%">&nbsp;</td>
</tr>
</table>
</td>
</form>
</tr>
</table>
</body>
<?php
// close connection
mysqli_close($con);
?>

 

Link to post
Share on other sites
This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.