using OUT in PDO and PHP - Web Development Discussion Boards

According to Wikipedia[^] the Indian Copyright Law automatically grants you the copyright for intellectual works that you're the author of. And it doesn't say anything about the need to register or even pay for it (it's the same here in Germany). I guess the website you have found there charging for "issuing copyrights" is a scam.

I have inherited a website and need to make some changes. It would be nice to know before i start, what files are used/called within each page on the website.
Apart from Google sitemap (which I cant get to work at home, so don't want to try at work), is there a way to get these results.

On the assumption that you are in a situation where no external tools will be available (for whatever reason) and there is nothing built in to the development tool you are using (or it is broke and wont be fixed) you only really have two choices:
1. Open every file and look for all the links
2. Do what I did and create a web app that will open all the files for you and search them for what you're looking for.

Following is the code for jqgrid -
html page-

XML

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

XML

<script src="Scripts/JQGridReq/jquery-1.9.0.min.js"></script>
    <link href="Scripts/JQGridReq/jquery-ui-1.9.2.custom.css" rel="stylesheet" />
    <script src="Scripts/JQGridReq/jquery.jqGrid.js"></script>
    <link href="Scripts/JQGridReq/ui.jqgrid.css" rel="stylesheet" />
    <script src="Scripts/JQGridReq/grid.locale-en.js"></script>

<title>

jQuery("#jqGrid").jqGrid({
url: 'Handler1.ashx',
datatype: "json",
colNames: ['S_Course_Name', 'S_Course_Desc'],
colModel: [
{ name: 'S_Course_Name', index: 'S_Course_Name', width: 50, stype: 'text', editable: true },
{ name: 'S_Course_Desc', index: 'S_Course_Desc', width: 80, stype: 'text', sortable: true, editable: true }

],
rowNum: 10,
mtype: 'GET',
loadonce: true,
rowList: [10, 20, 30],
pager: '#Pager',
sortname: 'S_Course_Name',
viewrecords: true,
sortorder: 'desc',
caption: "Course Detail",
width: 500,
editurl: 'Handler1.ashx'
});

$('#jqGrid').jqGrid('navGrid', '#Pager',
{
edit: true,
add: false,
del: true,
search: true,
searchtext: "Search",
addtext: "Add",
edittext: "Edit",
deltext: "Delete"
},
{ //EDIT
// height: 300,
// width: 400,
// top: 50,
// left: 100,
// dataheight: 280,
closeOnEscape: true, //Closes the popup on pressing escape key
reloadAfterSubmit: true,
drag: true,
afterSubmit: function (response, postdata) {
if (response.responseText == "") {

$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid'); //Reloads the grid after edit
return [true, '']
}
else {
$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid'); //Reloads the grid after edit
return [false, response.responseText]//Captures and displays the response text on th Edit window
}
},
editData: {
EmpId: function () {
var sel_id = $('#jqGrid').jqGrid('getGridParam', 'selrow');
var value = $('#jqGrid').jqGrid('getCell', sel_id, 'S_Course_Name');
return value;
}
}
},
{
closeAfterAdd: true, //Closes the add window after add
afterSubmit: function (response, postdata) {
if (response.responseText == "") {

$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid')//Reloads the grid after Add
return [true, '']
}
else {
$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid')//Reloads the grid after Add
return [false, response.responseText]
}
}
},
{ //DELETE
closeOnEscape: true,
closeAfterDelete: true,
reloadAfterSubmit: true,
closeOnEscape: true,
drag: true,
afterSubmit: function (response, postdata) {
if (response.responseText == "") {

$("#jqGrid").trigger("reloadGrid", [{ current: true }]);
return [false, response.responseText]
}
else {
$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid');
return [true, response.responseText]
}
},
delData: {
EmpId: function () {
var sel_id = $('#jqGrid').jqGrid('getGridParam', 'selrow');
var value = $('#jqGrid').jqGrid('getCell', sel_id, 'S_Course_Name');
return value;
}
}
},
{//SEARCH
closeOnEscape: true

}
);

Handler1.ashx.cs-

public class Handler1 : IHttpHandler
{

public void ProcessRequest(HttpContext context)
{

context.Response.ContentType = "application/json";
System.Collections.Specialized.NameValueCollection forms = context.Request.Form;
string strOperation = forms.Get("oper");

string strResponse = string.Empty;

if (strOperation == null)
{

DataTable dt = getCourseDetail();
var jsonSerializer = new JavaScriptSerializer();
context.Response.Write(jsonSerializer.Serialize(GetCourseDetailListFromDataTable(dt)));

}
else if (strOperation == "del")
{
//var query = Query.EQ("_id", forms.Get("EmpId").ToString());
//collectionEmployee.Remove(query);
//strResponse = "Employee record successfully removed";
//context.Response.Write(strResponse);
}
else
{
//string strOut = string.Empty;
//AddEdit(forms, collectionEmployee, out strOut);
//context.Response.Write(strOut);
}
}

public bool IsReusable
{
get
{
return false;
}
}

public static DataTable getCourseDetail()
{
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["connectionstring"].ToString();
using (SqlConnection con = new SqlConnection(strConnection))
{
con.Open();
SqlCommand sqlcomm = new SqlCommand("SELECT TOP 5 S_Course_Name,S_Course_Desc FROM T_Course_Master", con);
//SqlCommand sqlcomm = new SqlCommand("SELECT TOP 10 I_Course_ID,I_CourseFamily_ID,S_Course_Code,S_Course_Name,S_Course_Desc FROM T_Course_Master", con);
SqlDataAdapter da = new SqlDataAdapter(sqlcomm);
DataTable table = new DataTable();

da.Fill(table);
//string data = GetJson(table);
//return data;
return table;
}

}

public static string GetJson(DataTable dt)
{
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List> rows = new List>();
Dictionary row;
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}

return serializer.Serialize(rows);
}

private List GetCourseDetailListFromDataTable(DataTable dt)
{

//List type object of the property class
List courseDetailClass = new List();
foreach (DataRow dr in dt.Rows)
{
//Object of the propery class
CourseDetail objCourseDetail = new CourseDetail();
//asign values
objCourseDetail.S_Course_Name = dr["S_Course_Name"].ToString();
objCourseDetail.S_Course_Desc = dr["S_Course_Desc"].ToString();

//add one row to the list
courseDetailClass.Add(objCourseDetail);
}
//return final list
return courseDetailClass;
}

method is getting called but data is not displayed in the grid.I m getting the json string also proper format. kindly some help on this.

Please edit this, remove all the code not relevant to the problem, and explain where the problem occurs. Also ensure all your code is within <pre></pre> tags so it is readable.

Hello Guys,

Any urgent help on this would be highly appreciated. am about to start working on a project which involves retrieving data from a remote API. its gonna be a web-project whereby a user already registered on a desktop application would be able to view their basic and other information on a website.

i understand i need to make API calls to be able to make the information saved on the desktop database available for the user on the web. but i dont how to start.

Please i need guidelines/tutorials/help to kick-off.

thanks in advance.

IsoftTech

The database for your website will not be saved on the desktop, instead it will be present on the server of your hosting provider (or if you're hosting it yourself, then on your own hosting system). Secondly, API calls, and the simple website has a difference. API calls are used, when you allow third-party applications to use your own framework and let them use the data of the user. Since it is your own application why do you need to create an API?

If you're going to create a desktop application for your website, then yes, you will need an API because now your desktop application would be as a third-party client accessing the data.

The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

Hi,

I am trying to use OUT parameter with PDO and PHP to return an email address from my stored pocedure but getting this error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1414 OUT or INOUT argument 13 for routine hrms.sp_web_add_new_employee_leave is not a variable or NEW pseudo-variable in BEFORE trigger' in /home/jassimuser/mybluefile.com/submit_leave.php:37 Stack trace: #0 /home/jassimuser/mybluefile.com/submit_leave.php(37): PDOStatement->execute() #1 {main} thrown in /home/jassimuser/mybluefile.com/submit_leave.php on line 37

this is my code:

PHP

$mysql_query = $mysql_connection->prepare('CALL sp_web_add_new_employee_leave(:param_employee_id, :param_is_paid, :param_category, :param_payment, :param_date_from, :param_date_to, :param_total_days, :param_flight_entitlement, :param_flight_destination, :param_address_while_traveling, :param_leave_remarks, :param_created_user, :reporting_to_email)');

$mysql_query->bindParam(':param_employee_id', $_SESSION["employee_number"], PDO::PARAM_STR);
$mysql_query->bindParam(':param_is_paid', $leave_paid, PDO::PARAM_BOOL);
$mysql_query->bindParam(':param_category', $leave_category, PDO::PARAM_STR);
$mysql_query->bindParam(':param_payment', $leave_payment, PDO::PARAM_STR);
$mysql_query->bindParam(':param_date_from', $leave_from, PDO::PARAM_STR);
$mysql_query->bindParam(':param_date_to', $leave_to, PDO::PARAM_STR);
$mysql_query->bindParam(':param_total_days', $leave_days, PDO::PARAM_STR);
$mysql_query->bindParam(':param_flight_entitlement', $flight_entitlement, PDO::PARAM_STR);
$mysql_query->bindParam(':param_flight_destination', $flight_destination, PDO::PARAM_STR);
$mysql_query->bindParam(':param_address_while_traveling', $address_while_traveling, PDO::PARAM_STR);
$mysql_query->bindParam(':param_leave_remarks', $leave_comment, PDO::PARAM_STR);
$mysql_query->bindParam(':param_created_user', $_SESSION["employee_number"], PDO::PARAM_STR);
$mysql_query->bindParam(':reporting_to_email', $reporting_to_email, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 255);
// $mysql_query->bindParam(':param_created_ip', $_SERVER['REMOTE_ADDR'], PDO::PARAM_STR);

$mysql_query->execute();

and line 37 is the ->execute()

How can I fix this please?

Technology News @ www.JassimRahma.com

Do you understand the error?

There are only 10 types of people in the world, those who understand binary and those who don't.

What if my take over the world project involve people partaking of their money for my benefit?!
I'd like to provide payment options on my website (no evil paypal please) and I have no idea how!
Any tip about which payment broker I could use please?

All in one Menu-Ribbon Bar
DirectX for WinRT/C# since 2013!
Taking over the world since 1371!

PayPal would be a good choice (Google Wallet can also be taken into considerations), but since you're having "take over the world", there won't be anything left and thus you would have to write your own. Smile | :)

The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

Google Wallet, interesting...
Though it's for a Windows Desktop app, not sure it will help much...

All in one Menu-Ribbon Bar
DirectX for WinRT/C# since 2013!
Taking over the world since 1371!

Oh, then don't you know about System.Net namespace collection? You can use these namespaces in your applications to create HttpRequests to the internet applications such as Google Wallet API.

System.Net namespaces are very helpful in working with networks and ports, you can read more on this at MSDN[^].

The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

How about a link to Google Wallet API page instead!? Poke tongue | ;-P

All in one Menu-Ribbon Bar
DirectX for WinRT/C# since 2013!
Taking over the world since 1371!

That would consume the WebClient by you, or you would need to include a WebBrowser control. Which also would make the HTTP requests to your desired web page (which is the Google Wallet API web page). You know this is a cycle that starts and ends at the very same point, the System.Net namespace.

I would go with programming my own control and getting the response from the server using either a WebClient, or by downloading the response stream. Smile | :)

The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

Super Lloyd wrote:
people partaking of their money for my benefit

"Partaking[^]" is the wrong word - you're suggesting that they either participate in, or take a share of their money, neither of which would involve them handing any money over to you. Smile | :)

Either "people parting with their money" or "people being relieved of their money" would work.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

While it doesn't address my issue, I have t o admit you are indeed write!
Thanks for the correction!
Me trying to chew more English than I yet understand! OMG | :OMG:

All in one Menu-Ribbon Bar
DirectX for WinRT/C# since 2013!
Taking over the world since 1371!

Hi,

I am getting the following error after uploading the file to the host:

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/jassimuser/mybluefile.com/login_user.php:1) in /home/jassimuser/mybluefile.com/includes/php_header.php on line 3 

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/jassimuser/mybluefile.com/login_user.php:1) in /home/jassimuser/mybluefile.com/includes/php_header.php on line 3 

Warning: Cannot modify header information - headers already sent by (output started at /home/jassimuser/mybluefile.com/login_user.php:1) in /home/jassimuser/mybluefile.com/login_user.php on line 52

but it's working fine on my localhost.

login_user start like this:

PHP

include('includes/php_header.php');
include($_SESSION["bluefile_absolute_path"] . '/includes/Mobile_Detect.php');
include($_SESSION["bluefile_absolute_path"] . '/includes/password_hash.php');
include($_SESSION["bluefile_absolute_path"] . '/includes/connect2db.php');

and my php_header is:

PHP

ob_start();
if(!isset($_SESSION)) { session_start(); }

$_SESSION["bluefile_absolute_path"] = $_SERVER["DOCUMENT_ROOT"];
$_SESSION["bluefile_domain_name"] = "http://www.mybluefile.com/";

$_SESSION["div_max_width"] = "700";

// set max_execution_time;
ini_set('max_execution_time', 300); //300 seconds = 5 minutes
ini_set("session.cookie_lifetime","3600"); //an hour

// report all errors;
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL & ~E_NOTICE);
// report all errors;

Technology News @ www.JassimRahma.com

Dunno which forum to ask, so I thought I would ask here...
Warning this question contains and requires 0 code and requires 0 code answer! Blush | :O

I am working a super secret take over the world desktop application!
I created an installer for it as well as a WebSite.
I just bought a SSL certificate for my website and I can access it with HTTPS

Shouldn't there be some way for me to use that SSL certification to sign my MSI/Installer for the app?

I dunno what exactly is the SSL certificate... my website now accept HTTPS without security prompt but I didn't get any particular file...

Any clues?
Thanks! Smile | :)

All in one Menu-Ribbon Bar
DirectX for WinRT/C# since 2013!
Taking over the world since 1371!

An SSL certificate will usually have the "key usage" restricted to "server authentication" (and possibly "client authentication"). That means you can't use it for code-signing, email protection, time-stamping or OCSP signing.

RFC5280 Section 4.2.1.12 - Extended Key Usage[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Damn!!

All in one Menu-Ribbon Bar
DirectX for WinRT/C# since 2013!
Taking over the world since 1371!

In theory a SSL certificate can be used to digitally sign files/code, however it depends on the properties of that SSL certificate...
The SSL have to have keyUsage.digitalSignature flag to set to use it for file signing, and extendedKeyUsage.codeSigning for code signing...
As you bought the SSL for web site (probably via your host) you will not have these flags set...
You may ask to extend the certificate or get a new one for file/code signing...

Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.

Oh, they told me they are gonna send me the CERT file and private key, will see if it helps! Smile | :)

All in one Menu-Ribbon Bar
DirectX for WinRT/C# since 2013!
Taking over the world since 1371!

Then a zero-level confusing answer for you. No you cannot use that SSL certificate to digitally sign your emails etc.

The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

No worries! My hosting provider helped! :P

All in one Menu-Ribbon Bar
DirectX for WinRT/C# since 2013!
Taking over the world since 1371!