Learn VBA & Macros in 1 Week!

PHP - Having A Problem Connecting To Data Base

Full Excel VBA Course - Beginner to Expert

Having A Problem Connecting To Data Base	View Content

i have just sent the last 4 hours trying to connect to the msql database here is the to sets of code i i'm using

<?php
$db_host = "host";
$db_usernamen = "username";
$db_pass = "password"
$db_name = "database name";

mysql_connect("$db_host","$db_username","$db_pass") or die ("couldnot connect to mysql");
mysql_select_db("db_name") or die ("no database");
?>

this code i'm using to connect to the database

<?php
require "connect_to_mysql.php";

echo "<h1>success in database connection! happy coding</h1>";
?>
and i have used this one as a quick test.

i have up loaded the the two codes to the sever however when i opened the web site to test it all i get is a blank screen. i have looked at a number of codes like this one and i can't see anything wrong with the code. i have uploaded the codes three times just in case the files had been corrupt while uploading have every this has not work

if anyone can help i would be very greatful

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Passing Value From A Data Base Via Href To Create Query Base User Onkeydown

Performace Problem In Export Excel From Data Base Entries..

Retrievin Data From Data Base .. Based On The Logged In User

Why Query Fails To Pull All Data From Data Base ?

Selecting Data And Ordering It From A Mysql Data Base!

Unable To Insert The Data Into Data Base

Data Base Search

Data Base Viewing

How Perform Data Base Reporting

I Looked In My Data Base And Nothing Was Sent To Write...?

Connect Data Base To Live Server

Check Username & Password In Data Base With Curl

Issues With Switch And Retrieving Info From Data Base

Google Base Rss Php Problem

Moved: .htaccess Rewrite Base Problem

Problem Connecting To Mysql

Problem Connecting A Cms To Gateway

Problem Connecting To Mysql Db Using Included Connect File

What To Do With My Php Code Base?

Meaning Of Base Tag

Learn VBA & Macros for Excel in 1 Week!

Passing Value From A Data Base Via Href To Create Query Base User Onkeydown

Similar Tutorials

I have a some value that are being generated from a database then thrown into <li><href> to create a list that user can click and fetch data through ajax

right now its in a form select/menu and works fine however I need to convert to a list and use and onKeyDown event

Code: [Select]
<form>
<select name="users" size="<?php echo $num_rows;?>" onchange="showUser(this.value)" >
<?php
do {
?>
<option value="<?php echo $row_Recordset1['item_id']?>"><?php echo $row_Recordset1['item_id'].' '. $row_Recordset1['item_name']?></option>
<?php
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
  $rows = mysql_num_rows($Recordset1);
  if($rows > 0) {
      mysql_data_seek($Recordset1, 0);
  $row_Recordset1 = mysql_fetch_assoc($Recordset1);
  }
?>
</select>
</form>

I need to correct this Code: [Select]
<ol>
<?php  do { ?>

<li onKeyDown="showUser(this.value)"><a href="getmenu.php?item_id="<?php echo $row_Recordset1['item_id']?>"> <?php echo $row_Recordset1['item_name']?></a></li>

<?php
  } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
   $rows = mysql_num_rows($Recordset1);
   if($rows > 0) {
mysql_data_seek($Recordset1, 0);
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
  }
?>
</ol>

Performace Problem In Export Excel From Data Base Entries..

Similar Tutorials

Hi All,

As we know........to export excel sheet the database content....we query the data base and then process the result and using Workbook and header we export the result in excel..................

Is there any way we can reduce the down load time or increase the performance for same. ?

Thanks.

Retrievin Data From Data Base .. Based On The Logged In User

Similar Tutorials

I have two tables.

Table Name:Users

Fields:

User_name
user_email
user_level
pwd

2.Reference

Fields:

refid
username
origin
destination

user_name in the users table and the username field in reference fields are common fields.

There is user order form.whenever an user places an order, refid field in reference table will be updated.So the user will be
provided with an refid

Steps:

1.User needs to log in with a valid user id and pwd
2.Once logged in, there will be search, where the user will input the refid which has been provided to him during the time of order placement.
3.Now User is able to view all the details for any refid
3.Up to this we have completed.

Query:

Now we need to retrieve the details based on the user logged in.

For eg: user 'USER A' has been provided with the referenceid '1234' during the time of order placement
user 'USER B' has been provided with the referenceid '2468' during the time of order placement

When the userA login and enter the refid as '2468' he should not get any details.He should get details only for the reference ids which is assigned to him.

<?php

session_start();

if (!$_SESSION["user_name"])



{
        // User not logged in, redirect to login page
        Header("Location: login.php");
     }
$con = mysql_connect('localhost','root','');
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("login", $con);
$user_name = $_POST['user_name'];
$refid = $_POST['refid'];
$query = "SELECT * from reference,users WHERE reference.username=users.user_name AND reference.refid='$refid' AND ";

$result = mysql_query($query) or trigger_error('MySQL encountered a problem<br />Error: '  . mysql_error() . '<br />Query: ' . $query);

while($row = mysql_fetch_array($result))
  {
  echo $row['refid'];
  echo $row['origin'];
  echo $row['dest'];
  echo $row['date'];
  echo $row['exdate'];
  echo $row['username'];
  }
echo "<p><a href=\"logout.php\">Click here to logout!</a></p>";
?>

<html>
<form method="post" action="final.php">
Ref Id:<input type="text" name="refid">
<input type="submit" value="submit" name="submit">
</html>

Why Query Fails To Pull All Data From Data Base ?

Similar Tutorials

Hi,

I want to pull data from db, where sometimes all rows and sometimes rows matching given "username".

Here is my code:

	//Grab Username of who's Browsing History needs to be searched. 
	if (isset($_GET['followee_username']) && !empty($_GET['followee_username'])) 
{ 
    $followee_username = $_GET['followee_username']; 
    
    if($followee_username != "followee_all" OR "Followee_All") 
    { 
        $query = "SELECT * FROM browsing_histories WHERE username = \"$followee_username\""; 
        $query_type = "followee_username"; 
        $followed_word = "$followee_username"; 
        $follower_username = "$user"; 
        echo "$followee_username"; 
    } 
    else 
    { 
        $query = "SELECT * FROM browsing_histories"; 
        $query_type = "followee_all"; 
        $followed_word = "followee_all"; 
        $follower_username = "$user"; 
        echo "all"; 
    } 
}

When I specify a "username" in the query via the url:

browsing_histories_v1.php?followee_username=requinix&page_number=1

I see result as I should. So far so good.

Now, when I specify "all" as username then I see no results. Why ? All records from the tbl should be pulled!

browsing_histories_v1.php?followee_username=all&page_number=1

This query shouldv'e worked:

	$query = "SELECT * FROM browsing_histories";

Selecting Data And Ordering It From A Mysql Data Base!

Similar Tutorials

Hi I am trying to select and order data/numbers from a colum in a mysql data base however i run the code and it returns no value just a blank page no errors or any thing so i think the code is working right but then it returns no result? Please help thanks

Here is the code:

<?php
$host= "XXXXXX";
$mysql_user = "XXXXXX";
$mysql_password = "XXXXXX";
$mysql_database = "XXXXXXX";

$connection = mysql_connect("$host","$mysql_user","$mysql_password") or die ("Unable to connect to MySQL server.");
mysql_select_db($mysql_database) or die ("Unable to select requested database.");

$row = mysql_fetch_assoc( mysql_query( "SELECT XP FROM Game ORDER BY number DESC LIMIT 1" ) );
$number = mysql_result(mysql_query("SELECT XP FROM Game ORDER BY number DESC LIMIT 1"), 0);

echo "The the highest XP is $number";

?>

Unable To Insert The Data Into Data Base

Similar Tutorials

Hi Team,

I have a php page where I have taken the same userid and linked in the next page and also used show/hide function.

I am able to see that the userid is linking but when i submit the data is not getting insert and also no error

Please help

below is the Tower.php file.

Code: [Select]
<!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=iso-8859-1" />
<title>BHP2</title>
<style type="text/css">

</style>
</head>

<body>

<div id="Layer1">
<form id="form5" name="form5" method="link" action="Insert.php">
<div id="Layer2">
<div id="Layer6"><img src="AZimages/BHP-Billiton-logo.jpg" width="235" height="65" alt="BHP" /></div>
<h1 align="center"> </h1>
<div class="style1" id="Layer4">
<h1 align="center" class="style2">BHP DATA TRACKER </h1>
</div>
</div>
<div id="Layer7">
<div align="center"><span class="style4">SELECT THE TOWER BELOW </span>
<div id="Layer13">

<input type="hidden" name="empid" value="<?php echo $_GET['id']; ?>" size="20">
<input type="hidden" name="date" value="<?php echo date("Y-m-d H:i:s"); ?>" >
<input type="submit" name="B1" value="Start !" />

</div>
<div id="Layer12">
<div align="left">

<input name="rad1" type="radio" value="RF" id="rad1" />
<label >RF</label>

</div>
</div>
<div id="Layer11">
<div align="left">
<input name="rad1" type="radio" value="ISAP" id="rad1" />
<label >ISAP</label>

</div>
</div>
<div id="Layer10">
<div align="left">
<input name="rad1" type="radio" value="GSD" id="rad1" checked="checked" />
<label >GSD</label>

</div>
</div>
<div id="Layer9">
<div align="left">
<input name="rad1" type="radio" id="rad1" value="CSD" />
<label>CSD</label>
</p>
</div>
</div>
<br />
</div>
</div>
</form>
</div>
</body>
</html>

Below is the insert.php

<!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">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>BHP DATA SUMBIT</title>
<?php
include ("count.php");
?>

<?php
if(isset($_GET['action']))
{
$action = $_GET['action'];
if ($action = 'yes')
{
include ("Connection.php");
$PName = $_POST['rad11'];
$Date = date("Y-m-d H:i:s");
$empidno = $_POST['idd'];
$qsdate = $_POST['testinput'];
$cb1 = $_POST['chkbox1'];
$cb2 = $_POST['chkbox2'];
$cb3 = $_POST['chkbox3'];
$cb4 = $_POST['chkbox4'];
$cb5 = $_POST['chkbox5'];
$Com = $_POST['textfield2'];
$dd1 = $_POST['textfield'];
$dd2 = $_POST['select'];
$dd3 = $_POST['select2'];
$dd4 = $_POST['textfield4'];
$dd5 = $_POST['textfield3'];
$dd6 = $_POST['select3'];
$sev = $_POST['radio1'];
$olddate = $_POST['odate'];
$pname = $_POST['radiobutton'];

$query="INSERT INTO bhp ticketinformation (`userid`,
`processname`,
`begindate`,
`dateposted`,
`CALL`,
`EMAIL`,
`NEW`,
`EXISTING`,
`Piroty`,
`MTICKET`,
`Services`,
`group1`,
`group2`,
`Icall`,
`Tcreatedtime`,
`comment`)
VALUES ( '$empidno' , '$pname' , '$olddate' , '$Date' , '$cb1' , '$cb2' , '$cb3' , '$cb4' , '$sev' , '$dd1' , '$dd2' , '$dd3' , '$dd4' , '$dd5' , '$dd6' , '$Com')";
mysql_query($query);
Header('location:tower.php?id=' . $empidno);
}
}
?>
<head>
<style type="text/css">

</style>

<script language="JavaScript" >
function showInfo()
{
var elem = document.getElementById('verify');
if(document.testform.select3.value == "verify" || document.testform.select3.value == "verify1" )
{
elem.style.display="inline";
}
else
{
elem.style.display="none";
}
}
</script>

<script language="JavaScript">

function validator()
{
if(document.testform.Checkbox1.checked == false &&
document.testform.Checkbox2.checked == false &&
document.testform.Checkbox3.checked == false &&
document.testform.Checkbox4.checked == false)
{
alert ('You did not choose any of the checkboxes!');
return false;
}
if (document.testform.textfield.value =="")
{
alert("Enter Max Ticket No");
return false;
}
if (document.testform.select.value == "" || document.testform.select.value == "SELECT SERVICE DROP DOWN")
{
alert ('Select the SELECT SERVICE DROP DOWN');
return false;
}
if (document.testform.select2.value == "" || document.testform.select2.value == "SELECT RG GROUP")
{
alert ('SELECT RG GROUP');
return false;
}
if (document.testform.select3.value == "" || document.testform.select3.value == "SELECT GROUPS")
{
alert ('SELECT GROUPS');
return false;
}
if (document.testform.textfield2.value =="")
{
alert("Comments Feild is Empty.If there are no Comment then type NA(Not Applicable)");
return false;
}
if (document.testform.Checkbox1.checked == false)
document.getElementById("chkbox1").value = "";
else
document.getElementById("chkbox1").value = "EMAIL";
if (document.testform.Checkbox2.checked == false)
document.getElementById("chkbox2").value = "";
else
document.getElementById("chkbox2").value = "NEW";
if (document.testform.Checkbox3.checked == false)
document.getElementById("chkbox3").value = "";
else
document.getElementById("chkbox3").value = "EXISTING";
if (document.testform.Checkbox4.checked == false)
document.getElementById("chkbox4").value = "";
else
document.getElementById("chkbox4").value = "CALL";
alert('Record has been posted in the portal');
}
</script>
</head>

<body>
<div id="Layer1">
<div id="Layer2">
<div id="Layer6"><img src="AZimages/BHP-Billiton-logo.jpg" width="235" height="67" alt="BHP" /></div>
<h1 align="center"> </h1>
<div class="style1" id="Layer4">
<h1 align="center" class="style2">BHP DATA TRACKER </h1>
</div>
</div>
<div id="Layer7">

<form method="POST" action="Insert.php?action=yes&&id=<?php echo $_GET['empid']; ?>" name="testform" onSubmit="return validator();">

<div id="Layer8">

<input type="checkbox" id="Checkbox4" name="checkbox4" value="CALL" />
CALL</label>

</div>
<div id="Layer9">

<label>
<input type="checkbox" id="Checkbox1" name="checkbox1" value="EMAIL" />
EMAIL</label>

</div>
<div id="Layer10">

<label>
<input type="checkbox" id="Checkbox2" name="checkbox2" value="NEW" />
NEW</label>

</div>
<div id="Layer11">

<label>
<input type="checkbox" id="Checkbox3" name="checkbox3" value="EXISTING" />
EXISTING</label>

</div>
<div id="Layer12">

<label>
<input name="radio1" type="radio" id="radio1" value="P1" checked="checked" />
P1</label>

</div>
<div id="Layer13">

<label>
<input name="radio1" type="radio" id="radio1" value="P2" />
P2</label>

</div>
<div id="Layer14">

<label>
<input name="radio1" type="radio" id="radio1" value="P3" />
P3</label>

</div>
<div id="Layer15">

<label>
<input name="radio1" type="radio" id="radio1" value="P4" />
P4</label>

</div>
<div id="Layer16">

<label>MAXIMUM TICKET
<input type="text" name="textfield" />
</label>

</div>
<div id="Layer17">

<label>SERVICE DROP DOWN
<select name="select" style="width: 162px; height: 23px">
<option>SELECT SERVICE DROP DOWN</option>
<option>OTHER(FW)</option>
<option>1 MESSAGE</option>
<option>1 MOBILITY</option>
<option>1 VOICE</option>
<option>1 SAP</option>
<option>1 PORTAL</option>
<option>1 COLLAB</option>
<option>1 GSAP</option>
<option>1 SECURITY</option>
<option>1 WAN</option>
<option>S DOMAIN</option>
<option>1 AUTH</option>
<option>1 DOCM</option>
<option>1 REMOTE</option>
</select>
</label>

</div>
<div id="Layer18">

<label>RG GROUP
<select name="select2" style="width: 162px; height: 23px">
<option>SELECT RG GROUP</option>
<option>I-AM-AU-AM-HWT</option>
<option>I-EUS-IN-CSC-DSK-CSD</option>
<option>I-EUS-IN-CSC-DSK-GSD</option>
<option>I-EUS-GB-DCS-BHPVICFW</option>
<option>I-ITS-AU-HW</option>
<option>I-SRM-AU-IAM-LAMU</option>
<option>I-ITS-AU-SW</option>
<option>C-BHP-AU-CSC-LSD-NONBRG</option>
<option>C-BHP-AU-ACN-AQM</option>
</select>
</label>

</div>
</div>
<div id="Layer19">

<label>SELECT GROUPS
<select name="select3" onchange="showInfo()" style="width: 162px; height: 23px">
<option value="none" >SELECT GROUPS</option>
<option value="verify">TP</option>
<option value="verify1">OA</option>
<option>OC</option>
<option>OTHERS</option>
</select>
</label>
<div id="verify" style="display:none;">

<br/><br/>
<label>INCOMING CALL/EMAIL TIME
<input type="text" name="textfield4" />
</label>
<br/><br/>
<label>MAXIMO TICKET CREATED TIME
<input type="text" name="textfield3" />
</label>
</div>

<div id="Layer24">

<label>COMMENTS
<input type="text" name="textfield2" />
</label>

</div>
<div id="Layer26">

<input name="Reset" type="reset" id="Reset" value="Reset" />

</div>
<div id="Layer25">
<input type="submit" name="Submit" value="Submit" />
<input type="hidden" name="chkbox1" id="chkbox1" />
<input type="hidden" name="chkbox2" id="chkbox2" />
<input type="hidden" name="chkbox3" id="chkbox3" />
<input type="hidden" name="chkbox4" id="chkbox4" />
<input type="hidden" name="chkbox5" id="chkbox5" />
<input type="hidden" name="rad11" id="rad11" value="<?php echo $_GET['rad1']; ?>" />
<input type="hidden" name="idd" id="idd" value="<?php echo $_GET['empid']; ?>" />
<input type="hidden" name="odate" id="odate" value="<?php echo $_GET['date']; ?>" />
</form>

</div>
</div>
</div>
</body>
</html>

THANKS IN ADVANCED

Data Base Search

Similar Tutorials

i have php code,

<?php

include ("connect.php");
$selecteddate = $_POST['sdate'];
$sql1 = "select date from game1";
$query1 = mysql_query($sql1) or die(mysql_error());
while($row = mysql_fetch_assoc($query1))
{
$rowdate = $row['date'];
// problem here i this while loop only compare my latest last value in
database. i want a code here which search all the data in "date" field.
}
if($selecteddate == $rowdate)
{
echo "Date already Exists";
}

else
{
// form insertion data code here which i have and working fine
}
SHINSTAR is online now Add to SHINSTAR's Reputation Report Post Edit/Delete Message

Data Base Viewing

Similar Tutorials

Hello First of all thanks for your help in advance. I build a members website and can use HTML but seem to be going round in circles with php.
So Ive made a page that allows users to input there details and register this DOES Work and adds the data to a mysql data base. However I would like when they click register it sends them a email to confirm there info and at the same time send myself one so I can check there details. this is the link http://www.asian-travel-club.co.uk/php/files/register.htm
Once this is done I would like to be able to see on a admin page that has a username and password to allow me to active and deactive there members. I know this would need a button added this is where I get lost. the link to the admin page ive made is http://www.asian-travel-club.co.uk/php/files/admin/ Then once i actived them they will recive an auto activtion email .

I dont seem to be able to see data from the Database on mysql but i can interact with it.
As one you register if you try to log in it say that the username and passwodr is incorrect. I TAKE IT IS BECAUSE THE USER DOES NOT HAVE PERMISSION> how do i do this? Any way if you go to forot password page it allows you to enter data and on submittion it chz the database and then sends you an email with your username and password attached. This is the link to the password recover page.
http://www.asian-travel-club.co.uk/php/files/password_recover.php

this is what is in my config.php

<?php

define('DB_SERVER', ''); // database server/host

define('DB_USER', ''); // database username

define('DB_PASS', ''); // database password

define('DB_NAME', ''); // database name
?>

Please help if you can

How Perform Data Base Reporting

Similar Tutorials

Hi ,

Presently we are preparing an excel for download report by querying to data base.
We are querying to DB and looping through each result row and writing to excel.
for 2lacs data its too much time.

I found the time taken max in DB query and processing the DB data .
Ant way I can make it faster ?

Any parallel processing I can apply to get it faster......I expecting Huge data report in future.

I Looked In My Data Base And Nothing Was Sent To Write...?

Similar Tutorials

Hi everyone,

Here's the part of the script I think is wrong :

<?php
include "util/log.php";
include "util/connect.php";

if (loggedin() == $NO)
{
   header("Location: login.php");
   exit();
}

else if (isset($_GET["p"]))
{
   $udata = explode("-", $_COOKIE["log"]);
   $query = "SELECT * FROM l_users WHERE user='$udata[0]'";
   $usrsql = mysql_query($query) or handledberror(mysql_error());
   $usrdata = mysql_fetch_array($usrsql);
   switch ($_GET["p"])
   {
      case "delete":
         include "util/linkfunc.php";
         if (isset($_GET['id'])) delete_link($_GET['id']);
         else delete_all();
         $CONTENT = "pages/urls.php";
      break;
      case "approve":
         include "util/approve.php";
         $CONTENT = "pages/approve.php";
      break;
      case "urlview":
      case "add":
      case "edit":
         include "pages/modify.php";
         $CONTENT = "pages/edit.php";
      break;
      case "reset":
         include "util/linkfunc.php";
         if (isset($_GET['id'])) reset_link($_GET['id']);
         else reset_all();
         $CONTENT = "pages/urls.php";
      break;
      case "urls":
      default:
      $CONTENT = "pages/urls.php";
   }
}
else
{
   $udata = explode("-", $_COOKIE["log"]);
   $query = "SELECT * FROM l_users WHERE user='$udata[0]'";
   $usrsql = mysql_query($query) or handledberror(mysql_error());
   $usrdata = mysql_fetch_array($usrsql);
   $CONTENT = "pages/urls.php";
}

?>
<html>
<head><title>EzyLinkExpire :: Member's Area</title><head>
<body bgcolor="#1D2B60" link=#CCFFFF vlink=#CCFFFF>

<table align="center" cellspacing="0" width=90% bgcolor="white" bordercolordark="black" bordercolorlight="black">
<tr>
      <td bgcolor="#1D2B60"> <img src="images/logo.gif" border="0"></td>
      <td valign=top bgcolor="#1D2B60" align=right><font color="white" size="1" face="Verdana">Welcome <? print $usrdata["fname"] . " ". $usrdata["lname"]; ?>!<br>User Since: <? print date("F d Y",$usrdata["since"]); ?><br>Server Time:<? print date("r"); ?><br><a href="login.php?a=logout" color=#CCFFFF>Click Here To Logout</a><br><a href="members.php" color=#CCFFFF>Click Here To Goto the Main Page</a></font></td>
   </tr>
   <tr><td colspan=2 height=14 bgcolor="#1D2B60"></td></tr>
   <tr>
<td width="100%" height="100%" colspan=2 bgcolor="white" bordercolordark="black" align="center" bordercolorlight="black" border=1 valign="top">
<br><? include $CONTENT; ?><br><br>
</td>
</tr>
</table>
</body>

<style type="text/css">
table.t {border: thin solid #000000; background-color: #FFFFFF}
td.th {border: thin solid #000000; background-color:#FFFFFF; font-style: bold 12px; text-align:center; font-size: 12px; font-weight:bold}
td.t {border: thin solid #000000; background-color:#FFFFFF; font-style: bold 12px; text-align:center; font-size: 12px; font-weight:bold}
td.te {border: thin solid #000000; background-color:#FFFFFF; text-align:center; }
td.ac1 {border: thin solid #000000; background-color:#FFFFFF; text-align:left; }
td.ac2 {border: thin solid #000000; background-color:#FFFFFF; text-align:left; }
a.t {color: #3366FF}
a.msg {color: #3366FF}
font.msg {font-style: bold 12px; font-size: 12px; font-weight:bold}
</style>
<script language='javascript'>
function deleteconfirm()
{
   if (confirm("Are you sure you want to delete all links?"))
      document.location = "members.php?p=delete";
}
function resetconfirm()
{
   if (confirm("Are you sure you want to reset the hit count for all links?"))
      document.location = "members.php?p=reset";
}

</script>
</html>

Thank you,
Sylvain

Connect Data Base To Live Server

Similar Tutorials

hello sir,

i have to connect database to my live server using

<?php

define('DB_HOST', 'localhost');
define('DB_NAME', 'oop_pdo_crud');
define('DB_USER', 'root');
define('DB_PASS', '');

?>

or

Check Username & Password In Data Base With Curl

Similar Tutorials

Hi guys
Can someone help me about this:
The php code can be revise username and password with CURL then check database and if username & password is correct return true else false.

Thanks

Issues With Switch And Retrieving Info From Data Base

Similar Tutorials

This is for band website for its event listings. The main event page list everything fine, but once selecting the "Details" link which activates the switch event. Its no longer showing anything. When I had one event in the data base it worked fine, but now I have 3 events in the database and now its not working.

Page can be viewed he http://184.66.66.169/ffy/event.php

Code: [Select]
<?php
//Event Code Here

$eventid = (isset($_GET["id"])) ? intval($_GET["id"]) : 0;

switch($_GET["list"]=='true')
{
case "0":
if($_GET["id"]== $eventid)
{

$result = mysql_query("SELECT * FROM event ORDER by eventdate DESC");
if (!$result) {
   die("query failed: " . msql_error());
}

while ($row = mysql_fetch_array($result)) {
list($id, $eventdate, $header, $description, $image, $location) = $row;
$description = nl2br($description);
$eventdate = date("M j, Y",strtotime("$eventdate"));

print('
<table width="680" border="0" cellpadding="14" cellspacing="0">
<tr>
<td>
<div class="myFont"><font size="+1" color="#4e8baf">'.$eventdate.' - </font><font size="+1"><b>'.$header.'</b></font></div>
<font size="-2" color="#CCCCCC"><a href="event.php?list=true&eventid='.$id.'">Details</a></font><br />
<hr color="#FFFFFF" width="100" align="left" size="1">
</td>
</tr>
  </table>
');

}}
break;
case "true":
if($_GET["id"]==$eventid)
{

$resultd = mysql_query("SELECT * FROM event WHERE id=$eventid LIMIT 1");
if (!$resultd) {
   die("query failed: " . msql_error());
}

while ($row = mysql_fetch_array($resultd)) {
list($id, $eventdate, $header, $description, $image, $location) = $row;
$description = nl2br($description);
$eventdate = date("M j, Y",strtotime("$eventdate"));
print('
<table width="680" border="0" cellpadding="14" cellspacing="0">
<tr>
<td>
<div class="myFont"><font size="+1" color="#4e8baf">'.$eventdate.' - </font><font size="+1"><b>'.$header.'</b></font></div>
'.$description.'<br />
<hr color="#FFFFFF" width="100" align="left" size="1">
<center>
'.$location.'
</center>
</td>
</tr>
  </table>
');

}
break;
}}

?>

Google Base Rss Php Problem

Similar Tutorials

Hi

Hopefully someone can help me. My knowledge of PHP doesnt go any further than looking at identifying areas of code and copy and paste - as basic as you get!

Basically i have a php script installed that produces an RSS feed for me to use with google base. There is a little problem were it does not pull the sale price(known as special) into googlebase and it will instead show the original price. I have identified what needs to be changed but i dont know the correct syntax.

I somehow need to get something similar to the following IF ELSE into the code below (this is taken from the same php script that shows the special price on the actual rss feed)

foreach ($product_data as $result) {
   $special = $model_catalog_product->getProductSpecial($result['product_id']);
   if ($special) {
      $price = $special;
   } else {
      $price = $result['price'];
   }
   if ($useTax) {
      $price = $currency->format($tax->calculate($price, $result['tax_class_id'], $config->get('config_tax')), $currency->getCode());
   } else {
      $price = $currency->format($price, $currency->getCode());
   }

The code below is were i need the If Else inserted.

<?php foreach ($products as $product) { ?>
   <item>
<title><?php echo htmlspecialchars($product['name'], ENT_QUOTES, 'utf-8'); ?></title>
<g:brand><?php echo htmlspecialchars($product['brand'], ENT_QUOTES, 'utf-8'); ?></g:brand>
      <g:condition>new</g:condition>
      <g:product_type><?php echo $taxonomy; ?></g:product_type>
<description><?php echo htmlspecialchars($product['desc'], ENT_QUOTES, 'utf-8'); ?></description>
<link><?php echo str_replace('&', '&', $product['href']); ?></link>
<pubDate><?php echo $product['add_date']; ?></pubDate>

<g:id><?php echo (int)$product['id']; ?></g:id>
      
<g:image_link><?php echo $product['thumb']; ?></g:image_link>
      
      <g:price><?php echo $product['price']; ?></g:price>
      <g:mpn><?php echo htmlspecialchars($product['model'], ENT_QUOTES, 'utf-8'); ?></g:mpn>
      <g:weight><?php echo $product['weight']; ?></g:weight>
      <g:currency><?php echo $config->get('config_currency'); ?></g:currency>
   </item>
<?php } ?>

The <g:price> is what googlebase reads to get the price of the product. The problem seems to be that there is no if else statement here to output the special price if there is one.

Any help would be greatly appreciated, i tired emailing the developer but i have been ignored and as you can see i'm pretty clueless

Moved: .htaccess Rewrite Base Problem

Similar Tutorials

This topic has been moved to mod_rewrite.

http://www.phpfreaks.com/forums/index.php?topic=325281.0

Problem Connecting To Mysql

Similar Tutorials

<?php
$username="a7564065_si";
$password="*****";
$database="a7564065_food";

mysql_connect(mysql4.000webhost.com,$username,$password);
...

I am trying to connect to mysql but having trouble.
The host name: mysql4.000webhost.com

I get the error:

Parse error: syntax error, unexpected T_DNUMBER in /home/a7564065/public_html/Index.html on line 17

Any ideas?

Problem Connecting A Cms To Gateway

Similar Tutorials

hi,
i`m trying to connect a cms to a gateway but in my country i cant use paypal or any other known gateways so i use a local bank for payments .
i want to change cms`s paypal gateway to the local one these are the sample codes they gave me
: sender.php

  

<?php     function send($url,$api,$amount,$redirect){         $ch = curl_init();         curl_setopt($ch,CURLOPT_URL,$url);         curl_setopt($ch,CURLOPT_POSTFIELDS,"api=$api&amount=$amount&redirect=$redirect");         curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);         curl_setopt($ch,CURLOPT_RETURNTRANSFER,true);         $res = curl_exec($ch);         curl_close($ch);         return $res;     }     function get($url,$api,$trans_id,$id_get){         $ch = curl_init();         curl_setopt($ch,CURLOPT_URL,$url);

        curl_setopt($ch,CURLOPT_POSTFIELDS,"api=$api&id_get=$id_get&trans_id=$trans_id");         curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);         curl_setopt($ch,CURLOPT_RETURNTRANSFER,true);         $res = curl_exec($ch);         curl_close($ch);         return $res;     } ?>

: send.php



<?php     include_once("sender.php");     $url = 'http://payline.ir/payment/gateway-send';     $api = ' Your-API ';     $amount = 1000;     $redirect = 'REDIRECT-PAGE';     $result = send($url,$api,$amount,$redirect);     if($result > 0 && is_numeric($result)){         $go = "http://payline.ir/payment/gateway-$result";         header("Location: $go");     } ?>  




:  get.php





<?php     include_once("sender.php");     $url = 'http://payline.ir/payment/gateway-result-second';     $api = ' Your-API';     $trans_id = $_POST['trans_id'];     $id_get = $_POST['id_get'];     $result = get($url,$api,$trans_id,$id_get); ?>

and this one is for cms `s paypal gate way

  define("_VALID_PHP", true);

  define("_PIPN", true);



  ini_set('log_errors', true);

  ini_set('error_log', dirname(__file__) . '/ipn_errors.log');


  if (isset($_POST['payment_status'])) {

      require_once ("../../init.php");

      require_once (BASEPATH . "lib/class_pp.php");


      $pp = Co :getRow(Membership::gTable, "name", "paypal");


      $listener = new IpnListener();

      $listener->use_live = $pp->live;

      $listener->use_ssl = true;

      $listener->use_curl = false;


      try {

          $listener->requirePostMethod();

          $ppver = $listener->processIpn();

      }

      catch (exception $e) {

          error_log($e->getMessage(), 3, "pp_errorlog.log");

          exit(0);

      }


      $payment_status = $_POST['payment_status'];

      $receiver_email = $_POST['business'];

      $mc_currency = $_POST['mc_currency'];

      list($membership_id, $user_id) = explode("_", $_POST['item_number']);

      $mc_gross = $_POST['mc_gross'];

      $txn_id = $_POST['txn_id'];


      $getxn_id = Co :verifyTxnId($txn_id);

      $price = getValueById("price", Membership::mTable, intval($membership_id));

      $v1 = compareFloatNumbers($mc_gross, $price, "=");


      if ($ppver) {

          if ($_POST['payment_status'] == 'Completed') {

              if ($receiver_email == $pp->extra && $v1 == true && $getxn_id == true) {

                  $sql = "SELECT * FROM " . Membership::mTable . " WHERE id=" . (int)$membership_id;

                  $row = $db->first($sql);


                  $username = getValueById("username", Users::uTable, (int)$user_id);


                  $data = array(

                      'txn_id' => $txn_id,

                      'membership_id' => $row->id,

                      'user_id' => (int)$user_id,

                      'rate_amount' => (float)$mc_gross,

                      'ip' => $_SERVER['REMOTE_ADDR'],

                      'date' => "NOW()",

                      'pp' => "PayPal",

                      'currency' => sanitize($mc_currency),

                      'status' => 1);


                  $db->insert(Membership::pTable, $data);


                  $udata = array(

                      'membership_id' => $row->id,

                      'mem_expire' => $user->calculateDays($row->id),

                      'trial_used' => ($row->trial == 1) ? 1 : 0,

                      'memused' => 1);


                  $db->update(Users::uTable, $udata, "id=" . (int)$user_id);


                  /* == Notify Administrator == */

                  require_once (BASEPATH . "lib/class_mailer.php");

                  $row2 = Co :getRowById(Content::eTable, 5);


                  $body = str_replace(array(

                      '[USERNAME]',

                      '[ITEMNAME]',

                      '[PRICE]',

                      '[STATUS]',

                      '[PP]',

                      '[IP]'), array(

                      $username,

                      $row->{'title' . Lang::$lang},

                      $core->formatMoney($mc_gross),

                      "Completed",

                      "PayPal",

                      $_SERVER['REMOTE_ADDR']), $row2->{'body' . Lang::$lang}

                      );


                  $newbody = cleanOut($body);


                  $mailer = Mailer::sendMail();

                  $message = Swift_Message::newInstance()

                            ->setSubject($row2->{'subject' . Lang::$lang})

                            ->setTo(array($core->site_email => $core->site_name))

                            ->setFrom(array($core->site_email => $core->site_name))

                            ->setBody($newbody, 'text/html');


                  $mailer->send($message);

                  Security::writeLog($username . ' ' . Lang::$word->_LG_PAYMENT_OK . ' ' . $row->{'title' . Lang::$lang}, "", "yes", "payment");

              }


          } else {

              /* == Failed Transaction= = */

              require_once (BASEPATH . "lib/class_mailer.php");

              $row2 = Co :getRowById(Content::eTable, 6);

              $itemname = getValueById("title" . Lang::$lang, Membership::mTable, $membership_id);

              $username = getValueById("username", Users::uTable, (int)$user_id);


              $body = str_replace(array(

                  '[USERNAME]',

                  '[ITEMNAME]',

                  '[PRICE]',

                  '[STATUS]',

                  '[PP]',

                  '[IP]'), array(

                  $username,

                  $itemname,

                  $core->formatMoney($mc_gross),

                  "Failed",

                  "PayPal",

                  $_SERVER['REMOTE_ADDR']), $row2->{'body' . Lang::$lang}

                  );


              $newbody = cleanOut($body);


              $mailer = $mail->sendMail();

              $message = Swift_Message::newInstance()

                        ->setSubject($row2->{'subject' . Lang::$lang})

                        ->setTo(array($core->site_email => $core->site_name))

                        ->setFrom(array($core->site_email => $core->site_name))

                        ->setBody($newbody, 'text/html');


              $mailer->send($message);


              Security::writeLog(Lang::$word->_LG_PAYMENT_ERR . $username, "", "yes", "payment");


          }

      }

  }

?>

i`ll be grateful if you help me on this

Problem Connecting To Mysql Db Using Included Connect File

Similar Tutorials

So, I feel like I am running up against some beginner's problem. So I am hoping this should be an easy fix. I have had a bit of trouble finding the right search terms to find a fix for this, so I am sorry ahead of time if there is already a post on this, please point me towards it.

I am running PHP 4.4.9 and MySQL client API 4.1.22, in case that is of use.

I can get the following to work and provide the appropriate output. Note in this first case that the connection info is in the same file as the call to it.

<?php
// set database access information
define ('DB_USER', "*****");
define ('DB_PASSWORD', "*****");
define ('DB_HOST', "localhost");
define ('DB_NAME', "content");

// database connection protocol
$dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) or die ('Could not connect to MySQL: Error #' . mysql_errno() . ' - ' . mysql_error());

mysql_select_db (DB_NAME) or die ('Could not connect to MySQL: Error #' . mysql_errno() . ' - ' . mysql_error());

$query = "SELECT content_element_title FROM content_main";

$result = mysql_query ($query);

while ($row = mysql_fetch_array ($result, MYSQL_ASSOC))

{

echo ("<p>" . $row[content_element_title] . "</p>");

}
unset($dbc);

?>

My problem is, however, that when I separate the connection info into a separate file, I have been having problems. I think I got past the method calling the connection info not being able to see it, but now it isn't returning anything - should be returning

"<p>" . $row[content_element_title] . "</p>",

for which there are three rows in the db.

Here is what the two files look like separated:

kinnect.php

<?php

// set database access information
define ('DB_USER', '*****');
define ('DB_PASSWORD', '*****');
define ('DB_HOST', 'localhost');
define ('DB_NAME', 'content');

//// database connection protocol
$dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) or die ('Could not connect to MySQL: Error #' . mysql_errno() . ' - ' . mysql_error());

mysql_select_db (DB_NAME, $dbc) or die ('Could not connect to MySQL: Error #' . mysql_errno() . ' - ' . mysql_error());

?>
file.php

<?php

require_once ("correctpathto/kinnect.php");

$query = "SELECT content_element_title FROM content_main";

$result = mysql_query ($query, $dbc);

while ($row = mysql_fetch_array ($result, MYSQL_ASSOC))

{

echo ("<p>" . $row[content_element_title] . "</p>");

}
unset($dbc);
?>

So what am I doing wrong? I am getting these error messages now.

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /Users/max/Sites/rdbase-llc/preliminary/connecttroubleshoot.php on line 18

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /Users/max/Sites/rdbase-llc/preliminary/connecttroubleshoot.php on line 20

Thanks ahead of time for any help!

What To Do With My Php Code Base?

Similar Tutorials

I've got a monumental problem on my hands... 😂

The website that I've been working on - for years - for my startup business is just about done, but because I have taken so long to code things, my HTML is very outdated, and is *not* mobile friendly.

I was hoping to go live with my website in the next month or two, but considering that over half of Internet users are on mobile, it makes me wonder if I should release my rigid, un-responsive website as-is, or take months trying to re-tool things.

That, in itself, will be a monumental task, BUT it also makes me wonder if I will break all of my tens of thousands of lines of PHP and MySQL?

A very loaded question, for sure, but if you were me, what would you do?

What I am really fearful of is FUBAR'ing my PHP code which I have spent thousands of hours testing and am hesitant to even blink at?!

Edited January 3 by SaranacLake

Meaning Of Base Tag

Similar Tutorials

Hi, Can you please tell me in witch conditions should be used base tag. If have a website that base tag it's define in header like: <base href="http://www.website.com/"> What's the meaning of this ? Thank you