Click here to Skip to main content
15,501,180 members
Home / Discussions / Web Development
   

Web Development

 
QuestionDeployments Pin
#realJSOP27-Feb-21 5:57
mva#realJSOP27-Feb-21 5:57 
QuestionASP.Net Web API Controller Question Pin
Kevin Marois26-Feb-21 8:47
professionalKevin Marois26-Feb-21 8:47 
QuestionPHP7+, working with datetime stored in cookie with json format Pin
jkirkerx17-Feb-21 12:48
professionaljkirkerx17-Feb-21 12:48 
AnswerRe: How To create a table in MS Access contain more than 255 filed ? Pin
Richard Deeming14-Feb-21 23:05
mveRichard Deeming14-Feb-21 23:05 
QuestionBootstrap - How do I make an icon a href link Pin
Jim McElhiney10-Feb-21 16:33
MemberJim McElhiney10-Feb-21 16:33 
AnswerRe: Bootstrap - How do I make an icon a href link Pin
Peter_in_278012-Feb-21 14:58
professionalPeter_in_278012-Feb-21 14:58 
QuestionPHP V7.4.14, convert this database function, understanding mssql_fetch_field to sqlsrv_fetch Pin
jkirkerx10-Feb-21 10:36
professionaljkirkerx10-Feb-21 10:36 
AnswerRe: PHP V7.4.14, convert this database function, understanding mssql_fetch_field to sqlsrv_fetch Pin
jkirkerx12-Feb-21 14:14
professionaljkirkerx12-Feb-21 14:14 
I think I figured it out.
What I'm trying to get is the column names in the meta data of the table.
The example use a foreach loop, so now I know how to use foreach in PHP V7+
Seems needs some work and polishing.
C#
public static function dbSelectQuery($sqlQuery): array {

<pre>
// print_r(debug_backtrace());
$Rows = array();
$rgFields = array();
$params = array();
$options =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );

$conn = clsDbConnect::createConn();
$resQuery = sqlsrv_query($conn, $sqlQuery, $params, $options) or die(" cls_db_tools 128: " . $sqlQuery . print_r(sqlsrv_errors()) );
$rowCount = sqlsrv_num_rows($resQuery);
$fieldCount = sqlsrv_num_fields($resQuery);

$cIndex = 0;
foreach( sqlsrv_field_metadata( $resQuery ) as $fieldMetadata ) {

        $columnName = $fieldMetadata['Name'];
        $rgFields[$cIndex] = $columnName;
        $cIndex++;

}

for ($i = 0; $i < $rowCount; $i++) {

$row = sqlsrv_fetch_array($resQuery,SQLSRV_FETCH_NUMERIC);
for ($col = 0; $col < $fieldCount; $col++) {
$Rows[$i][$rgFields[$col]] = rtrim($row[$col]);
}

}

sqlsrv_free_stmt($resQuery);
return $Rows;

}

If it ain't broke don't fix it
Discover my world at jkirkerx.com

Questionphp 7.4.14 convert smalldatetime to string for html display Pin
jkirkerx9-Feb-21 13:14
professionaljkirkerx9-Feb-21 13:14 
AnswerRe: php 7.4.14 convert smalldatetime to string for html display Pin
Richard Deeming9-Feb-21 23:00
mveRichard Deeming9-Feb-21 23:00 
GeneralRe: php 7.4.14 convert smalldatetime to string for html display Pin
jkirkerx10-Feb-21 6:19
professionaljkirkerx10-Feb-21 6:19 
GeneralRefresh a div with pjax Pin
Member 150664316-Feb-21 10:32
MemberMember 150664316-Feb-21 10:32 
GeneralRe: Refresh a div with pjax Pin
OriginalGriff6-Feb-21 10:45
mveOriginalGriff6-Feb-21 10:45 
Question500 Error Pin
#realJSOP4-Feb-21 6:49
mva#realJSOP4-Feb-21 6:49 
AnswerRe: 500 Error Pin
Richard Deeming4-Feb-21 6:59
mveRichard Deeming4-Feb-21 6:59 
GeneralRe: 500 Error Pin
#realJSOP4-Feb-21 8:33
mva#realJSOP4-Feb-21 8:33 
GeneralRe: 500 Error Pin
Richard Deeming4-Feb-21 22:42
mveRichard Deeming4-Feb-21 22:42 
GeneralRe: 500 Error Pin
#realJSOP7-Feb-21 10:08
mva#realJSOP7-Feb-21 10:08 
QuestionVS code/Live Server Browser issue Pin
ISHYY4-Feb-21 5:42
MemberISHYY4-Feb-21 5:42 
Questiondeployment using "FTP Passive" Pin
Super Lloyd4-Feb-21 2:56
MemberSuper Lloyd4-Feb-21 2:56 
QuestionPHP 7.4, best practice to establish a database connection Pin
jkirkerx2-Feb-21 9:10
professionaljkirkerx2-Feb-21 9:10 
QuestionWhich will be the best web development course for kids? Pin
Annet Rose14-Jan-21 0:35
MemberAnnet Rose14-Jan-21 0:35 
AnswerRe: Which will be the best web development course for kids? Pin
Richard MacCutchan14-Jan-21 1:37
mveRichard MacCutchan14-Jan-21 1:37 
RantHTML Emails - Printing Pin
Gripper 1070963823-Dec-20 7:08
MemberGripper 1070963823-Dec-20 7:08 
QuestionPHP 4.7, JSON and HTTP response header payload, json_encode Pin
jkirkerx19-Dec-20 12:31
professionaljkirkerx19-Dec-20 12:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.